Re: How to check Oracle is running with ps

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 - 10:13:37 CEST