EM 12c: Database Target is Marked in "Metric Collection Error" but Test Connection works fine from Console UI (Doc ID 2257182.1)

Last updated on APRIL 28, 2017

Applies to:

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

Symptoms

The server was rebooted, after which the Database target instance on this node is shown in metric collection error in the EM console.

At the agent side:

 ./emctl config agent listtargets
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
.......
[ORCL, oracle_database]
./emctl status agent target ORCL,oracle_database
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Target [ORCL,oracle_database] does not exist or is broken
---------------------------------------------------------------
Agent is Running and Ready

./emctl getmetric agent ORCL,oracle_database,Response
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996, 2015 Oracle Corporation. All rights reserved.
EMD getmetric error: the oracle_database target "ORCL" does not exist

Attempting to verify the database target status at the agent side reports that the target does not exist, though it is listed in the output of 'emctl config agent listtargets'.

-  The <AGENT_INST>/sysman/log/gcagent.log shows:

2017-04-20 08:55:27,480 [665:GC.DPExecutor2.26 (CDProps:oracle_database.ORCL:decideIncludeDB)] ERROR - ORA-06550: line 1, column 40:
PLS-00553: character set name is not recognized
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated
java.sql.SQLException: ORA-06550: line 1, column 40:
PLS-00553: character set name is not recognized
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:204)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms