ORA-00600 [1113] Instance Termination When Killing Sessions

(Doc ID 561322.1)

Last updated on NOVEMBER 05, 2008

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.8.0 and 10.2.0.4.0
This problem can occur on any platform.

Symptoms

Error ORA-00600 [1113] is reported to the alert.log and the instance is terminated by PMON.

Mon Mar 1 00:52:02 2008
Errors in file /u01/ora/app/oracle/admin/IDX/bdump/idx_pmon_56552.trc:
ORA-00600: internal error code, arguments: [1113], [], [], [], [], [], [], []
Mon Mar 1 00:52:05 2008
Errors in file /u01/ora/app/oracle/admin/IDX/bdump/idx_pmon_56552.trc:
ORA-00600: internal error code, arguments: [1113], [], [], [], [], [], [], []
Mon Mar 1 00:52:05 2008
PMON: terminating instance due to error 600
Instance terminated by PMON, pid = 56552


The stack trace in the PMON trace file will have the following functions on the stack:

ksedmp ksfdmp kgeriv kgesiv
ksesic0 kssrmf ksuxds kssxdl
ksuxdl ksuxdp ksuxdpg ksucln ksbrdp

Changes

To be encountering this problem resource limits must be in use in the database and sessions must be killed from within Oracle using the alter system kill session command.  The error is normally encountered only in environments where the kill command is being executed programmatically at short intervals from the last command execution.

SQL> ALTER SYSTEM KILL SESSION <SID>, <SERIAL#>; 

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