start and stop oracle

[roadrunner_1]

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

[Jeff Schussele · Accepted solution]

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

[A. Clay Stephenson]

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.

[roadrunner_1]

No points to answer posted hereafter...

[Rory R Hammond]

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