OraFAQ Forum: Server Utilities » Oracle shutdown/running

Home » RDBMS Server » Server Utilities » Oracle shutdown/running

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle shutdown/running [message #72046]

Wed, 26 February 2003 06:12

Meenakshi
Messages: 28
Registered: December 2001

Junior Member

Hi,

Is there a way to find out whether oracle is running or it is down without logging into oracle and also without using "ps" command in sun solaris.

Report message to a moderator

Re: Oracle shutdown/running [message #72062 is a reply to message #72046]

Fri, 28 February 2003 06:19

Arvind L
Messages: 27
Registered: June 2001

Junior Member

Chk if lkSID file exists in $ORACLE_HOME/dbs
This file gets created to prevent one from Starting the db more than once

HTH
Arvind L

Report message to a moderator

Re: Oracle shutdown/running [message #72067 is a reply to message #72046]

Sat, 01 March 2003 06:29

Meenakshi
Messages: 28
Registered: December 2001

Junior Member

I tested this but lkSID file is present even after the database is shutdown.Can u please let me know how to check from a script that oracle is up/down

Report message to a moderator

Previous Topic:	WHEN clause - urgent
Next Topic:	archetecture

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 11:49:44 CDT 2024