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.
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