Re: How to tell if Oracle is ready?

smattes_at_erols.com (Scott Mattes) wrote:
>On the computer we run our app on, Oracle is down for a certain time
>each night. The only thing is that we can not be sure exactly when
>this will be (once a human policy is 'set in concrete' people tend to
>forget that it is subject to change). We also have jobs that get
>scheduled to run over night and I need to be sure that they don't run
>until Oracle is up and ready. I also need to get them run as soon as
>possible so that the users have their output waiting for them in the
>morning.
>
>I have tried to use 'ps -eaf | grep x_$ORACLE_SID', where x has been
>'dbwr', 'smon' or 'd001' to no avail. If I schedule a job to start
>even 3 seconds after the last dameon is up (d001 seems to be the last
>one up) I get an error saying Oracle shutdown/initialization is in
>progress and can not connect.
>
>What should I be keying on to determine that the instance is ready to
>work?
>
>Thank you.
>------------
>Scott Mattes
>smattes_at_erols.com

Hi there,

Try connecting to SQL*PLUS with dummy userid and password. Execute this as shell script. If it returns '0' then Oracle is up and running. If not then there is some problem.

Regards

N.Prabhakar Received on Wed Jan 29 1997 - 00:00:00 CST