Getting ORA-600 [kmgsb_resize_sga_target_1] After SGA_TARGET Is Changed To 0

(Doc ID 1272386.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.2.0.2 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms

After SGA_TARGET is dynamically changed to 0 at instance level getting errors like:
ORA-600: internal error code, arguments:: [kmgsb_resize_sga_target_1], [0], [128], [1], [], [], [], []


and instance crashed:
MMAN (ospid: ....): terminating the instance due to error 822



Stack trace:
skdstdst ksedst1 ksedst dbkedDefDump ksedmp ksfdmp dbgexPhaseII dbgexProcessError dbgeExecuteForError
dbgePostErrorKGE dbkePostKGE_kgsf kgeadse kgerinv_internal kgerinv kgeasnmierr kmgsb_resize_sga_target
ksbabs rget ksbrdp opirip opidrv sou2o opimai_real main main_opd_entry


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