How do I monitor multiple listeners for one Oracle instance?

Document ID : KB000053094
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

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

Solution:

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.