If you are on Unix/AIX, from the OS command line use the ps -ef|grep
pmon command. This will tell you all the databases that are started.
This does not mean the database is available for users. You will need to
check the listener is up and your sid is listed. Use lsnrctl status from
the OS command line. If the listener is not up, use lsnrctl start.
IJCA,
Gil Bruce
-----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
Oracle LazyDBA home page