ORA-600 [1433] OCCUR ON PRIMARY AND INSTANCE GOES DOWN (Doc ID 1282761.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.
Primary RAC and Standby RAC databases at 11.1.0.7


Symptoms


ALERT LOG

Tue Dec 07 07:44:17 2010
Errors in file /jv01/app/oracle/diag/rdbms/arsprod/ddest/diag/rdbms/arsprod/arsprod1/trace/arsprod1_lgwr_17161.trc (incident=12052):
ORA-00600: internal error code, arguments: [1433], [60], [], [], [], [], [], [], [], [], [], []
Incident details in: /jv01/app/oracle/diag/rdbms/arsprod/ddest/diag/rdbms/arsprod/arsprod1/incident/incdir_12052/arsprod1_lgwr_17161_i12052.trc
Tue Dec 07 07:44:17 2010
Errors in file /jv01/app/oracle/diag/rdbms/arsprod/ddest/diag/rdbms/arsprod/arsprod1/trace/arsprod1_arc0_17472.trc:
...
Tue Dec 07 07:44:41 2010
Instance terminated by LGWR, pid = 17161




TRACE FILE

Dump continued from file: /jv01/app/oracle/diag/rdbms/arsprod/ddest/diag/rdbms/arsprod/arsprod1/trace/arsprod1_lgwr_17161.trc
ORA-00600: internal error code, arguments: [1433], [60], [], [], [], [], [], [], [], [], [], []

========= Dump for incident 12052 (ORA 600 [1433]) ========
----- Beginning of Customized Incident Dump(s) -----
KSAAMB: fatal error out of msg blks after 60 sec timeout
ksasga.ksasgwfm = 1
1 * 'Monitor Cleanup'
2 * 'KSB action for X-instance calls'
3 * 'KSB action for bast checking'
...
70 ARC* 'Archiver wakeup'

...

proc = c00000057ffab480 KSASTRPL: 0
Dump of message links starting at node c00000057ffab900:
Forward Links:
[c00000057f2d3438,c00000057ffab900]msg 70, length 40
Dump of memory from 0xC00000057F2CF240 to 0xC00000057F2CF268
C00000057F2CF240 00000000 00000000 00000000 FFFFFFFF [................]
C00000057F2CF250 00000000 00010000 00000000 00000000 [................]
C00000057F2CF260 00000000 00000000 [........]
[c00000057f2ce818,c00000057f2cf228]msg 70, length 40
...

----- Call Stack Trace -----
saamb ksasnd ksbasend_internal ksbasend kcrrsend kcrrnsupirfs kcrrupirfs kcrrupiwda krslario krslarc krslsio kcrfwc_issue_standby_write kcrfw_post kcrfw_redo_write ksbabs ksbrdp opirip opidrv sou2o opimai_real main main_opd_entry

Changes

This issue happened with one of the Primary nodes that has been crashed because all ARCH are getting busy as seen in the above trace file.
However,when do a restart of the primary node or increase log_Archive_max_processes parameter to a higher value,the errors won't appear anymore.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms