My Oracle Support Banner

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

Last updated on MARCH 28, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.4 [Release 10.2]
Oracle Database - Enterprise Edition - Version 11.1.0.6 and later
Information in this document applies to any platform.
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

 

 

 

Changes

 Database upgraded to Oracle 10.2.0.3 on a Linux x86_64 server.

Cause

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
Symptoms
Changes
Cause
Solution
References


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