Really, the only certain way is to try to log in with sqlplus.

We do a lot of BCVs. Sometimes, there are problems (disks not mounted,
etc) but the database still tries to come up (poor process / error
handling). If you look for pmon, you will see it but if you try to get
into the database with sqlplus, you get an error (depending on the
status).

A quick look at the alert log tells you where you're fubared.

hth,
~Ruth

-----Original Message-----
From: will landstrom
[mailto:oracledba-ezmlmshield-x831464.[Email address protected]
Sent: Friday, September 28, 2007 10:50 AM
To: LazyDBA Discussion
Subject: RE: How can we identify whether exiting oracle server is UP or
DOWN?

Use unix command
Ps -ef | grep pmon

-----Original Message-----
From: Trincia Nicholas F.
[mailto:oracledba-ezmlmshield-x3116824.[Email address protected]
Sent: Friday, September 28, 2007 10:39 AM
To: LazyDBA Discussion
Subject: RE: How can we identify whether exiting oracle server is UP or
DOWN?

You could always check for PMON to see if it is running. This is the
way I always do it.

Nick


-----Original Message-----
From: Claudio Freire
[mailto:oracledba-ezmlmshield-x83500186.[Email address protected]
Sent: Friday, September 28, 2007 10:37 AM
To: LazyDBA Discussion
Subject: RE: How can we identify whether exiting oracle server is UP or
DOWN?


When you connect to the Oracle BD with Sqlplus client in sysdba session,
if he told you, that you are "connected to a idle instance", you BD is
down...

Example:

#Sqlplus /nolog
SQL>Connect / as sysdba
SQL>Connected to an idle instance.
--> server Down

SQL>connect
--> server up


It is a way...their are others way...looking to the OEM (oracle
Enterprise Manager Console), etc

Regards.

-----Original Message-----
From: Pitchai Siva (GE Infra Energy Non-GE)
[mailto:oracledba-ezmlmshield-x48782603.[Email address protected]
Sent: sexta-feira, 28 de Setembro de 2007 15:32
To: LazyDBA Discussion
Subject: How can we identify whether exiting oracle server is UP or
DOWN?

Hi,



I am a new user to this Forum, I have one question, I wanted know about
my oracle Server status.



Can any one share with your knowledge?

Thanks in advance.





Regards,

Siva.P

BirlaSoft, Bangalore. India

Mail to: siva.[Email address protected] <mailto:siva.[Email address
protected]

DC# : 318 - 5035

"You never achieve real success unless you like what you are doing"





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html







---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page