Re: How to check Oracle is running with ps

Hi Chris,

The ps -ef command will list all the background processes for the instance CLFY. This does not mean that the database itself is up and does not indicate a fully functional database. There may not be many scenarios where this might happen (instance is up and database is down), but your check is not fault proof. You might want to write a quick and dirty shell script where you connect to the database using sql*plus as a normal user (not internal) and checking the return code after you exit. If the variable $? (in Korn scripting) is not zero, then your database is down.

Murali Sreedhar

chrisdowsett_at_hotmail.com (chris dowsett) wrote in message news:<80f6fa7e.0107160013.10d0de55_at_posting.google.com>...
> chrisdowsett_at_hotmail.com (chris dowsett) wrote in message news:<80f6fa7e.0107130435.6a6dde29_at_posting.google.com>...
> > I am trying to write a fault management procedure to check whether
> > Oracle 8.1.6 is running on Solaris 7.
> >
> > I have suggested we use ps -ef|grep CLFY (Where CLFY is the SID of the
> > database i am checking)
> >
> > this gives me the following 8 processes
> >
> > ora_pmon_CLFY
> > ora_dbw0_CLFY
> > ora_lgwr_CLFY
> > ora_ckpt_CLFY
> > ora_smon_CLFY
> > ora_reco_CLFY
> > ora_s000_CLFY
> > ora_d000_CLFY
> >
> > I am checking the listener seperately with lsnrctl stat.
> >
> > Are there any other processes which are essential and should be
> > checked for ?
> >
> > Do all of these processes need to running to indicate a fully
> > functional database ?
> >
> > TIA Chris
>
> PLEASE HELP ME
Received on Mon Jul 16 2001 - 18:21:46 CEST