My Oracle Support Banner

CONNECT via SQL*Plus = ORA-600[kspgip2] (Doc ID 2444869.1)

Last updated on FEBRUARY 19, 2019

Applies to:

Oracle Database - Standard Edition - Version to [Release 12.2]
Information in this document applies to any platform.


Attempting to connect to the database via SQL*Plus fails as follows:

SQL> connect test/test
ORA-00600: internal error code, arguments: [kspgip2], [0x07118F178], [54],[sessions], [], [], [], [], [], [], [], []

Warning: You are no longer connected to ORACLE.


The Call Stack Trace in the associated incident trace file shows:

kspgip <- kywmnfy <- kscnfy <- ksmcpg <- ksucrp <- ksvrdp_int <- ksvrdp <- opirip <- opidrv
 <- sou2o <- opimai_real <- opimai <- BackgroundThreadStart


Additional symptoms may include:

-  ORA-600[kspgip2]

-  ORA-600[krsl_redo_complete.test_half.2]

-  ORA-600[ksb_bg_rstrt_pol: no param]

-  ORA-7445[lxinitc]

-  show parameter shows a value of SESSIONS null

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
java_max_sessionspace_size           integer                                  0
java_soft_sessionspace_limit         integer                                  0
license_max_sessions                 integer                                  0
license_sessions_warning             integer                                  0
sessions                             integer
shared_server_sessions               integer



A command "alter system reset sessions scope=both" was successfully executed.

SQL> alter system reset sessions scope=both;

System altered.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.