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:

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

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