1748268 Members
3611 Online
108760 Solutions
New Discussion

Re: databases

 
SOLVED
Go to solution
Rohit Sethi
New Member

databases

How to start oracle DB
4 REPLIES 4
Vineet Kumar
New Member
Solution

Re: databases

To start oracle DB server
Shaikh Imran
Honored Contributor

Re: databases

hi,
Assuming the O.S. is unix
#

su â c oracle

Sun Microsystems Inc. SunOS 5.8 Generic February 2000
$

then type lsnrctl

LSNRCTL> start (To start the listener &
stop - To stop the listener)

then type svrmgrl

SVRMGR> connect internal
(After passing the statement you will get msg Connected)
Connected.
SVRMGR> startup (To startup the database &
shutdown immediate â To shutdown the database)


Regar
I'll sleep when i am dead.
Bharat Katkar
Honored Contributor

Re: databases

Our DBA does it this way:

# sqlplus /nologin
> connect internal;
> starup

If you have more than one database make sure you are connected to desired one by setting proper ENV variables.

Hope that helps.
Regards,


Imran where you on certification.. Are you comfortably while studing???? :))
You need to know a lot to actually know how little you know
Yogeeraj_1
Honored Contributor

Re: databases

hi,

If you are considering automatic startup of your oracle database, you should consider the following:

Files of Interest:
==================
a. $ORACLE_HOME/bin/dbstart
Ensures a clean startup of database instance(s), even after system failure

b.$ORACLE_HOME/bin/dbshut
Ensures a clean shutdown for data base instances

c. /etc/oratab or /var/opt/oracle/oratab
Contains a field that specifies whether a particular database instance should be brought up/down at system startup/shutdown time. By specifying "Y" in this field, the "dbstart" and "dbshut" scripts bring this database instance up or down.

Relevant Files:
===============
a. /sbin/init.d/oracle
contains the main script for doing db startup and shutdown owned by root

b. /etc/rc.config.d/oracle
this file enables/disables automatic startup and shutdown of the databases owned by root

c. /sbin/rc1.d/K100oracle ->/sbin/init.d/oracle
this link tells the system when to execute the Oracle script with the 'stop' command in single user mode during system shutdown

d. /sbin/rc2.d/S990oracle ->/sbin/init.d/oracle
this link tells the system when to execute the Oracle script with the 'start' command in multi-user mode during system startup

Steps:
======
1. Create an executable script /sbin/init.d/oracle for the startup and shutdown of Oracle

Your script should attempt to start the database with the following command:
su - -c <$ORACLE_HOME>/bin/dbstart

Your script should attempt to shut the database with the following command:
su - -c <$ORACLE_HOME>/bin/dbshut

Make sure that the script is owned and executable only by the super user.

2. Create the file /etc/rc.config.d/oracle
This file should contain:
ORACLE_START=1
export ORACLE_START

3. Edit /etc/oratab
ORACLE_SID:ORACLE_HOME:Y|N

where Y or N indicates whether you want the dbstart and dbshut scripts to be run

4. Make /sbin/rc1.d/K100oracle a symbolic link to /sbin/init.d/oracle

5. Make /sbin/rc2.d/S990oracle a symbolic link to /sbin/init.d/oracle

hope this helps!
regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)