RE: How can we identify whether exiting oracle server is UP or DOWN?

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



Oracle LazyDBA home page