ORA-00600: internal error code, arguments: [4553], [2], [0], [], [], [], []
442261Jan 8 2009 — edited Jan 8 2009hello,
i have the ORA-00600: internal error code, arguments: [4553], [2], [0], [], [], [], [], [] in my alert.log file. One resolution is to recreate the invalid objects, but this error is recurring frequently. In touch with oracle. has anyone faced this issue, what could be the problem?
thanks in advance.
Starting up ORACLE RDBMS Version: 10.1.0.4.0.
System parameters with non-default values:
processes = 300
shared_pool_size = 83886080
large_pool_size = 8388608
java_pool_size = 50331648
nls_language = american
nls_territory = america
sga_target = 369098752
control_files = O:\ORACLE\DATABASE\CONTROL01.CTL, O:\ORACLE\DATABASE\CONTROL02.CTL, O:\ORACLE\DATABASE\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 25165824
compatible = 10.1.0.2.0
db_file_multiblock_read_count= 16
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=orclXDB)
shared_servers = 0
job_queue_processes = 10
background_dump_dest = D:\ORACLE\PRODUCT\10.1.0\ADMIN\ORCL\BDUMP
user_dump_dest = D:\ORACLE\PRODUCT\10.1.0\ADMIN\ORCL\UDUMP
core_dump_dest = D:\ORACLE\PRODUCT\10.1.0\ADMIN\ORCL\CDUMP
sort_area_size = 65536
db_name = ORCL
open_cursors = 1000
pga_aggregate_target = 25165824
LGWR started with pid=5, OS id=136
SMON started with pid=7, OS id=3524
RECO started with pid=8, OS id=3244
CJQ0 started with pid=9, OS id=420
.....
Thread 1 advanced to log sequence 14383
Current log# 1 seq# 14383 mem# 0: O:\ORACLE\DATABASE\REDO11.LOG
Current log# 1 seq# 14383 mem# 1: O:\ORACLE\DATABASE\REDO12.LOG
Sat Nov 08 12:45:45 2008
Private_strands 15 at log switch
Thread 1 advanced to log sequence 14384
Current log# 2 seq# 14384 mem# 0: O:\ORACLE\DATABASE\REDO21.LOG
Current log# 2 seq# 14384 mem# 1: O:\ORACLE\DATABASE\REDO22.LOG
Sat Nov 08 13:15:31 2008
Errors in file d:\oracle\product\10.1.0\admin\orcl\udump\orcl_ora_4084.trc:
ORA-00600: internal error code, arguments: [4553], [2], [0], [], [], [], [], []
Sat Nov 08 13:19:42 2008
Doing block recovery for file 2 block 332
Block recovery range from rba 14384.24287.0 to scn 0.368893505
Sat Nov 08 13:19:43 2008
Recovery of Online Redo Log: Thread 1 Group 2 Seq 14384 Reading mem 0
Mem# 0 errs 0: O:\ORACLE\DATABASE\REDO21.LOG
Mem# 1 errs 0: O:\ORACLE\DATABASE\REDO22.LOG
Block recovery completed at rba 14384.24315.16, scn 0.368893506
Doing block recovery for file 2 block 97
Block recovery range from rba 14384.13864.0 to scn 0.368893505
Sat Nov 08 13:19:44 2008
Recovery of Online Redo Log: Thread 1 Group 2 Seq 14384 Reading mem 0
Mem# 0 errs 0: O:\ORACLE\DATABASE\REDO21.LOG
Mem# 1 errs 0: O:\ORACLE\DATABASE\REDO22.LOG
Block recovery completed at rba 14384.24315.16, scn 0.368893506
Doing block recovery for file 5 block 651570
Block recovery range from rba 14384.24287.0 to scn 0.368893508
Sat Nov 08 13:19:45 2008
Recovery of Online Redo Log: Thread 1 Group 2 Seq 14384 Reading mem 0
Mem# 0 errs 0: O:\ORACLE\DATABASE\REDO21.LOG
Mem# 1 errs 0: O:\ORACLE\DATABASE\REDO22.LOG
Block recovery completed at rba 14384.24373.16, scn 0.368893509
Sat Nov 08 13:19:46 2008
Errors in file d:\oracle\product\10.1.0\admin\orcl\udump\orcl_ora_4084.trc:
ORA-00600: internal error code, arguments: [4553], [2], [0], [], [], [], [], []
Doing block recovery for file 2 block 704
Block recovery range from rba 14384.24391.0 to scn 0.368893512
Sat Nov 08 13:23:27 2008
Recovery of Online Redo Log: Thread 1 Group 2 Seq 14384 Reading mem 0
Mem# 0 errs 0: O:\ORACLE\DATABASE\REDO21.LOG
Mem# 1 errs 0: O:\ORACLE\DATABASE\REDO22.LOG
Block recovery completed at rba 14384.24419.16, scn 0.368893513
Doing block recovery for file 2 block 41
Block recovery range from rba 14384.24469.0 to scn 0.368894006
Sat Nov 08 13:32:29 2008
Recovery of Online Redo Log: Thread 1 Group 2 Seq 14384 Reading mem 0
Mem# 0 errs 0: O:\ORACLE\DATABASE\REDO21.LOG
Mem# 1 errs 0: O:\ORACLE\DATABASE\REDO22.LOG
Block recovery completed at rba 14384.25039.16, scn 0.368894007
Doing block recovery for file 5 block 651570
Block recovery range from rba 14384.24287.0 to scn 0.368893508
Sat Nov 08 13:32:30 2008
Recovery of Online Redo Log: Thread 1 Group 2 Seq 14384 Reading mem 0
Mem# 0 errs 0: O:\ORACLE\DATABASE\REDO21.LOG
Mem# 1 errs 0: O:\ORACLE\DATABASE\REDO22.LOG
Block recovery completed at rba 14384.24373.16, scn 0.368893509
Sat Nov 08 13:45:44 2008
Private_strands 15 at log switch
Thread 1 advanced to log sequence 14385
Current log# 3 seq# 14385 mem# 0: O:\ORACLE\DATABASE\REDO31.LOG
Current log# 3 seq# 14385 mem# 1: O:\ORACLE\DATABASE\REDO32.LOG
Sat Nov 08 14:31:08 2008
Private_strands 15 at log switch
Thread 1 advanced to log sequence 14386
Current log# 1 seq# 14386 mem# 0: O:\ORACLE\DATABASE\REDO11.LOG
Current log# 1 seq# 14386 mem# 1: O:\ORACLE\DATABASE\REDO12.LOG
Sat Nov 08 15:01:31 2008
Errors in file d:\oracle\product\10.1.0\admin\orcl\udump\orcl_ora_4048.trc:
ORA-00600: internal error code, arguments: [ktspgfb-1], [], [], [], [], [], [], []
orcl_ora_4048.trc:
*** SERVICE NAME:(SYS$USERS) 2008-11-08 13:15:30.942
*** SESSION ID:(303.2) 2008-11-08 13:15:30.942
*** 2008-11-08 13:15:30.942
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [4553], [2], [0], [], [], [], [], []
Current SQL statement for this session:
INSERT INTO ssv_tav_basic VALUES(:v1,TO_DATE(:v2,'DD-MM-YYYY HH24:MI:SS'),:v3,:v4,:v5,:v6,TO_DATE(:v7,'DD-MM-YYYY HH24:MI:SS'),:v8,:v9,:v10,:v11)
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedmp+576 CALLrel ksedst+0 0
ksfdmp.160+14 CALLrel ksedmp+0 3
_kgeriv+139 CALLreg 00000000 7FD3170 3
kgeasi+92 CALLrel kgeriv+0 7FD3170 7ECE838 11C9 2
8752BEC
ktbtas+149 CALLrel kgeasi+0 7FD3170 7ECE838 11C9 2 2 0 2
0 0 0 0
ktbair2+413 CALLrel ktbtas+0 17614014 30 875369C
kdxlne+517 CALLrel ktbair2+0
kcoissue_callback CALLreg 00000000 7F2CFA4 7F2CFE6 4 17614014
+153 875369C
kcoapl+751 CALLrel kco_issue_callback 7F2CFA0 17614000 875369C
+0
kcbapl+119 CALLrel kcoapl+0 7F2CFA0 17614000 1 5 2000 0
875369C
kcrfwredo_gen+255 CALLrel _kcbapl+0 7F2CFA0 177F4E90 8753180 0
4 875369C
kcbchg1+7688 CALLrel kcrfw_redo_gen+0
ktuchg+874 CALLrel kcbchg1+0 0 3 8753264 875327C 0 0
ktbchg2+115 CALLrel ktuchg+0 2 5B06C88 3 7F2D000 7F2D008
7F2A7A0 875369C 7F2CFA0 0 0
kdisnewle+1681 CALLrel ktbchg2+0 0 5B06C88 7F2D000 7F2D008
7F2A7A0 8753694 7F2CFA0 0 0
kdisle+4004 CALLrel kdisnewle+0 5B06C7C 149C3C3 8753694
8753730 7F28764 A4 9D 0 2 0 0
0 8753938
kdiins0+6796 CALLrel kdisle+0 2EB6AAAC 8753C98 87541A4 1 2
8756AB0 140 875D664 342C9238
0 0 0
kdiins+52 CALLrel kdiins0+0 2EB6AAAC 6 875D664 8756AB0 0
0 0 2 FF 0 0 0 0
kauxsin+4814 CALLrel kdiins+0 2EB6AAAC 6 875D664 8756AB0 2
FF 0 0
insidx.103+884 CALLrel kauxsin+0 2EB6AA5C 875D660 0 7F46984
7F469B4 7F469CC 7F46958 0 0 0
0 0 0 0 0 2C04A990 B D218 1 0
0
insrowFastPath.103 CALLrel insidx.103+0 7F468B4
+189
insdrvFastPath.103 CALLrel insrowFastPath.103 7F468B4 875D864 0 7F468B4
+357 +0
inscovexe+916 CALLrel insdrvFastPath.103 7F468B4
+0
_insExecStmtExecIni CALL??? 00000000 1C8C07CC 2395C188 875DC70
Engine.103+54
insexe+232 CALLrel insExecStmtExecIni 1C8C07CC 2395C188 875DC70
Engine.103+0
opiexe+12507 CALLrel insexe+0 2EC98954 875DC70
_opiodr+973 CALLreg 00000000 4 4 875E7D0
_ttcpip+1830 CALLreg 00000000 4 4 875E7D0 3
_opitsk+1098 CALL??? 00000000
opiino+938 CALLrel opitsk+0 0 0 7FD9BB0 7E5EEF8 DF 0
_opiodr+973 CALLreg 00000000 3C 4 875FBC0
opidrv+479 CALLrel opiodr+0 3C 4 875FBC0 0
sou2o+45 CALLrel opidrv+0 3C 4 875FBC0
opimai+237 CALLrel sou2o+0
OracleThreadStart@ CALLrel opimai+0
4+910
77E64826 CALLreg 00000000