HPE Community
Operating System - HP-UX
1837779 Members
3963 Online
110119 Solutions
New Discussion

starting and stopping oracle

 
SOLVED
Go to solution
chad_c
Super Advisor

‎09-26-2005 07:53 AM

‎09-26-2005 07:53 AM

starting and stopping oracle

how do i manually stop and start the oracle database from the nnm HPUX command line
0 Kudos
2 REPLIES 2
Steven E. Protter
Exalted Contributor

‎09-26-2005 07:58 AM

‎09-26-2005 07:58 AM

Solution

Re: starting and stopping oracle

Never touch oracle with the root user.

log on as oracle or whatever user owns the binaries

make sure ORACLE_HOME and ORACLE_SID are set.

sqlplus userid/password


or

sqlplus / nolog

shutdown immediate


If you have an oracle stop/start script in /sbin/init.d

/sbin/init.d/oracle stop

That script must do an su - to the oracle suer.

Touching oracle with root risks making shared memory inaccessible and forcing a reboot.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
0 Kudos
chad_c
Super Advisor

‎09-26-2005 08:08 AM

‎09-26-2005 08:08 AM

Re: starting and stopping oracle

steven's reply answered the question woo hoo
0 Kudos
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.