OraFAQ Forum: Server Administration » Database running OR not

Home » RDBMS Server » Server Administration » Database running OR not

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Database running OR not [message #62876]

Fri, 20 August 2004 23:31

Murali
Messages: 54
Registered: December 1999

Member

WHAT IS THE COMMAND IN UNIX to know whether ORACLE Instance IS RUNNING OR NOT

Report message to a moderator

Re: Database running OR not [message #62877 is a reply to message #62876]

Sat, 21 August 2004 03:35

Balaji
Messages: 102
Registered: October 2000

Senior Member

type the following command at the $ prompt

ps -ef&#124grep smon

this will give the process ids of all the pmons of all the instances hosted on the server .

hope this works.

with best wishes.

balaji

Report message to a moderator

Database running OR [message #62884 is a reply to message #62876]

Sun, 22 August 2004 03:50

MURALI KRISHNA RAO
Messages: 1
Registered: August 2004

Junior Member

Hi,

I Need what is the command in HP UNIX Oracle 9i Database is running or not.Another question is the what are the critical problems in Oracle 9i Database Administration.

Regards,
MURALI.

Report message to a moderator

Re: Database running OR not [message #62887 is a reply to message #62876]

Sun, 22 August 2004 11:07

Thomas
Messages: 67
Registered: September 1999

Member

You can use this:

$ ps -ef | grep ora_

but sometimes, db can hang and still the background processes to be running. The best way is to:

$ sqlplus /nolog
SQL> connect / as sysdba
SQL> select sysdate from dual;
SQL> exit

You can wrap this in shell script as:

ORA_TEST=`sqlplus -s /nolog <<EOF
connect / as sysdba
select sysdate from dual;
exit
>>EOF

Then test the $ORA_TEST.

Hope that helps,

clio_usa - OCP DBA 8/8i/9i

Oracle DBA Resources
Oracle DBA Forums
USENET Oracle newsgroups

Report message to a moderator

Re: Database running OR not [message #62922 is a reply to message #62876]

Tue, 24 August 2004 11:38

Girdhari Choudhary
Messages: 18
Registered: March 2002

Junior Member

follow the steps
1. get login on solaris as oracle
2. ps -ef &#124grep ora
it will give all the background processes running for oracle.
if it does not run any thing means ur oracle instance is not running

Report message to a moderator

Previous Topic:	Installaing two Oracle Homes
Next Topic:	Import/Export

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 11 09:22:53 CST 2026