DB Upgrade 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 SEPTEMBER 30, 2019

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

ORA-01450 error during 12.2.0.1/18c 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