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

Report message to a moderator

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

Report message to a moderator

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: 10708
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.

Report message to a moderator

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

Report message to a moderator

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: 68775
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Mar 05 18:04:57 CST 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.