topic Re: start and stop oracle in Operating System - HP-UX

start and stop oracle

roadrunner_1 — Thu, 14 Nov 2002 19:01:45 GMT

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

Re: start and stop oracle

Jeff Schussele — Thu, 14 Nov 2002 19:02:31 GMT

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

Re: start and stop oracle

A. Clay Stephenson — Thu, 14 Nov 2002 19:10:45 GMT

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.

Re: start and stop oracle

roadrunner_1 — Thu, 14 Nov 2002 19:26:33 GMT

No points to answer posted hereafter...

Re: start and stop oracle

Rory R Hammond — Fri, 15 Nov 2002 16:32:52 GMT

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