ORA-7445 [Kqlvld] Occurs in while Running Utlrp.Sql or DataPump (Doc ID 739336.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4
Oracle Server - Enterprise Edition - Version: 11.1.0.6
This problem can occur on any platform.

Symptoms

This issue was observed with Oracle 10.2.0.3 on a Linux x86_64 server.

It occurred shortly after migrating from 32-bit to 64-bit and applying the CPUAPR2008 patch.

The utlrp script fails at the beginning with
   SQL> DECLARE
   2 threads pls_integer := &&1;
   3 BEGIN
   4 utl_recomp.recomp_parallel(threads);
   5 END;
   6 /
   DECLARE
   *
   ERROR at line 1:
   ORA-03113: end-of-file on communication channel


The alert log shows the following ORA-7445 error

ORA-07445: exception encountered: core dump [kqlvld()+10955] [SIGSEGV] [Address not mapped to
object] [0x000000038] [] []



The issue reproduces consistently when running the utlrp.sql script

The trace file may show a failure in compiling rule sets.
For example....

   ----- PL/SQL Call Stack -----
   object line object
   handle number name
   0x93e40f78 243 package body SYS.DBMS_RULE_ADM    <<<---
   0x8ecf39c0 1 anonymous block
   0x9f9bcb10 592 package body SYS.DBMS_AQADM_SYSCALLS
   0x93e34f98 1358 package body SYS.DBMS_PRVTAQIS
   0x8e2553f0 6707 package body SYS.DBMS_AQADM_SYS
   0x8925b428 391 package body SYS.DBMS_AQADM
   0x927e5fd8 9 anonymous block

 

 


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