Re: Is Oracle Running?

From: Ian Dixon <idixon_at_syntaxis.ukmail.net>
Date: 23 May 94 19:50:12 GMT
Message-ID: <940523.195012.7a2.rusnews.w165w_at_syntaxis.ukmail.net>


ddaly_at_nl.oracle.com (Donal Daly) writes:

> In article <Cq464u.HIH_at_csn.org>, losburn_at_teal.csn.org (Lynn Osburn) writes:
> |> >Is there a way to determine within a Cshell if Oracle is running?
> |> >Currently we count the processes that begin with 'ora_' but I believe
> |> >there has to be a better way. Thanks.
> |>
> |> Sure, check for the existance of $ORACLE_HOME/dbs/sgadefSID.dbf
> |> where SID is the SID for the instance in question. The file is created
> |> when the instance is started, and it goes away when you shutdown the
> |> database.
> |>
> This will work for nearly all cases, except after a machine crash, where the
> sgadefSID.dbf will be left around. To be absolutly sure, I would first test f
> or this
> file existence, and then test for a running ora_smon_SID process via ps.
>

With version 6 this does not tell you if the database is usable. For instance, a shutdown is in progress or the database is up in dba mode.

The command that I used at a former site was:

echo "select 'Oracle is available' from dual;"|sqlplus -s /| fgrep Oracle||echo "Oracle unavailable. Contact Systems."

It should all be on one line.

I think this was my version of something originally posted to this group.

Ian

-- 
-------------------------------------------------------------------------
Ian Dixon                      |  Email : idixon_at_syntaxis.ukmail.net    |
Independent Oracle Consultant  |  Tel   : +44 (0)734 478092             |
Reading, England               |                                        |
Received on Mon May 23 1994 - 21:50:12 CEST

Original text of this message