How do I monitor multiple listeners for one Oracle instance?

Products

• CA Distributed Database Management
• CA Database Analyzer for DB2 for Oracle

Issue/Introduction

 

I am remotely monitoring a Oracle database instance. How do I monitor multiple listeners for just one Oracle database instance?

 

 

Environment

Release:
Component: oracle probe

Resolution

You can accomplish the monitoring of multiple Oracle listeners by creating a user-defined scan for each listener. The .sql script for the user-defined scan will include the command from the SQL*NET V STATUS scan which is:

ps -ef | grep tnslsnr | grep -v grep | wc -l

The grep in the above command will be modified to grep for the specific listener's name. After the user-defined scan is setup, you can then create a genlimit alarm based on the user-defined scan created.