Get ORA-7445 [kqlmbivg] In RAC (Doc ID 1328322.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.

Symptoms

*** In RAC environment , one instance may crash with:

Exception [type: SIGSEGV, Invalid Permissions for object] [ADDR:0xA] [PC:0x400000000FF7E5E1, kqlmbivg()+2033] [flags: 0x0, count: 1]
Errors in file /siui_ora_home/oracle/app/diag/rdbms/siui/siui1/trace/siui1_lck0_9371.trc (incident=3560617):
ORA-7445: exception encountered: core dump [kqlmbivg()+2033] [SIGSEGV]
[ADDR:0xA] [PC:0x400000000FF7E5E1] [Invalid Permissions for object] []
Incident details in:
/siui_ora_home/oracle/app/diag/rdbms/siui/siui1/incident/incdir_3560617/siui1_lck0_9371_i3560617.trc
..............
PMON (ospid: 9248): terminating the instance due to error 480
Wed Apr 27 09:05:17 2011
ORA-1092 : opitsk aborting process

*** The call stack trace is:

----- Call Stack Trace -----
skdstdst ksedst dbkedDefDump ksedmp ssexhd kqlmbivg kqlmba ksbcti ksbabs kclabs
ksbrdp opirip opidrv sou2o opimai_real ssthrdmain main main_opd_entry

*** From the incident trace file, we see the LCK0 process busy in the following event:

0: waiting for 'libcache interrupt action by LCK'
=0x0, =0x0, =0x0
wait_id=354091932 seq_num=12699 snap_id=2
wait times: snap=1.437314 sec, exc=1.437348 sec, total=1.438792 sec

*** Materialized views are involved in the failure, due to the MV lock in read-only mode.

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