Oracle startup and shutdown in Redhat Linux

[gab_in]

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

[Ivan Ferreira]

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

[skt_skt]

Log in sqlplus â /as sysdbaâ
Startup mount
alter database open;
select status from v$instance