Re: How to check whether the Oracle database is up?

From: Yang <yg.yang_at_wanadoo.fr>
Date: Fri, 30 Aug 2002 23:09:57 +0200
Message-ID: <akomtt$2v8$1@wanadoo.fr>

i agree with Pete Sharman, because the presence of a unix process (sorry to Microsoft...) dosn't mean the database is 'ok'. if you have standby database, Pete's solution is not enough, the startup open will hang...
if you have a parallel database, i think you should test all the instances with sqlplus and then find at most one is 'ok'.

i mean, one script could be a tool, but never the solution...

hth
yang
senior dba

"Sri" <srikya_at_indiainfo.com> wrote in message news:d1efb101.0208300123.48a95e9c_at_posting.google.com...
> Using a script, I want to check whether my database instance has been
> started and mounted or not.
> What is the best way to do this?
>
> ~Sri
Received on Fri Aug 30 2002 - 16:09:57 CDT