My Oracle Support Banner

EM 13c: Database Target Status Shows As Broken/Agent Unreachable In OMS Console (Doc ID 2929572.1)

Last updated on MARCH 02, 2023

Applies to:

Enterprise Manager for Oracle Database - Version 13.5.0.0.0 and later
Information in this document applies to any platform.

Symptoms

DB target shows status broken in OEM Console

<Hostname>:<AGENT_HOME>/bin> ./emctl control agent runCollection <Target Name>:oracle_database Response
Oracle Enterprise Manager Cloud Control 13c Release 5
Copyright (c) 1996, 2021 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
EMD runCollection error:
Response:RunCollection: exception occurred: oracle.sysman.gcagent.task.TaskPreExecuteCheckException: Setup failed due to running against target but yet no such target

<Hostname>:<AGENT_HOME>/bin> ./emctl status agent target <Target Name>,oracle_database

Oracle Enterprise Manager Cloud Control 13c Release 5
Copyright (c) 1996, 2021 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Target [<Target Name>,oracle_database] does not exist or is broken
---------------------------------------------------------------
Agent is Running and Ready

 gcagent.log shows below error

2023-02-16 15:18:58,065 [5134:D5892DFE] INFO - Target: [oracle_database.<Target Name>$24] is fully broken: ORA-06550: line 37, column 17:
PLS-00201: identifier 'SYS.DBMS_DRS' must be declared
ORA-06550: line 37, column 1:
PL/SQL: Statement ignored
(code=0x400)

 

Changes

N/A

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
Changes
Cause
Solution


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