developers

    Forum Stats

  • 3,873,653 Users
  • 2,266,622 Discussions
  • 7,911,597 Comments

Discussions

ORA-00600

good day everyone.

we have oracle XE version 11.2.0.2.0


for the last few days we have been getting error ORA-00600 when making changes on one table

log trace:


Incident 19265 created, dump file: /u01/app/oracle/diag/rdbms/xe/XE/incident/incdir_19265/XE_ora_44318_i19265.trc

ORA-00600: internal error code, arguments: [17114], [0x7F7FE8619F58], [], [], [], [], [], [], [], [], [], []



*** 2022-09-29 13:01:31.290

Incident 19266 created, dump file: /u01/app/oracle/diag/rdbms/xe/XE/incident/incdir_19266/XE_ora_44318_i19266.trc

ORA-00600: internal error code, arguments: [17182], [0x7F7FE8619F58], [], [], [], [], [], [], [], [], [], []


Error ORA-600 signaled at ksedsts()+461<-00000000036EC3B3<-kgerinv()+751<-kgedes()+337<-kgersel()+1322<-kgersel()+175<-kgh_overwrite_comment()+4234<-kghfrf()+2283<-kxsFreeAllFramePages()+302<-kxsFreeAllFramePages()+49<-kxsnfy()+335<-kscnfy()+862<-ksmugf()+180<-ksudel()+6742<-ksudel()+787<-opilof()+2316<-opiodr()+2797<-ttcpip()+2289<-opitsk()+1670<-opiino()+966<-opiodr()+2797<-opidrv()+570<-sou2o()+103<-opimai_real()+133<-ssthrdmain()+252<-main()+201<-__libc_start_main()+253<-_start()+37

Error ORA-600 signaled at ksedsts()+461<-00000000036EC3B3<-kgerinv()+751<-kgedes()+337<-kgersel()+1322<-kgersel()+175<-kscnfy()+2193<-ksmugf()+180<-ksudel()+6742<-ksudel()+787<-opilof()+2316<-opiodr()+2797<-ttcpip()+2289<-opitsk()+1670<-opiino()+966<-opiodr()+2797<-opidrv()+570<-sou2o()+103<-opimai_real()+133<-ssthrdmain()+252<-main()+201<-__libc_start_main()+253<-_start()+37

Error ORA-600 signaled at ksedsts()+461<-00000000036EC3B3<-kgerinv()+751<-kgedes()+337<-kgersel()+1322<-kgersel()+175<-kscnfy()+540<-ksmugf()+180<-ksudel()+6742<-ksudel()+787<-opilof()+2316<-opiodr()+2797<-ttcpip()+2289<-opitsk()+1670<-opiino()+966<-opiodr()+2797<-opidrv()+570<-sou2o()+103<-opimai_real()+133<-ssthrdmain()+252<-main()+201<-__libc_start_main()+253<-_start()+37

Error ORA-600 signaled at ksedsts()+461<-00000000036EC3B3<-kgerinv()+751<-kgedes()+337<-kgersel()+1322<-kgersel()+175<-ksudel()+2525<-opilof()+2316<-opiodr()+2797<-ttcpip()+2289<-opitsk()+1670<-opiino()+966<-opiodr()+2797<-opidrv()+570<-sou2o()+103<-opimai_real()+133<-ssthrdmain()+252<-main()+201<-__libc_start_main()+253<-_start()+37

Error ORA-600 signaled at ksedsts()+461<-00000000036EC3B3<-kgerinv()+751<-kgedes()+337<-kgersel()+1322<-kgersel()+175<-ksudel()+1178<-opilof()+2316<-opiodr()+2797<-ttcpip()+2289<-opitsk()+1670<-opiino()+966<-opiodr()+2797<-opidrv()+570<-sou2o()+103<-opimai_real()+133<-ssthrdmain()+252<-main()+201<-__libc_start_main()+253<-_start()+37

Error ORA-600 signaled at ksedsts()+461<-00000000036EC3B3<-kgerinv()+751<-kgedes()+337<-kgersel()+1322<-kgersel()+175<-opilof()+4403<-opiodr()+2797<-ttcpip()+2289<-opitsk()+1670<-opiino()+966<-opiodr()+2797<-opidrv()+570<-sou2o()+103<-opimai_real()+133<-ssthrdmain()+252<-main()+201<-__libc_start_main()+253<-_start()+37

Error ORA-600 signaled at ksedsts()+461<-00000000036EC3B3<-kgerinv()+751<-kgedes()+337<-kgersel()+1322<-kgersel()+175<-opilof()+5628<-opiodr()+2797<-ttcpip()+2289<-opitsk()+1670<-opiino()+966<-opiodr()+2797<-opidrv()+570<-sou2o()+103<-opimai_real()+133<-ssthrdmain()+252<-main()+201<-__libc_start_main()+253<-_start()+37

Incident 19267 created, dump file: /u01/app/oracle/diag/rdbms/xe/XE/incident/incdir_19267/XE_ora_44318_i19267.trc

ORA-00600: internal error code, arguments: [17147], [0x7F7FE8619F58], [], [], [], [], [], [], [], [], [], []

ORA-00600: internal error code, arguments: [17182], [0x7F7FE8619F58], [], [], [], [], [], [], [], [], [], []

There is also a dump file:


Dump continued from file: /u01/app/oracle/diag/rdbms/xe/XE/trace/XE_ora_44318.trc

ORA-00600: internal error code, arguments: [17147], [0x7F7FE8619F58], [], [], [], [], [], [], [], [], [], []

ORA-00600: internal error code, arguments: [17182], [0x7F7FE8619F58], [], [], [], [], [], [], [], [], [], []


========= Dump for incident 19267 (ORA 600 [17147]) ========

----- Beginning of Customized Incident Dump(s) -----

********** Internal heap ERROR 17147 addr=0x7f7fe8619f58 *********

***** Dump of memory around addr 0x7f7fe8619f58:

7F7FE8618F50          00020012 00000000     [........]

7F7FE8618F60 00000000 00000000 00000000 00000000 [................]

7F7FE8618F70 00000004 0100576F 00003B0A 00003B0A [....oW...;...;..]

7F7FE8618F80 003F0008 00001FE8 00000000 00000000 [..?.............]

7F7FE8618F90 00000000 00000001 00000001 00000000 [................]

7F7FE8618FA0 E842FF94 00007F7F 00000000 00000000 [..B.............]

7F7FE8618FB0 7EA1A014 00000000 00000000 00000000 [...~............]

7F7FE8618FC0 00100001 00000000 00000000 00000000 [................]

7F7FE8618FD0 07D89F1E 00000000 0EF59B40 00007FFC [[email protected]]

7F7FE8618FE0 00000000 00000000 00000000 00000000 [................]

7F7FE8618FF0 00000000 00000000 07D8A3F0 00000000 [................]

7F7FE8619000 E8430A90 00007F7F 00000000 00000000 [..C.............]

7F7FE8619010 00000000 00000000 00000000 00000000 [................]

7F7FE8619020 00000000 00000000 FFFFFFFF 0000FFFF [................]

7F7FE8619030 0000035C 00000000 00000004 0010B773 [\...........s...]

7F7FE8619040 00000000 00000000 00000000 00000000 [................]

    Repeat 2 times

(...)

******************************************************

HEAP DUMP heap name="session heap" desc=0x7f7fe85e6d30

 extent sz=0xffc8 alt=32767 het=32767 rec=0 flg=3 opc=3

 parent=0xa30b600 owner=0x9f4e3a00 nex=(nil) xsz=0xffd0 heap=(nil)

 fl2=0x60, nex=(nil)

EXTENT 0 addr=0x7f7fe8363030

 Chunk   7f7fe8363040 sz=  65472  free   "        "

EXTENT 1 addr=0x7f7fe8353030

 Chunk   7f7fe8353040 sz=  65472  free   "        "

EXTENT 2 addr=0x7f7fe8323030

 Chunk   7f7fe8323040 sz=   104  perm   "perm      " alo=104

 Chunk   7f7fe83230a8 sz=  65368  free   "        "

EXTENT 3 addr=0x7f7fe8493030

 Chunk   7f7fe8493040 sz=   112  perm   "perm      " alo=112

 Chunk   7f7fe84930b0 sz=  65360  free   "        "

EXTENT 4 addr=0x7f7fe8483030

 Chunk   7f7fe8483040 sz=   7512  free   "        "

 Chunk   7f7fe8484d98 sz=  16440  freeable "kxsFrame16kPage"

 Chunk   7f7fe8488dd0 sz=  41520  free   "        "

EXTENT 5 addr=0x7f7fe8473030

 Chunk   7f7fe8473040 sz=   192  perm   "perm      " alo=192

 Chunk   7f7fe8473100 sz=   2136  freeable "PLS UGA hp   " ds=0x7f7fe85fe7f0

 Chunk   7f7fe8473958 sz=  63144  free   "        "

EXTENT 6 addr=0x7f7fe8463030

 Chunk   7f7fe8463040 sz=   1008  free   "        "

 Chunk   7f7fe8463430 sz=   2520  freeable "koh-kghu sessio"

 Chunk   7f7fe8463e08 sz=  29064  free   "        "

 Chunk   7f7fe846af90 sz=  16440  freeable "kxsFrame16kPage"

(...)

EXTENT 14 addr=0x7f7fe8610030

 Chunk   7f7fe8610040 sz=   3360  free   "        "

 Chunk   7f7fe8610d60 sz=   4152  freeable "kxsFrame4kPage "

 Chunk   7f7fe8611d98 sz=   4152  freeable "kxsFrame4kPage "

 Chunk   7f7fe8612dd0 sz=   4152  freeable "kxsFrame4kPage "

 Chunk   7f7fe8613e08 sz=   4152  freeable "kxsFrame4kPage "

 Chunk   7f7fe8614e40 sz=   4152  freeable "kxsFrame4kPage "

 Chunk   7f7fe8615e78 sz=   4152  freeable "kxsFrame4kPage "

 Chunk   7f7fe8616eb0 sz=   4152  freeable "kxsFrame4kPage "

 Chunk   7f7fe8617ee8 sz=   4152 NEXT NEXT CHUNK'S PREVIOUS POINTER NOT POINTING TO NEXT CHUNK   a202e696b79

 freeable "kxsFrame4kPage "


Two suspect chunks will be dumped with their memory contents

The first chunk (above) may have corrupted the size of the second chunk

More likely is that the second chunk has corrupted the following chunk


Dump of memory from 0x00007F7FE8617EE8 to 0x00007F7FE8619FD8


can you tell me how to check what part of table is corrupted?

developers