Re: Is Database Up?

amerar_at_iwc.net wrote:
> Hi All,
>
> I want to write a Unix shell script that will check to see if a
> database, on a remote machine, is up. Is this possible without writing
> some long telnet routine or something?
>
> I was hoping for some simple command that I can grep for some string to
> tell me the status of the remote database........
>
> Thanks!!!

Hi,

a few years back there was a file created only when the instance was up. I think it's gone. Maybe you could write a pl.sql script using the utl file package that creates a file at startup of the instance. Now I don't know if i's possible to delete the file at shutdown. grep for the oracle processes is not reliable because one might be down according to Murphy's law. Received on Mon Aug 28 2006 - 11:15:04 CDT