Home » Infrastructure » Linux » How to find database is UP or DOWN (Oracle 10.2 / Linux AS)
How to find database is UP or DOWN [message #435520] Wed, 16 December 2009 09:24 Go to next message
sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI
Member
How to find database is UP or DOWN using Linux/Unix command.

(I am not asking Instance up or down)
(I am not asking Oracle commands like v$database)
I am asking OS command to know Database is up or down.

Thanks in advance
sbmk
Re: How to find database is UP or DOWN [message #435523 is a reply to message #435520] Wed, 16 December 2009 09:31 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
ps -ef | grep mon
Re: How to find database is UP or DOWN [message #435525 is a reply to message #435520] Wed, 16 December 2009 09:34 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>I am asking OS command to know Database is up or down.
Not possible.
With ps -ef , you check the availability of instance.
The instance can be up but the database could still be down or just mounted.
Only way is to login to database and issue a query.
Re: How to find database is UP or DOWN [message #436175 is a reply to message #435525] Tue, 22 December 2009 00:38 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
Mahesh,

Quote:
The instance can be up but the database could still be down or just mounted.


How?
I am confused at this point , how can we start the instance without starting DB?

(May be I dont know )!!!

Regards,
Rahul
Re: How to find database is UP or DOWN [message #436206 is a reply to message #436175] Tue, 22 December 2009 01:56 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I am confused at this point , how can we start the instance without starting DB?

startup nomount
startup mount

Regards
Michel
Previous Topic: Init script for Oracle Fusion Middleware
Next Topic: Creating new service
Goto Forum:
  


Current Time: Fri Mar 29 10:41:54 CDT 2024