My Oracle Support Banner

EM13c : ORA-12899: value too large for column MGMT_DB_DBNINSTANCEINFO_ECM_E"."DATABASE_UNIQUE_NAME" (Doc ID 2646448.1)

Last updated on MARCH 06, 2020

Applies to:

Enterprise Manager for Oracle Database - Version 13.2.0.0.0 to 13.3.0.0.0 [Release 13c]
Information in this document applies to any platform.

Symptoms

In Enterprise Manager (EM) Cloud Control, MetricLoadErrors reported for DATABASE_UNIQUE_NAME column in MGMT_DB_DBNINSTANCEINFO_ECM_E table

Error stack observed from <EM_INSTANCE_HOME>/em/EMGC_OMS*/sysman/log/emoms.trc file:

[GCLoader[data] - https://<AgentHostname>:<AgentPort>/emd/main/] WARN load.MetricLoadErrors logp.251 - MetricLoadRowset.processMetricTableRows:
[INSERT INTO MGMT_DB_DBNINSTANCEINFO_ECM ("DATABASE_NAME", "GLOBAL_NAME", "BANNER", "HOST_NAME", "INSTANCE_NAME", "STARTUP_TIME", "LOGINS", "LOG_MODE",
"OPEN_MODE", "CHARACTERSET", "NATIONAL_CHARACTERSET", "DEFAULT_TEMP_TABLESPACE", "CREATION_DATE", "RELEASE", "EDITION", "DBVERSION", "IS_64BIT", "REL_STATUS", "SUPPLEMENTAL_LOG_DATA_MIN", "DV_STATUS_CODE", "DATABASE_UNIQUE_NAME", "DB_NAME_NEW", "ECM_SNAPSHOT_ID") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, hextoraw(?))] : [ORA-12899][ORA-12899: value too large for column "SYSMAN"."MGMT_DB_DBNINSTANCEINFO_ECM_E"."DATABASE_UNIQUE_NAME" (actual: 13,
maximum: 9)]: [oracle_database : <DB_Target_Name> : [MetricGroupName : db_dbNInstanceInfo : MetricGroupId = 6512]][oracle_database : <DB_Target_Name> :
[MetricGroupName : db_dbNInstanceInfo : MetricGroupId = 6512]]
java.sql.SQLException: ORA-12899: value too large for column "SYSMAN"."MGMT_DB_DBNINSTANCEINFO_ECM_E"."DATABASE_UNIQUE_NAME" (actual: 13, maximum: 9)

 

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
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.