EM 12c: Enterprise Manager 12.1.0.3 Cloud Control Agent is Missing oracle_database xml Files for Database Metrics: No Data In MGMT$DB_DATAFILES (Doc ID 2139514.1)

Last updated on MAY 24, 2016

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.3.0 to 12.1.0.8.0 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Enterprise Manager (EM) 12.1.0.3 Cloud Control is monitoring several 10.2 databases on different Linux (RHEL 4.9) Servers.
For some of the database targets, the EM 12.1.0.3 Agent is missing some of the configstate xml files for some metrics.
Even after re-installing the EM 12.1.0.3 Agent and running addinternaltargets from emctl, some of the required xml files are still missing from .../agent_inst/sysman/emd/state/configstate/oracle_database/<instance_name>/:

Existing files:

db_components.xml
db_cpu_usage.xml
db_dbNInstanceInfo.xml
db_feature_usage.xml
db_init_params.xml
db_inst_only_info.xml
db_invobj_cnt.xml
db_license.xml
db_options.xml
db_recSegmentSettings.xml
db_recTablespaceSettings.xml
db_recUserSettings.xml
db_rollback_segs.xml
db_services.xml
db_sga.xml
db_tablespaces.xml
db_users.xml
ha_info.xml
ha_rman_config.xml
high_water_mark_stats.xml

MIssing files:

db_controlfiles.xml *
db_datafiles.xml *
db_recSegmentSettings_sysseg.xml *
db_redoLogs.xml *
ha_dg_target_summary.xml *
has_resources_database.xml *
mgmt_db_listener_config.xml *



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