Database Crashed After an ORA-600 [KSSRMP1] Was Hit (Doc ID 1371273.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.2 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 29-Apr-2013***

Symptoms

In a RAC environment, after hitting a failure in a logon trigger, a job queue process fails with ORA-600 [KSSRMP1], eg. as:

Errors in file /u01/app/oracle/diag/rdbms/scbd/SCBD1/trace/SCBD1_j000_11891.trc (incident=242787):
ORA-00600: internal error code, arguments:[KSSRMP1], [], [], [], [], [], [], [], [], [], [], []


and subsequently the database crashes due to PMON hitting an ORA-600 [1163], eg.:

Thu Oct 06 15:00:46 2011
Errors in file /u01/app/oracle/diag/rdbms/scbd/SCBD1/trace/SCBD1_ora_5171.trc (incident=233096):
ORA-00600: internal error code, arguments: [kxsGetRuntimeLock2], [0xA7790AE40], [1], [1], [0], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/scbd/SCBD1/incident/incdir_233096/SCBD1_ora_5171_i233096.trc
Thu Oct 06 15:00:51 2011
Errors in file /u01/app/oracle/diag/rdbms/scbd/SCBD1/trace/SCBD1_pmon_2648.trc (incident=231622):
ORA-00600: internal error code, arguments: [1163], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/scbd/SCBD1/incident/incdir_231622/SCBD1_pmon_2648_i231622.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /u01/app/oracle/diag/rdbms/scbd/SCBD1/trace/SCBD1_pmon_2648.trc:
ORA-00600: internal error code, arguments: [1163], [], [], [], [], [], [], [], [], [], [], []
PMON (ospid: 2648): terminating the instance due to error 472


It is also possible that the database may crash due to this problem after a job queue process fails with ORA-600 [ksqcmi:res32] as in:

Errors in file /u01/scratch/honsun/log/diag/rdbms/oltpdb/oltp7/trace/oltp7_cjq0_18344.trc (incident=368756):
ORA-600: internal error code, arguments: [1163], [], [], [], [], [], [], [], [], [], [], []
ORA-600: internal error code, arguments: [ksqcmi:res32], [0x252014D90], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/scratch/honsun/log/diag/rdbms/oltpdb/oltp7/incident/incdir_368756/oltp7_cjq0_18344_i368756.trc


The key symptoms are:

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