ORA-00600: internal error code, arguments: [13013], [5001], [268], [8457666], [3 ], [8457666], [17], [], [], [], [], []

Observation

The following message is observed in alert log 

Dump continued from file: /apps/app/oracle/diag/rdbms/ebportal/ebportal/trace/ebportal_smon_30901.trc

ORA-00600: internal error code, arguments: [13013], [5001], [268], [8457666], [3

], [8457666], [17], [], [], [], [], []

Checks

Upon checking the trace file the following is observed

========= Dump for incident 480371 (ORA 600 [13013]) ========
 
*** 2023-08-24 10:06:59.708
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=dma0vxbwh325p) -----
update smon_scn_time set time_mp=:1, time_dp=:2, scn=:3, scn_wrp=:4,  scn_bas=:5
, num_mappings=:6, tim_scn_map=:7 where scn =  (select min(scn) from smon_scn_ti
me)
 
----- Call Stack Trace -----
calling              call     entry                argument values in hex
location             type     point                (? means dubious value)
-------------------- -------- -------------------- ----------------------------
skdstdst()+41        call     kgdsdst()            000000000 ? 000000000 ?
                                                   7FFF7C6B3CF0 ? 7FFF7C6B3DC8 ?
                                                   7FFF7C6B8870 ? 000000002 ?
ksedst1()+103        call     skdstdst()           000000000 ? 000000000 ?
                                                   7FFF7C6B3CF0 ? 7FFF7C6B3DC8 ?

Here the ORA-00600 is being thrown due to update statment

update smon_scn_time set time_mp=:1, time_dp=:2, scn=:3, scn_wrp=:4,  scn_bas=:5 , num_mappings=:6, tim_scn_map=:7 where scn =  (select min(scn) from smon_scn_time)

Solution

$ sqlplus "/as sysdba"

 SQL> analyze table smon_scn_time VALIDATE STRUCTURE CASCADE;
analyze table smon_scn_time VALIDATE STRUCTURE CASCADE
*
ERROR at line 1:
ORA-01499: table/index cross reference failure - see trace file

It has written one trace file. And upon checking the trace file

$ cat ebportal_ora_34703.trc|more
Trace file /apps/app/oracle/diag/rdbms/ebportal/ebportal/trace/ebportal_ora_34703.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /apps/app/oracle/product/11.2.0.4.0
System name:    Linux
Node name:      ITPFEBPAS0812P
Release:        2.6.32-220.el6.x86_64
Version:        #1 SMP Wed Nov 9 08:03:13 EST 2011
Machine:        x86_64
Instance name: ebportal
Redo thread mounted by this instance: 1
Oracle process number: 35
Unix process pid: 34703, image: oracle@ITPFEBPAS0812P (TNS V1-V3)
 
 
*** 2023-08-24 12:06:44.308
*** SESSION ID:(853.137) 2023-08-24 12:06:44.308
*** CLIENT ID:() 2023-08-24 12:06:44.308
*** SERVICE NAME:(SYS$USERS) 2023-08-24 12:06:44.308
*** MODULE NAME:(sqlplus@ITPFEBPAS0812P (TNS V1-V3)) 2023-08-24 12:06:44.308
*** ACTION NAME:() 2023-08-24 12:06:44.308
 
row not found in index tsn: 1 rdba: 0x008001a2
env [0x7fff4e3bc2c0]: (scn: 0x1111.39e27df7  xid: 0x000a.017.00042add  uba: 0x00000000.0000.00  statement num=0  parent xid: 0x0000.000.00000000  st-scn: 0x0000.00000000  hi-scn: 0x0000.00000000  m
a-scn: 0x1111.39e27d1d  flg: 0x00000060)
col 0; len 8; (8):  c7 13 4b 20 48 49 43 1e
Block header dump:  0x00810dc2
 Object id on Block? Y
 seg/obj: 0x10c  csc: 0x110e.50ec5df  itc: 2  flg: E  typ: 1 - DATA
     brn: 0  bdba: 0x810dc0 ver: 0x01 opc: 0
     inc: 0  exflg: 0
 
 Itl           Xid                  Uba         Flag  Lck        Scn/Fsc
0x01   0x0003.013.000009a5  0x00c07082.01eb.18  C---    0  scn 0x1087.fa92e84a
0x02   0x000b.001.00002bd4  0x00c156a4.0664.12  C---    0  scn 0x110e.040c0794
bdba: 0x00810dc2

Here 

Rdba = 008001a2

Tsn = 1

SELECT owner, segment_name, segment_type, partition_name
FROM DBA_SEGMENTS
WHERE header_file = (SELECT file#
                     FROM   v$datafile
                     WHERE  rfile# = dbms_utility.data_block_address_file(to_number('008001a2','XXXXXXXX'))
                       AND  ts#= 1)
   AND header_block = dbms_utility.data_block_address_block(to_number('008001a2','XXXXXXXX'))

The output of the above quey is  

SYS   I_DIR$MIGRATE_UI  INDEX

SQL> alter index I_DIR$MIGRATE_UI rebuild;
alter index I_DIR$MIGRATE_UI rebuild
*
ERROR at line 1:
ORA-03135: connection lost contact
Process ID: 34929
Session ID: 1714 Serial number: 137
 
 
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@122DBlive]$ sqlplus "/as sysdba"
 
SQL*Plus: Release 11.2.0.4.0 Production on Thu Aug 24 12:38:51 2023
 
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
 
Connected to an idle instance.
 
SQL> startup
ORACLE instance started.
 
Total System Global Area 2889490432 bytes
Fixed Size                  2256752 bytes
Variable Size            1124073616 bytes
Database Buffers         1744830464 bytes
Redo Buffers               18329600 bytes
Database mounted.
Database opened.

SQL> alter index I_DIR$MIGRATE_UI rebuild;
 
Index altered.
 
SQL>
 
  
SQL*Plus: Release 11.2.0.4.0 Production on Thu Aug 24 13:01:58 2023
 
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
 
 
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
 
SQL> ALTER INDEX SMON_SCN_TIME_TIM_IDX REBUILD ONLINE;
 
Index altered.
 
SQL> ALTER INDEX SMON_SCN_TIME_SCN_IDX REBUILD  ONLINE;
 
Index altered.
 
SQL> ANALYZE TABLE smon_scn_time VALIDATE STRUCTURE CASCADE ONLINE;
 
Table analyzed.
 
SQL>