How to check Oracle is running with ps
From: chris dowsett <chrisdowsett_at_hotmail.com>
Date: 13 Jul 2001 05:35:04 -0700
Message-ID: <80f6fa7e.0107130435.6a6dde29_at_posting.google.com>
Date: 13 Jul 2001 05:35:04 -0700
Message-ID: <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
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
ora_pmon_CLFY
ora_dbw0_CLFY
ora_lgwr_CLFY
ora_ckpt_CLFY
ora_smon_CLFY
ora_reco_CLFY
ora_s000_CLFY
ora_d000_CLFY