ServiceGuard / OracleRAC database monitoring

[Wim Rombauts]

Hello, we are running an Oracle 10g R2 OracleRAC database. From ServiceGurd, I am monitoring the datbase with command "srvctl status instance -d $DATABASE -i $INSTANCE".
Now I notice that this command launches a java process ($ORALE_HOME/jdk/jre/bin/IA64N/java) and that this java process consumes a significant amount of CPU.
Is anyone of you running any database monitoring (from ServiceGuard or somewhere else) and what commands do you use ?

[Warren_9]

hi,

i think you could monitor the oracle processes such as pmon,smon,lgwr..etc

the monitor script can be found in the SG ETK.

GOOD LUCK!!

[Chan 007]

Hi,

One you can do ps -ef |grep pmon |wc -l
if the no of line is less than 1, when alert,

but this is fine from SA side,

but it is better from DBA side to check the DB by log-in, ask your DBAs to give a sql to do this. That will check DB, Listener etc.

Chan

[Wim Rombauts]

Oracle has some "nice" status-check features within the software, like "srvctl status database" and (if you run clusterware) crs_stat.
Only, these commands use too much CPU-resources for frequent scanning of the database status.
I reverted back to my old scanning method that I used on my Oracle 9i databases : Get the PID's of the database processes and monitor the existance of those processes (kill -s 0).