topic Re: Oracle startup and shutdown in Redhat Linux in Operating System - Linux

Oracle startup and shutdown in Redhat Linux

gab_in — Thu, 31 May 2007 03:47:32 GMT

Hi,

I have installed oracle 9 on RHEL 3 and started the listner with one script.. now i want to start the database. please tell me how can i manually start the database and verify whether it is running or not.

thanks in advance

Re: Oracle startup and shutdown in Redhat Linux

Ivan Ferreira — Thu, 31 May 2007 10:26:32 GMT

You need something like this:

ORACLE_SID=
echo startup | sqlplus "/ as sysdba"

To verify is the database is up you can do:

echo "select status from v$instance" | sqlplus "/ as sysdba"

Or you can just check the pmon process:

ps -u oracle | grep pmon

Please, take a time to assign points to the answers of your questions, is a good way to thank, for more information see:

http://forums1.itrc.hp.com/service/forums/helptips.do?#28

Re: Oracle startup and shutdown in Redhat Linux

skt_skt — Sat, 02 Jun 2007 11:54:13 GMT