cancel
Showing results for 
Search instead for 
Did you mean: 

start and stop oracle

SOLVED
Go to solution
roadrunner_1
Regular Advisor

start and stop oracle

there is no script in the /sbin/init.d directory. How do i stop oracle manually after su to Oracle.

4 REPLIES
Jeff Schussele
Honored Contributor
Solution

Re: start and stop oracle

Hi,

If the oracle user has their environment set up correctly - then:

to stop DN => dbshut
to stop Listener => lsnrctl stop

You could do these as follows:

su - oracle -c dbshut
su - oracle -c "lsnrctl stop"

HTH,
Jeff
PERSEVERANCE -- Remember, whatever does not kill you only makes you stronger!
A. Clay Stephenson
Acclaimed Contributor

Re: start and stop oracle

Assuming that the su - oracle sets the appropriate environment then
svrmgrl
connect internal
shutdown immediate
exit

The above command works if Oracle 8.x and below; if 9x then you use sqlplus and login as system with the appropriate password.



If it ain't broke, I can fix that.
roadrunner_1
Regular Advisor

Re: start and stop oracle

No points to answer posted hereafter...
Rory R Hammond
Trusted Contributor

Re: start and stop oracle

Who cares about points.
Attached is a file that contains startup scripts for the db and the listener.

Note if you use the script to stop the listener. I also tries to shutdown the db

Expect /etc/rc.config.d/oracle
!/sbin/sh
# @(#) $Revision: 72.3 $
#
# ORACLE_START: Set to 1 to start Oracle server
#
ORACLE_START=1
There are a 100 ways to do things and 97 of them are right