EM 12c : Agent Shows Unreachable After Blackout is Ended (Doc ID 1532324.1)

Last updated on AUGUST 19, 2022

Applies to:

Symptoms

Agent status in the console shows unreachable or status pending after blackout is ended.

$/AGENT_INST/bin/emctl status blackout

shows No Blackout registered

Oracle Enterprise Manager Cloud Control 12c Release 2  
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
No Blackout registered.

Following SQL statement shows targets in blackout state without an Active blackout

- Targets in blackout state without an active blackout

SQL>SELECT t.entity_guid
FROM   em_current_availability a, em_manageable_entities t
WHERE  t.manage_status  = 2  -- managed
  AND  t.promote_status = 3  -- promoted
  AND  t.broken_reason  = 0  -- not broken
  AND  t.entity_guid    = a.target_guid
  AND  a.current_status = 5  -- in blackout
  AND  t.entity_guid NOT IN
       (SELECT DISTINCT target_guid
        FROM   mgmt_blackout_flat_targets
        WHERE  blackout_status = 1);

- Active blackout windows without blackouts
SQL>SELECT w.blackout_guid, w.target_guid, w.end_time, l.last_load_time
FROM   mgmt_blackout_windows w, em_manageable_entities t, mgmt_targets_load_times l
WHERE  t.entity_guid = w.target_guid
  AND  l.target_guid = w.target_guid
  AND  (
         (w.status NOT IN (10,11)  AND w.end_time < l.last_load_time)
        OR
         (w.status IN (10,11)      AND w.end_time IS NULL)
       )
  AND  w.blackout_guid NOT IN
       (SELECT blackout_guid FROM em_blackouts);

- Expired blackout windows

SQL>SELECT w.blackout_guid, w.target_guid, w.end_time FROM mgmt_blackout_windows w, mgmt_targets_load_times l WHERE w.end_time IS NOT NULL AND w.target_guid = l.target_guid AND w.end_time < l.last_load_time-1/24 AND w.status IN (10,11) ;

Cause

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