Oracle instances monitoring using proc.num

[hbm]

I wanted to use the proc.num functionality to monitor the oracle instances , the problem is I have many instances running on a single node its all prefix as ora and the all users are oracle ..

Any help would be greatly appreciated for monitoring the multiple instances of oracle.

Thanks in Advance

[oitss]

This item key

proc.num[,oracle,,ora_pmon_*]

check number of oracle pmon processes. PMON (Process MONitor) is an Oracle background process created when you start a database instance. The better way is to use
special database plugins for Oracle monitoring.

[hbm]

Thanks ... for the reply .. I will try this

do you know by any chance a method to monitor this in a clustered environments ... like active node and passive the VIP will fail-over to the next node if one fails...Dont know how can I implement the monitoring in that case


Thanks in Advacem

[oitss]

You can write custom bash scripts executing Oracle RAC control commands and send analyzed result to Zabbix server.

[A.Zabihi]

for oracle instance monitoring you must monitor PMON process and you can test that when you shutdown your database then pmon is not in 'ps ax' command.

you must set EnableRemoteCommands=1 in zabbix agent of your oracle server and then use this command to monitor pmon :

UserParameter=pmon,ps -e | grep -c pmon

and then save the configuration file and restart zabbix agent.
this command give you count of pmon process, if you have one nstance and one pmon process it back value 1 and everytime it back value 0 you can create trigger for this that database is down.

after set configuration in config file, you must create item in zabbix with zabbix agent type and your key is set to : pmon

and finish





thanks

[Luiz Antonio Oliveira]

Develop a script to list pmons in the LLD and create proc.num for [p] mon.




#!/bin/sh
PMON=$(ps axww | grep [p]mon)

start() {
echo -n "{\"data\":["

for x in `echo $PMON`
do
echo -n "{\"{#PMON}\":\"$x\"},"

done
echo -n "]}"
}

start | sed ':a;$!{N;ba;};s/\(.*\)},/\1}/'

EOF

item prototype
proc.num[{#PMON}]

trigger prototype
proc.num[{#PMON}] < 1