EM 12c, EM 13c: Enterprise Manager Cloud Control OMS Installation Fails At Repository Configuration Assistant With Message: Error: ORA-01450: maximum key length () exceeded
(Doc ID 1474313.1)
Last updated on OCTOBER 20, 2019
Applies to:
Enterprise Manager Base Platform - Version 12.1.0.1.0 and laterInformation in this document applies to any platform.
Symptoms
OMS installation failing at Repository Configuration Assistant stage
<OMS_HOME>/cfgtoollogs/cfgfw/CfmLogger_<timestamp>.log shows the following:
=======================
ORA-01450: maximum key length (6398) exceeded
File:<OMS_HOME>\sysman\admin\emdrep\sql\core\11.2.0.1\basic\basic_ng_tables_met.sql
Statement:CREATE TABLE EM_METRIC_KEYS
(key_part_1 VARCHAR2 (256) NOT NULL,
key_part_2 VARCHAR2 (256) DEFAULT ' ' NOT NULL,
key_part_3 VARCHAR2 (256) DEFAULT ' ' NOT NULL,
key_part_4 VARCHAR2 (256) DEFAULT ' ' NOT NULL,
key_part_5 VARCHAR2 (256) DEFAULT ' ' NOT NULL,
key_part_6 VARCHAR2 (256) DEFAULT ' ' NOT NULL,
key_part_7 VARCHAR2 (256) DEFAULT ' ' NOT NULL,
metric_key_id INTEGER NOT NULL,
metric_key_guid RAW (16) NOT NULL,
creation_date DATE NOT NULL,
CONSTRAINT EM_METRIC_KEYS_PK
PRIMARY KEY (key_part_1, key_part_2, key_part_3, key_part_4,
key_part_5, key_part_6, key_part_7) USING INDEX,
CONSTRAINT EM_METRIC_KEYS_U1 UNIQUE (metric_key_id) USING INDEX
)
INFO: oracle.sysman.top.oms:The plug-in Repository Configuration has failed its perform method
==================
Changes
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 |
Changes |
Cause |
Solution |
References |