Re: Is Oracle Running?

I concur with this approach. In versions of Oracle later than 7.0.13, it is possible for Oracle to be running without an SGA def file.

It also is portable to other operating systems.

                                    Rick
                                    Rick Wessman
				    Server Techologies - Network Products
				    Oracle Corporation
                                    rwessman_at_us.oracle.com

In article <940523.195012.7a2.rusnews.w165w_at_syntaxis.ukmail.net> idixon_at_syntaxis.ukmail.net (Ian Dixon) writes:

>Path: oracle!gatekeeper.us.oracle.com!decwrl!hookup!swrinde!pipex!uknet!infocom.ukmail.NET!syntaxis!news
>From: idixon_at_syntaxis.ukmail.net (Ian Dixon)
>Newsgroups: comp.databases.oracle
>Date: 23 May 94 19:50:12 GMT
>References: <19940520.131935.073_at_lfs.loral.com> <Cq464u.HIH_at_csn.org> <Cq8xsF.EB3_at_nl.oracle.com>
>Organization: Syntaxis Consultancy
>Lines: 39
>X-Newsreader: rusnews v0.99
>
>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 Fri May 27 1994 - 18:08:21 CEST