When configuring the Oracle Management Pack, the management pack sometimes throws “Oracle Instance Connection Monitor” Alerts because it cannot connect to the Oracle database/instance.

 

When this happens, check if the Host Name and Instance Name you configured in the “Oracle IMP Configuration Dashboard” correspond with the names in the TNSNames.ora file.

 

The TNSNames.ora file is usually found in the following directory on Linux servers installed with Oracle 11g: /u01/app/oracle/product/11.2.0.db_1/network/admin.

The Host Name in the “Oracle IMP Configuration Dashboard” should correspond with the HOST field highlighted in the TNSNames.ora.

The Instance Name in the “Oracle IMP Configuration Dashboard” should correspond with the SERVICE_NAME field highlighted in the TNSNames.ora.