My Oracle Support Banner

EM12c, EM13c : emctl status agent (Agent Unreachable) 'Agents too far into the future' Availability Marker Future Date Reported in MGMT_AVAILABILITY_MARKER.MARKER_TIMESTAMP (Doc ID 1946748.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Enterprise Manager Base Platform - Version and later
Information in this document applies to any platform.


Agent shown unreachable on console

Availability marker shows in 'future' date

SQL>SELECT a.target_guid, t.entity_name agent_name, TO_CHAR(a.marker_timestamp,'DD-MON-YYYY HH24:MI:SS') marker, TO_CHAR(p.max_partition,'DD-MON-YYYY') max_partition
FROM   mgmt_availability_marker a, em_manageable_entities t, (SELECT MAX(TO_DATE(partition_name,'YYYY-MM-DD HH24:MI')) max_partition FROM   user_tab_partitions
        WHERE  table_name      = 'EM_METRIC_VALUES'  AND  partition_name != 'MAX_VALUE') p
WHERE  a.marker_timestamp > p.max_partition+1
  AND  a.target_guid      = t.entity_guid
  AND  t.entity_type      = 'oracle_emd'  -- Agent
  AND  t.manage_status    = 2             -- Managed
  AND  t.broken_reason    = 0             -- Not broken
ORDER BY agent_name;

TARGET_GUID                                AGENT_NAME        MARKER                  MAX_PARTITION
-------------------------------------------------- -------------------------------------------------------------------
088877B59494373F1AD7E38B1478BEA4          lbsdb123:3872     29-AUG-2060 21:17:16   31-JUL-2013 00:00:00

From above query 'Availability Marker' Timestamp shows future date '29-AUG-2060'  which too far , so any upload/severity comes lowere than this timestamp will be ignored.  Hence Agent is marked unreachable.

SQL> select t.target_name, t.target_type,  decode (am.marker_avail_status, 0, 'down', 1, 'up',2, 'metricerror',3, 'agentdown',4, 'unreachable',5, 'blackout',6, 'unknown') "CurrentStatus", am.marker_timestamp from mgmt_targets t, mgmt_availability_markeram where t.target_guid = am.target_guid  and t.target_name like ('<AGENT_NAME>')  and t.target_type like ('oracle_emd')  order by am.marker_timestamp;

Target_name                        Target_type  Current Status    Marker_timestamp

    ----------------------------------------------------------------------------------------------------------    oracle_emd    Unreachable      2044-11-21 07:20:34


$/AGENT_INST/bin/emctl status agent

shows functional

Oracle Enterprise Manager Cloud Control 12c Release 2
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
Agent Version     :
OMS Version       :
Protocol Version  :
Agent Home        : /scratch/ps2/ag_imp_upg/agent12c/agent_inst
Agent Binaries    : /scratch/ps2/ag_imp_upg/agent12c/core/
Agent Process ID  : 5769
Parent Process ID : 5747
Agent URL         :
Repository URL    :
*Started at        : 2013-08-22 07:17:51*
Started by user   : aime
Last Reload       : (none)
*Last successful upload                       : 2013-08-22 07:19:10**
**Last attempted upload                        : 2013-08-22 07:19:10*
Total Megabytes of XML files uploaded so far : 0.02
Number of XML files pending upload           : 0
Size of XML files pending upload(MB)         : 0
Available disk space on upload filesystem    : 36.77%
Collection Status                            : Collections enabled
Heartbeat Status                             : Ok
Last attempted heartbeat to OMS              : 2013-08-22 07:20:14
Last successful heartbeat to OMS             : 2013-08-22 07:20:14
Next scheduled heartbeat to OMS              : 2013-08-22 07:21:14


repvfy (emdiag) test shows

3002. Agents too far into the future
TARGET_GUID                           AGENT_NAME                        MARKER               MAX_PARTITION
-------------------------------------------------- -------------------------------------------------------------------
088877B59494373F1AD7E38B1478BEA4 lbsdb1:3872        29-AUG-2060 21:17:16 31-JUL-2013 00:00:00





To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.