My Oracle Support Banner

ORA-7445 [kgiPinObject], ORA-600 [pfri.c: pfri8: plio mismatch], or ORA-7445 [kglpnp] When Using Mutually Dependent PL/SQL packages (Doc ID 2045602.1)

Last updated on JUNE 06, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

  1. The following error is raised when trying to call a PL/SQL procedure which depends on another set of procedures which have mutual dependencies:
    [TOC00001]
    ORA-07445: exception encountered: core dump [kgiPinObject()+45] [SIGSEGV] [ADDR:0x24] [PC:0xCE03F7D] [Address not mapped to object] []

    [TOC00001-END]
    [TOC00002]
    ========= Dump for incident 297048 (ORA 7445 [kgiPinObject]) ========
    [TOC00003]
    ----- Beginning of Customized Incident Dump(s) -----
    Dumping swap information
    Memory (Avail / Total) = 1753.55M / 36046.97M
    Swap (Avail / Total) = 16383.18M / 16383.99M
    Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x24] [PC:0xCE03F7D, kgiPinObject()+45] [flags: 0x0, count: 1]
    Registers:
    %rax: 0x0000000000000000 %rbx: 0x0000000000000018 %rcx: 0x0000000000000000
    %rdx: 0x0000000000000018 %rdi: 0x00002b294953f840 %rsi: 0x00002b294a0405a8
    %rsp: 0x00007ffff4b448e0 %rbp: 0x00007ffff4b44910 %r8: 0x000000000000002c
    %r9: 0x00000000dfbc6310 %r10: 0x0000000000000000 %r11: 0x00000000000003d8
    %r12: 0x0000000000000005 %r13: 0x00002b294953f840 %r14: 0x00002b294a0405a8
    %r15: 0x0000000000000000 %rip: 0x000000000ce03f7d ïl: 0x0000000000010202
    kgiPinObject()+30 (0xce03f6e) mov %r13,-0x10(%rbp)
    kgiPinObject()+34 (0xce03f72) mov %rdi,%r13
    kgiPinObject()+37 (0xce03f75) mov 0x68(%r14),%rax
    kgiPinObject()+41 (0xce03f79) mov %r12,-0x8(%rbp)
    > kgiPinObject()+45 (0xce03f7d) testl $0x400,0x24(%rax)
    kgiPinObject()+52 (0xce03f84) jnz 0xce040db
    kgiPinObject()+58 (0xce03f8a) movzwl %bx,íx
    kgiPinObject()+61 (0xce03f8d) mov %r13,%rdi
    kgiPinObject()+64 (0xce03f90) or $64,íx

    *** 2015-06-05 18:51:22.335
    dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
    [TOC00004]
    ----- Current SQL Statement for this session (sql_id=a6u1166jmqfa2) -----
    DECLARE
      v_result_code   VARCHAR2 (1);
      v_error_text    VARCHAR2 (240);
    BEGIN
    ---<PL/SQL code here>--
    END;
    [TOC00005]
    ----- PL/SQL Stack -----
    ----- PL/SQL Call Stack -----
     object      line  object
     handle    number  name
    0xe2465050       130  package body <package1>
    0xe2465050       205  package body <package1>
    0xe2497390       494  package body <package2>
    0xe1b65ee0        11  package body <package3>
    ---
    0xe2497390       246  package body <package_n>
    0xe249bc00        33  anonymous block
    [TOC00005-END]
    [TOC00004-END]


  2. Also ORA-600 [pfri.c: pfri8: plio mismatch], ORA-600 [kglobpn-bad-dacnt] or ORA-7445 [kglpnp] errors can be raised

  3. Review of the generated tracefiles reveals a call stack similar to:
    ... <- sslsshandler <- sighandler <- kgiPinObject <- pevm_CHK_INST <- pfrinstr_XCAL <- pfrrun_no_tool <- pfrrun <- plsql_run <- peicnt <- kkxexe <- opiexe <- ...

Changes

The instance has been upgraded to 12.1.0.2.

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.