My Oracle Support Banner

EM 13c: Upgraded Database Target has Metric Collection Error: Target {rac_database.database_name} is broken: Dynamic Category property error,Get dynamic property error - Invalid Input (Doc ID 2203451.1)

Last updated on FEBRUARY 07, 2019

Applies to:

Enterprise Manager for Oracle Database - Version 13.1.1.0.0 and later
Information in this document applies to any platform.
Installed a new Agent and discovered a DB Target. Receiving monitoring errors:

Promote Target to Agent Fail Error : Target {rac_database.TESTDB} is broken: Dynamic Category property error,Get dynamic property error - Invalid Input

Metric evaluation error start - Dynamic Category property error,Get dynamic property error,Computation of a critical dynamic property failed. Retries Completed.

Symptoms

Enterprise Manager (EM) 13.1 Cloud Control
Enterprise Manager for Oracle Database - Version 13.1.1.0.0

A database target is reported as Status Pending and then eventually Metric Collection Error in Enterprise Manager Cloud Control 13c.
Reinstalling the agent on the affected server gives the same results.
Drilling down on the error status shows:

Metric evaluation error start - Dynamic Category property error,Get dynamic property error,Computation of a critical dynamic property failed. Retries Completed.

Metric evaluation error start - Dynamic Category property error,Get dynamic property error,No such metadata.

5,176 Nov 9, 2016 2:43:23 PM Promote Target to Agent Fail Error : Target {rac_database.<database name>} is broken: Dynamic Category property error,Get dynamic property error - Invalid Input
5,167 Nov 9, 2016 2:43:22 PM Target Category Property Change : : : : ## : :DB:FullLLFile:
5,165 Nov 9, 2016 2:43:20 PM Promote Target to Agent Agent : https://<Agent host name 1>.<domain>:3872/emd/main/
5,131 Nov 9, 2016 2:43:14 PM Add Unmanaged Target host/agent : <Agent host name 1>.<domain>:https://<Agent host name 2>.<domain>:3872/emd/main/:2:40E3BDB928B6343EE0532A050F0AA78A
5,131 Nov 9, 2016 2:43:23 PM Promote Target to Agent Fail Error : Target {rac_database.<database name>} is broken: Dynamic Category property error,Get dynamic property error - Invalid Input
5,131 Nov 9, 2016 2:43:19 PM Promote Target to Agent Agent : 2
5,112 Nov 9, 2016 2:41:34 PM Add Unmanaged Target host/agent : <Agent host name 1>.<domain>:https://<Agent host name 1>.<domain>:3872/emd/main/:1:40E3BDB928B6343EE0532A050F0AA78A
4,884 Nov 9, 2016 2:05:06 PM Add Unmanaged Target host/agent : <Agent host name 2>.<domain>:https://<Agent host name 2>.<domain>:3872/emd/main/:1:

The following or similar may be found in the gcagent.log file:

EMA-00001: The target rac_database.<database name> does not exist

oracle.sysman.emSDK.agent.NoSuchTargetException: EMA-00001: The target rac_database.<database name> does not exist
at oracle.sysman.gcagent.target.interaction.execution.SeverityState.getAlertStates(SeverityState.java:274)
at oracle.sysman.gcagent.target.interaction.browser.MetricBrowser.dispatchListSeverities(MetricBrowser.java:1383)
at oracle.sysman.gcagent.target.interaction.browser.MetricBrowser.dispatchQueryPage(MetricBrowser.java:740)
at oracle.sysman.gcagent.target.interaction.browser.MetricBrowser.dispatchBrowserRequest(MetricBrowser.java:329)
at oracle.sysman.gcagent.comm.agent.http.HTTPMetricBrowserHandler.doGet(HTTPMetricBrowserHandler.java:243)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:751)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:566)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:219)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1111)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:498)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:183)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1045)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:199)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:98)
at org.eclipse.jetty.server.Server.handle(Server.java:461)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:284)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:244)
at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:534)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:607)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:536)
at oracle.sysman.gcagent.util.system.GCAThread$RunnableWrapper.run(GCAThread.java:198)
at java.lang.Thread.run(Thread.java:745)

OR

2016-11-11 13:41:11,423 [261843:CE28B2D8] INFO - >>> Reporting exception:
oracle.sysman.emSDK.agent.client.exception.NoSuchTargetException:
the oracle_database target "TESTDB" does not exist (request id 1) <<<
oracle.sysman.emSDK.agent.client.exception.NoSuchTargetException:
the oracle_database target "TESTDB" does not exist
at oracle.sysman.gcagent.dispatch.cxl.GetMetricDataAction.satisfyRequest(GetMetricDataAction.java:175)
at oracle.sysman.gcagent.dispatch.ProcessRequestAction._call(ProcessRequestAction.java:135)
at oracle.sysman.gcagent.dispatch.ProcessRequestAction.call(ProcessRequestAction.java:96)
at oracle.sysman.gcagent.dispatch.InlineDispatchCoordinator.dispatchRequest(InlineDispatchCoordinator.java:235)
at oracle.sysman.gcagent.dispatch.DispatchRequestsAction.call(DispatchRequestsAction.java:111)
at oracle.sysman.gcagent.dispatch.DispatchRequestsAction.call(DispatchRequestsAction.java:51)
at oracle.sysman.gcagent.task.DiagWrappedAction.call(DiagWrappedAction.java:52)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at oracle.sysman.gcagent.task.SingleActionTask.run(SingleActionTask.java:76)



Changes

 

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
References


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