ORA-07445 第一参数为：kkqljpmpr

清疚 2022-08-06 02:28 14阅读 0赞

在版本11.2.0.1.0上，在pl/sql developer中执行一条SQL会导致连接中断，这种错误要到trace目录下找到错误日志文件，再定位。查了一下资料，是这个版本的bug。

Dump continued from file: d:\\app\\gcp\\diag\\rdbms\\orcl\\orcl\\trace\\orcl\_ora\_6040.trc

**ORA-07445: 出现异常错误: 核心转储 \[kkqljpmpr()+22\] \[ACCESS\_VIOLATION\] \[ADDR:0x78\] \[PC:0x56341C6\] \[UNABLE\_TO\_READ\] \[\]**

========= Dump for incident 24395 (ORA 7445 \[kkqljpmpr()+22\]) ========

\----- Beginning of Customized Incident Dump(s) -----

Exception \[type: ACCESS\_VIOLATION, UNABLE\_TO\_READ\] \[ADDR:0x78\] \[PC:0x56341C6, kkqljpmpr()+22\]

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

Process Id: 0x000020f4  Thread Id : 0x00001798    Time : Mon Dec 15 18:26:51

Excp. Code: 0xc0000005  Excp. Type: ACCESS\_VIO    Flags: 0x00000000

\------------------- Registers ----------------------------

ip=00000000056341C6 sp=000000002A0A5C80 rp=0000000000000000

r1=00000000292C1640 r2=00000000292C1640 r3=000000002933E9B0

r4=00000000292C1640 r5=000000002A0A5C80 r6=0000000000000000 r7=0000000000020B78

r8=0000000000000000 r9=00000000292CFD60 r10=0000000000000000 r11=0000000000000002

r12=0000000000000005 r13=0000000029348ED0 r14=0000000000000001 r15=00000000292C1640

\------------------- End of Registers ---------------------

\*\*\* 2014-12-15 18:26:51.745

dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)

\----- Current SQL Statement for this session (sql\_id=gsak3fq15mt5b) -----

with

dt2 as (select count(1) over() total$,1 null\_flag\_,row\_number() over(order by null) rn,

T2.ID factor1,

T1.ID CN\_1,

T1.BUREAU\_CODE CN\_2,

T1.DEVICE\_CODE CN\_3

from DM\_DEVICE T1,SP\_PD\_DEFECT T2

where T1.ID=T2.DEVICE\_ID

and 1=1

and rownum <= 10),

sc as (select row\_number() over(order by null) rn,

COUNT(DISTINCT factor1) factor1

from dt2 dt

where 1=1

GROUP BY 1),

cal as (select row\_number() over(order by max(rn),grouping(1)) rn,grouping(1) gp,

max(factor1) C\_0\_1

from sc

group by rollup(1))

select max(dt.total$) over() total$,row\_number() over(order by cal.rn,dt.rn) rn,gp,

case when gp = 1 then cal.C\_0\_1 end C\_0\_1,

dt.CN\_1,

dt.CN\_2,

dt.CN\_3

from cal

left join dt2 dt

on gp=0 and dt.rn <= 5000

where gp = 1 or (gp = 0 and dt.null\_flag\_ is not null)

order by cal.rn,dt.rn

这是一个bug，如果不改SQL的话，只有通过打补丁的方式解决。

<table> 
 <tbody> 
  <tr> 
   <td>&nbsp;</td> 
   <td align="left"><span style="text-align:right; padding:0px 6px 0px 0px; font-size:14px; font-weight:bold">ORA-7445 [kkqljpmpr] (文档 ID 1288400.1)</span></td> 
   <td align="right"><a title="转到底部" href="https://support.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?_afrLoop=192430828711876&amp;id=1288400.1&amp;_afrWindowMode=0&amp;600argver=NULLargend&amp;_adf.ctrl-state=q8fmz6vy5_167#" style="white-space:nowrap; font-size:11px; text-decoration:none" rel="nofollow"><img title="转到底部" alt="转到底部" src="https://support.oracle.com/epmos/ui/images/quicklink_smlarrowdown_enabled.gif" style="border-bottom:medium none; border-left:medium none; display:inline; vertical-align:middle; border-top:medium none; border-right:medium none"><span style="color:rgb(0,50,134); margin-left:3px">转到底部</span></a></td> 
   <td><img alt="" src="/images/20220806/b053115a7fe948b3b10fd8fcb55b1934.png" width="20" height="10"></td> 
  </tr> 
 </tbody> 
</table>

--------------------

![t.gif][]

<table style="table-layout:fixed; overflow:hidden"> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top; overflow:hidden"> 
    <div style="overflow:auto"> 
     <div> 
      <span style="font-size:12px"></span> 
      <p><strong>In this Document</strong><br> <span style="font-family:inherit!important">&nbsp;&nbsp;<a href="https://support.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?_afrLoop=192430828711876&amp;id=1288400.1&amp;_afrWindowMode=0&amp;600argver=NULLargend&amp;_adf.ctrl-state=q8fmz6vy5_167#REF_PURPOSE" rel="nofollow">Purpose</a><br> &nbsp;&nbsp;<a href="https://support.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?_afrLoop=192430828711876&amp;id=1288400.1&amp;_afrWindowMode=0&amp;600argver=NULLargend&amp;_adf.ctrl-state=q8fmz6vy5_167#REF_SCOPE" rel="nofollow">Scope</a><br> &nbsp;&nbsp;<a href="https://support.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?_afrLoop=192430828711876&amp;id=1288400.1&amp;_afrWindowMode=0&amp;600argver=NULLargend&amp;_adf.ctrl-state=q8fmz6vy5_167#REF_TEXT" rel="nofollow">ORA-7445 [kkqljpmpr]</a><br> </span></p> 
      <hr> 
      <p></p> 
      <p></p> 
      <h2 style="border-bottom-color:rgb(196,209,230); border-bottom-width:1px; border-bottom-style:solid; padding-bottom:6px; text-transform:uppercase; background-color:rgb(119,119,115); padding-left:8px; color:rgb(255,255,255); font-size:16px; padding-top:6px"> APPLIES TO:</h2> Oracle Server - Enterprise Edition 
      <br> Information in this document applies to any platform. 
      <br> 
      <h2 style="border-bottom-color:rgb(196,209,230); border-bottom-width:1px; border-bottom-style:solid; padding-bottom:6px; text-transform:uppercase; background-color:rgb(119,119,115); padding-left:8px; color:rgb(255,255,255); font-size:16px; padding-top:6px"> <a rel="nofollow"></a>PURPOSE</h2> Note: For additional ORA-7445 related information please read&nbsp; 
      <a href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&amp;sourceId=1288400.1&amp;id=1092855.1" rel="nofollow">Document 1092855.1</a>. 
      <br> 
      <br> &nbsp; This article provides information on one or more bugs that are&nbsp; 
      <br> &nbsp; known to result in the given ORA-7445 error. 
      <br> 
      <br> 
      <h2 style="border-bottom-color:rgb(196,209,230); border-bottom-width:1px; border-bottom-style:solid; padding-bottom:6px; text-transform:uppercase; background-color:rgb(119,119,115); padding-left:8px; color:rgb(255,255,255); font-size:16px; padding-top:6px"> <a rel="nofollow"></a>SCOPE</h2> ERROR: 
      <br> &nbsp; ORA-7445 failing function "kkqljpmpr" 
      <br> 
      <br> 
      <h2 style="border-bottom-color:rgb(196,209,230); border-bottom-width:1px; border-bottom-style:solid; padding-bottom:6px; text-transform:uppercase; background-color:rgb(119,119,115); padding-left:8px; color:rgb(255,255,255); font-size:16px; padding-top:6px"> <a rel="nofollow"></a>ORA-7445 [KKQLJPMPR]</h2> 
      <p>SUGGESTIONS:</p> &nbsp; If the Known Issues section below does not help in terms of identifying 
      <br> &nbsp; a solution, please submit the trace files and alert.log to Oracle&nbsp; 
      <br> &nbsp; Support Services for further analysis. 
      <br> 
      <br> &nbsp; Known Issues: 
      <br> 
      <br> 
      <strong><u>Known Bugs</u></strong> 
      <blockquote>
        You can restrict the list below to issues likely to affect one of the following versions by clicking the relevant button:&nbsp; 
       <br> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
       <br> 
       <br> 
       <strong></strong> 
       <div>
         The list below is restricted to show only bugs believed to affect version 11.2.0.1. 
        <br> Other bugs may affect this version but have not been confirmed as being relevant yet. 
       </div> 
       <br> 
       <div>
         There is 1 bug listed. 
       </div> 
      </blockquote> 
      <blockquote> 
       <table> 
        <tbody> 
         <tr> 
          <td><strong>NB</strong></td> 
          <td><strong>Bug</strong></td> 
          <td><strong>Fixed</strong></td> 
          <td><strong>Description</strong></td> 
         </tr> 
         <tr> 
          <td>&nbsp;</td> 
          <td><a href="https://support.oracle.com/epmos/faces/DocumentDisplay?parent=DOCUMENT&amp;sourceId=1288400.1&amp;id=9002336.8" rel="nofollow">9002336</a></td> 
          <td>11.2.0.1.BP05, 11.2.0.2</td> 
          <td>Assorted Dumps with DISTINCT &amp; WITH clause</td> 
         </tr> 
        </tbody> 
       </table> 
       <ul> 
        <li><span style="color:red; font-family:inherit!important">'*'</span>&nbsp;indicates that an alert exists for that issue.</li> 
        <li><span style="color:red; font-family:inherit!important">'+'</span>&nbsp;indicates a particularly notable issue / bug.</li> 
        <li><span style="color:red; font-family:inherit!important">'P'</span>&nbsp;indicates a port specific bug.</li> 
        <li><strong>"OERI:<em>xxxx</em></strong>" may be used as shorthand for&nbsp;<strong>ORA-600 [<em>xxxx</em>]</strong>.</li> 
       </ul> 
      </blockquote> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

<table style="font-size:12px; table-layout:fixed; color:rgb(51,51,51)"> 
 <tbody> 
  <tr> 
   <td> 
    <div style="overflow:hidden"> 
     <div> 
      <div> 
       <div> 
        <div style="position:static; width:auto; height:auto; margin-left:0px; overflow:visible; margin-right:0px"> 
         <div style="position:relative; width:985px; overflow:hidden"> 
          <div> 
           <div> 
            <span style="font-family:SimSun">&nbsp;</span> 
           </div> 
           <div> 
            <table> 
             <tbody> 
              <tr> 
               <td><span style="font-family:SimSun"><br> </span></td> 
              </tr> 
             </tbody> 
            </table> 
           </div> 
           <div> 
            <table> 
             <tbody> 
              <tr> 
               <td align="left"><span style="font-family:SimSun"><a title="单击此项可添加到收藏夹" href="https://support.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?_afrLoop=192430828711876&amp;id=1288400.1&amp;_afrWindowMode=0&amp;600argver=NULLargend&amp;_adf.ctrl-state=q8fmz6vy5_167#" style="white-space:nowrap; font-size:11px; text-decoration:none" rel="nofollow"><img title="单击此项可添加到收藏夹" alt="单击此项可添加到收藏夹" src="https://support.oracle.com/epmos/common/images/favorites_qualifier_notsel.png" style="border-bottom:medium none; border-left:medium none; display:inline; vertical-align:middle; border-top:medium none; border-right:medium none"></a><span><span></span></span><span></span></span></td> 
               <td><span style="font-family:SimSun"><img alt="" src="/images/20220806/b053115a7fe948b3b10fd8fcb55b1934.png" width="10" height="10"></span></td> 
               <td align="left"><span style="text-align:right; padding:0px 6px 0px 0px; font-size:14px; font-weight:bold"><span style="font-family:SimSun">ORA-7445 [kkqljpmpr] (文档 ID 1288400.1)</span></span></td> 
               <td align="right"><a title="转到底部" href="https://support.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?_afrLoop=192430828711876&amp;id=1288400.1&amp;_afrWindowMode=0&amp;600argver=NULLargend&amp;_adf.ctrl-state=q8fmz6vy5_167#" style="white-space:nowrap; font-size:11px; text-decoration:none" rel="nofollow"><span style="font-family:SimSun"><img title="转到底部" alt="转到底部" src="https://support.oracle.com/epmos/ui/images/quicklink_smlarrowdown_enabled.gif" style="border-bottom:medium none; border-left:medium none; display:inline; vertical-align:middle; border-top:medium none; border-right:medium none"><span style="color:rgb(0,50,134); margin-left:3px">转到底部</span></span></a></td> 
               <td><span style="font-family:SimSun"><img alt="" src="/images/20220806/b053115a7fe948b3b10fd8fcb55b1934.png" width="20" height="10"></span></td> 
              </tr> 
             </tbody> 
            </table> 
           </div> 
           <div> 
            <hr style="border-bottom-color:rgb(255,255,255); border-bottom-style:solid; border-right-width:0px; margin-top:3px; margin-bottom:3px; border-top-color:rgb(173,182,199); border-top-style:solid; border-left-width:0px"> 
           </div> 
          </div> 
         </div> 
        </div> 
       </div> 
      </div> 
     </div> 
    </div> </td> 
  </tr> 
 </tbody> 
</table>

[t.gif]: /images/20220806/b053115a7fe948b3b10fd8fcb55b1934.png