Using High Availability Monitors (June 2007)

Troubleshooting HA Monitors
Database Monitor Troubleshooting for Oracle
Appendix B 89
• The HA Database Monitor relies on the proper installation and
configuration of the Oracle Net8 product and processes (ora_naaagt,
master_peer, dbsnmp, and tnslsnr). If you are able to connect to the
database using the Oracle sqlplus utility, then the HA Database
Monitor should also work. To verify Oracle Net8 connectivity, run the
Oracle sqlplus utility from a client system that uses the same
tnsnames.ora file as the one on the server. Type:
sqlplus username/password@service_name
where:
— username/password is for the target database
— service_name is the alias name in the tnsnames.ora file for the
database server that you are trying to access.
• If you are attempting to use the HA Database Monitor with
ServiceGuard, ensure that your version of ServiceGuard supports
DEFERRED resource processing. Otherwise, your packages will not be
able to start successfully. Verify all configuration settings as
described in Chapter 3, Monitoring Database Resources, of this
manual and in the related ServiceGuard documentation for this
feature. Also, ensure that you have the Oracle SNMP running on the
primary and any failover node(s), before attempting to configure your
ServiceGuard package(s).