Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
Showing results for 
Search instead for 
Did you mean: 

start and stop oracle

Go to solution
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.

Jeff Schussele
Honored Contributor

Re: start and stop oracle


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"

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
connect internal
shutdown immediate

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.
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
# @(#) $Revision: 72.3 $
# ORACLE_START: Set to 1 to start Oracle server
There are a 100 ways to do things and 97 of them are right