oracle probe check_dbalive did not alarm that the DB was down

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

We monitor our Oracle DB with the oracle probe and even though the DB was down, the check_dbalive checkpoint, did not wan us that the DB was down? 

How could this happen? 

Environment

• DX UIM 23.4.*
• Oracle probe any version

Cause

The check_dbalive uses the Oracle OCI API's to check the connectivity. The probe checks the DB is up or down talking to the listener. If the Listener is down, the check_dbalive won't work.

Resolution

Check if the listener was down. if so the behavior is expected. 

However, when the listener is down, the following kind of alarm should also be received: 

Profile orcl_profile_19c : ORA-12541: TNS:no listener

Additional Information

The listener can also be monitored separately with the processes probe