EM 12c : Agent Shows Unreachable After Blackout is Ended
(Doc ID 1532324.1)
Last updated on AUGUST 19, 2022
Applies to:
Enterprise Manager Base Platform - Version 12.1.0.2.0 to 12.1.0.2.0 [Release 12.1]Information in this document applies to any platform.
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
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
Symptoms |
Cause |
Solution |
References |