EM13c : ORA-12899: value too large for column MGMT_DB_DBNINSTANCEINFO_ECM_E"."DATABASE_UNIQUE_NAME"
(Doc ID 2646448.1)
Last updated on DECEMBER 05, 2021
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)
[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 |