EM13c : DBName property shows db_unique_name instead db_name (Doc ID 2642160.1)

Last updated on JUNE 15, 2022

Applies to:

Symptoms

In Enterprise Manager (EM) Cloud Control, Navigate to TARGET_HOME -> CONFIGURATION -> LATEST -> Instance Information section shows Database Name which is actually DB_UNIQUE_NAME.

From target DB:

SQL> show parameter name;
SQL> select NAME, DB_UNIQUE_NAME from v$database;

From Repository DB:

SQL> select property_name, property_value from mgmt_target_properties where property_name in ('DBName','SID','InstanceName')
and target_guid = (select target_guid from mgmt_targets where target_name='<DB_UNIQUE_NAME from above output>');

mgmt_target_properties shows the wrong db name. The expected behavior is to have the DBName, but it reports the DB_UNIQUE_NAME.

Cause

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