Wednesday, 30 December 2015

Troubleshooting the 'Pending' status for a Listener Target in Enterprise Manager 12c and 13c Cloud Control

What Does the 'Pending' Status of a listener Mean?

# Sometimes what happens that the target has just been added and its status cannot be determined, not only this it can be some other issue as well, like for example due to some issue oms has not yet received the status of the target, so the Status 'pending' actually means that OMS has not yet received the 'availability' status of the target from the agent and the 'pending' status (clock icon) for a listener target should only be a temporary status (for example, when a new target is added or if a target has been under blackout and has just ended the blackout period). A listener target with a long status pending period should be investigated.  In onwards additional status types were included for example 'Status pending (Target Addition in Progress)'

If a listener is showing as status 'pending' in Cloud Control, it means that the 'Response' metric has not been able to determine whether the listener is down or up. Sometimes even though a listener is shown as status 'pending' in the console, the agent has evaluated the status of the listener correctly but this status has not been received by the OMS.  Sometimes however, the agent is not able to evaluate the status correctly (eg. in the case of target being marked as 'broken', or target not existing at agent end).

In order to obtain the status of the listener target, the 'Response' metric is run every 5 minutes by the agent. The response metric runs an OS script called which is found in <install home of agent>/plugins/oracle.sysman.db.agent.plugin_<pluginversion>/scripts. The script performs a tnsping to the listener machine/port and confirms that the listener has been started with the 'correct' listener.ora file (the "correct" listener.ora file is that listener.ora file shown in "listener.ora location" (on the listener home page).  The listener target in Cloud Control is tied to a particular listener.ora file and directory (unlike previous versions of Enterprise Manager).  This means that for example, a listener in $TNS_ADMIN and a listener in $ORACLE_HOME/network/admin cannot be swapped between.

There is a very useful metalink i found and it is (Troubleshooting the 'Pending' status for a Listener Target in Enterprise Manager 12c and 13c Cloud Control (Doc ID 1546576.1))

No comments:

Post a Comment