Re: oracle running ?

Hi, folks, the old fossil here, don't mind me, but

isn't there an sgadef file created anymore when Oracle starts up?

testing for that would be simple enough; but of course as other suggestions have been of examining the O/S for live processes, sometimes Oracle is down and that file is not removed, a key thing to remember (and get rid of) if Oracle is in fact down.

ps -fu oracle | wc -l

is a test I often use as a quickie; substitute the owner of the Oracle core at your place for "oracle" if that is not the owner. (This results in just a number output, the lower it is, the more you worry. If it is any less than 10, really worry.)

or ps -fu oracle | grep SID | wc -l is useful too.

or log into SQLPLUS and do a SELECT SYSDATE from DUAL;

The sgadef file may be history nowadays, but at one time even Oracle itself checked for its existence to see if it was up or not; you wanted a file, that's a file; whether it is still used, I do not know. I'm waiting for Update the Neandrathal DBA kit to arrive from UPS.

RSH. <theo.verbinnen_at_mail.be> wrote in message news:3c8752c2.5577119_at_news.tiscali.be...
> hi all
>
>
> is there a file under unix that allows me to know if a database is up
> and running (without having to connect to Oracle) ?
>
>
> your help is well appreciated
>
>
>
Received on Fri Mar 08 2002 - 17:18:16 CST