My Oracle Support Banner

DB Upgrade to 12.2.0.1 fails with Error ORA-01450: Maximum Key Length (3118) Exceeded - create unique index i_radm_pe1 on sys.radm_pe$(pe_name) (Doc ID 2268981.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

ORA-01450 error during 12.2.0.1 upgrade

Symptom 1

in catupgrd0.log

15:42:09 SQL>
15:42:09 SQL> Rem
15:42:09 SQL> Rem lrg #19690342: Data Redaction fix for re-upgrade.
15:42:09 SQL> Rem Cannot truncate the radm_pe$ table here, as the upgrade script
15:42:09 SQL> Rem may be re-run after a Data Redaction Policy has been upgraded
15:42:09 SQL> Rem to the 12.2-format by the PL/SQL block below (see the "Copy each
15:42:09 SQL> Rem existing Policy Expression..." comment).
15:42:09 SQL> Rem
15:42:09 SQL>
15:42:09 SQL> create unique index i_radm_pe1 on sys.radm_pe$(pe_name)
15:42:09 2 /
create unique index i_radm_pe1 on sys.radm_pe$(pe_name)
*
ERROR at line 1:
ORA-01450: maximum key length (3118) exceeded


Elapsed: 00:00:00.02
15:42:09 SQL> create index i_radm_pe2 on sys.radm_pe$(pe_obj#, pe_name)
15:42:09 2 /
create index i_radm_pe2 on sys.radm_pe$(pe_obj#, pe_name)
*
ERROR at line 1:
ORA-01450: maximum key length (3118) exceeded


Symptom 2

After applying patch 24714096, upgrade failed with below error

in catupgrd3.log

22:07:41 SQL> CREATE INDEX sys.i_scheduler$_listeneraddresse3
22:07:41 2 ON sys.scheduler$_listeneraddresses (address,service)
22:07:41 3 TABLESPACE sysaux
22:07:41 4 /
ON sys.scheduler$_listeneraddresses (address,service)
*
ERROR at line 2:
ORA-01450: maximum key length (1478) exceeded

Elapsed: 00:00:00.19
22:07:41 SQL>
22:07:41 SQL> CREATE INDEX sys.i_scheduler$_listeneraddresse4
22:07:41 2 ON sys.scheduler$_listeneraddresses (address,service,instance)
22:07:41 3 TABLESPACE sysaux
22:07:41 4 /
ON sys.scheduler$_listeneraddresses (address,service,instance)
*
ERROR at line 2:
ORA-01450: maximum key length (1478) exceeded

 

 

Changes

Upgrading database to 12.2.0.1

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!


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