My Oracle Support Banner

EM 24AI:Enterprise Manager Cloud Control OMS Installation Fails At Repository Configuration Assistant With Message: ORA-01450: maximum key length (6397) exceeded (Doc ID 3065602.1)

Last updated on JANUARY 29, 2025

Applies to:

Enterprise Manager Base Platform - Version 24.1.0.0.0 and later
Information 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:

INFO: oracle.sysman.top.oms:process_id:1a5es6gsmx0yz
INFO: oracle.sysman.top.oms:Failure...
INFO: oracle.sysman.top.oms:1 error(s) happened in performing the action:
INFO: oracle.sysman.top.oms:1):
ORA-01450: maximum key length (6397) exceeded
File:OMS_HOME\sysman\admin\emdrep\sql\mos\latest\mos\mos_pa_indexes.sql
Statement:CREATE INDEX MGMT_ARU_PATCH_RECOM_MD_IDX3
ON MGMT_ARU_PATCH_RECOM_MD_E (NVL(EXTRACTVALUE(XMLTYPE(TEXT_CONTENT), '/patch/@is_system_patch'),'n')) COMPRESS ADVANCED HIGH

 

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


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