ORA-00600 [4355] [1502] Index Unusable During Upgrade
(Doc ID 2179980.1)
Last updated on MAY 21, 2020
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud 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
Information in this document applies to any platform.
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
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 |
| <Internal_Only>Please Note: The ORA-00600 is simply reporting that the ORA-01502 error is happening. The problem is the ORA-01502.</Internal_Only> |
| ALERT.LOG |
| CALL STACK |
| Table analyzed successfully. Index analyzed successfully. |
| UPGRADE_SUMMARY.LOG (no ORA-00600) |
| select owner,OBJECT_NAME,STATUS from dba_objects where object_name like '%I_AUDIT%' and owner='SYS' |
| select owner,INDEX_NAME,status from dba_indexes where status!='VALID' and index_name like '%I_AUDIT%'; |
| Changes |
| Cause |
| Solution |
| References |