Re: Is Oracle Running?
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.
>
The command that I used at a former site was:
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