ORA-00600 [4355] [1502] Index Unusable During Upgrade

Last updated on OCTOBER 31, 2016

Applies to:

Symptoms

ALERT.LOG

ORA-00600: internal error code, arguments: [4355], [1502], [0], [1], [0], [38], [], [], [], [], [], []
ORA-00604: error occurred at recursive SQL level 1
ORA-01502: index 'SYS.I_AUDIT' or partition of such index is in unusable state

skip_unusable_indexes = TRUE

CALL STACK

[08]: ksesic5 [KSE]
[09]: ktsauu []<-- Signaling
[10]: kqrpsf []
[11]: ausdrvo []
[12]: ausdrvs []
[13]: ausdrv []

Table analyzed successfully.
Index analyzed successfully.

UPGRADE_SUMMARY.LOG (no ORA-00600)

SQL> @utlu121s.sql

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

CATCTL REPORT = /u01/app/oracle/product/12.1.0.2/l4dv/cfgtoollogs/l4dv/upgrade/upg_summary.log

PL/SQL procedure successfully completed.

Function created.

Oracle Database 12.1 Post-Upgrade Status Tool 08-17-2016 11:01:43

ORA-06512: at line 4
ORA-01502: index 'SYS.I_AUDIT_ACTIONS' or partition of such index is in unusa
ble state
ORA-06512: at line 4

unusable state ORA-06512: at line 4

Oracle Server INVALID 12.1.0.2.0 00:09:01

select owner,OBJECT_NAME,STATUS from dba_objects where object_name like '%I_AUDIT%' and owner='SYS'

OWNER OBJECT_NAME STATUS
------------------------------ ------------------------
SYS I_AUDIT_ACTIONS VALID
SYS I_AUDIT VALID

select owner,INDEX_NAME,status from dba_indexes where status!='VALID' and index_name like '%I_AUDIT%';

OWNER INDEX_NAME STATUS
------------------------------ ------------------------------ --------
SYS I_AUDIT UNUSABLE
SYS I_AUDIT_ACTIONS UNUSABLE

Or visa versa. One of these are unusable.

Changes

 None

Cause