Database uptime monitoring by either snmp or active monitor script anyone?
679409Jan 12 2009 — edited Jan 13 2009Hi,
Has anyone previously setup any type of active monitoring script through whats up gold or an snmp informant type of monitoring script to advise when a database is down or specific process is down?
An example would be like ORACLE_PKG1, and the process is named ora_smon_hrprd88.
This is what the HP-UX “ps” shows:
tpadb01:/# ps -ef | grep -i ora_smon
oracle 13207 1 0 Jan 1 ? 0:29 ora_smon_epprd88
oracle 13281 1 0 Jan 1 ? 1:31 ora_smon_hrprd88
oracle 13635 1 0 Jan 1 ? 1:03 ora_smon_fsprd84
oracle 3620 1 0 Jan 2 ? 0:18 ora_smon_mtprd04
oracle 14586 1 0 Jan 1 ? 0:23 ora_smon_mtprd05
oracle 15223 1 0 Jan 1 ? 0:26 ora_smon_inprd88
oracle 15879 1 0 Jan 1 ? 0:25 ora_smon_epsal88
oracle 16769 1 0 Jan 1 ? 0:52 ora_smon_hrsal88
root 17976 22609 0 10:46:39 ttyp2 0:00 grep -i ora_smon
tpadb01:/#
Not sure if the extra info helps, but you never know. We can set it up to send us database up alerts, but the problem I have is when the listener service is down I can't get my script to finish no matter how I change the values of my script around. I can provide my script if that would help as well. If someone has already done this and is willing to share great!
Harvey