ORA-00600: internal error code, arguments: [pfri.c: pfri8: plio mismatch ]錯誤

ORA-00600: internal error code, arguments: [pfri.c: pfri8: plio mismatch ]錯誤[@more@]

ORA-00600: internal error code, arguments: [pfri.c: pfri8: plio mismatch ]錯誤

警告檔案出現錯誤：
Mon Sep 8 17:05:21 2008
Errors in file ********life1_ora_557772.trc:
ORA-00600: internal error code, arguments: [pfri.c: pfri8: plio mismatch ], [], [], [], [], [], [], []
ORA-04061: existing state of package body "********" has been invalidated
ORA-04065: not executed, altered or dropped package body "********"

檔案life1_ora_557772.trc存在：
*** 2008-09-08 17:05:21.836
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [pfri.c: pfri8: plio mismatch ], [], [], [], [], [], [], []
ORA-04061: existing state of package body "********" has been invalidated
ORA-04065: not executed, altered or dropped package body "********"
Current SQL statement for this session:
BEGIN ********.p_export_result(:1,:2); END;
----- PL/SQL Call Stack -----
object line object
handle number name
70000018fccde90 1532 package body ********
70000018fccde90 1786 package body ********
7000001c0505960 1 anonymous block
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst+001c bl ksedst1 1106A24C8 ? 000000001 ?
ksedmp+0290 bl ksedst 1048E00C0 ?
ksfdmp+0018 bl 03F32CB4
kgerinv+00dc bl _ptrgl
kgerin+003c bl kgerinv 000000009 ? 000000009 ?
000000050 ? FFFFFFFFFFF7D68 ?
1106DEF40 ?
pfri8_inst_spec+01a bl kgerin 110190210 ? 110430040 ?
8 104B1BC00 ? 000000000 ?
000000000 ? 700000010008000 ?
00000000A ? 000000000 ?
pfri1_inst_spec+004 bl pfri8_inst_spec 10154F420 ? 000000000 ?
0 000000458 ? 1102243B8 ?
1106DEF40 ?
pfrrun+06c4 bl pfri1_inst_spec 1007B8808 ? 7000001E6A95BD0 ?
FFFFFFFFFFF6A50 ? 1102243B8 ?
110190210 ?
plsql_run+06b4 bl pfrrun 1106DEF40 ?
peicnt+0224 bl plsql_run 1106DEF40 ? 1000110260880 ?
000000000 ?
kkxexe+0250 bl peicnt FFFFFFFFFFF7D68 ? 1106DEF40 ?
opiexe+2e68 bl kkxexe 11053A390 ?
kpoal8+0edc bl opiexe FFFFFFFFFFFB384 ?
FFFFFFFFFFFB108 ?
FFFFFFFFFFF9558 ?
opiodr+0adc bl _ptrgl
ttcpip+1020 bl _ptrgl
opitsk+10b0 bl ttcpip 1100C95D8 ? 1100CD5A8 ?
000000002 ? 11043F998 ?
FFFFFFFFFFFC390 ? 1100CD5A8 ?
100086790 ? 1104959F0 ?
opiino+0990 bl opitsk 0FFFFD3C0 ? 000000000 ?
opiodr+0adc bl _ptrgl
opidrv+0474 bl opiodr 3C1027C6B0 ? 41027DFF0 ?
FFFFFFFFFFFF2C0 ? 01027E418 ?
sou2o+0090 bl opidrv 3C02AB393C ? 4A0716924 ?
FFFFFFFFFFFF2C0 ?
opimai_real+01bc bl 01FA4254
main+0098 bl opimai_real 000000000 ? 000000000 ?
__start+0098 bl main 000000000 ? 000000000 ?

查詢Metalink找到問題：
Bug No. 6643026
Filed 21-NOV-2007 Updated 28-FEB-2008
Product PL/SQL Product Version 10.2.0.3
Platform IBM AIX Based Systems (64-bit) Platform Version No Data
Database Version 10.2.0.3 Affects Platforms Generic
Severity Severe Loss of Service Status Suspended, Req'd Info not Avail
Base Bug N/A Fixed in Product Version No Data

Problem statement:

ORA-00600 [PFRI.C: PFRI8: PLIO MISMATCH], ORA-04061, AND ORA-04065
________________________________________


*** 11/21/07 02:01 am ***
----
.
.
PROBLEM:
--------
Some packages gets invalidated with the following errors:
.
ORA-00600: internal error code, arguments: [pfri.c: pfri8: plio mismatch],
[], [], [],
ORA-04061: existing state of package body "TIA.P1100" has been invalidated
ORA-04065: not executed, altered or dropped package body "TIA.P1100"
.
DIAGNOSTIC ANALYSIS:
--------------------
The issue occurs to few packages intermittently. It is not reproducible at
will.
.
The error trace file shows the following:
.
*********START PLSQL RUNTIME DUMP************
***Got internal error pfri.c: pfri8: plio mismatch while running PLSQL***
PACKAGE BODY TIA.IB02M_121_PL_1:
ibrary unit=7000000f95daff8 line=136 opcode=0 static link=0 scope=1
FP=110408858 PC=7000000eb272b4e Page=0 AP=1103eff60 ST=110408e38
DL0=110b412d0 GF=110b41460 DL1=110b41388 DPF=110b41448 DS=7000000eb2703d0
DON library unit variable list instantiation
------ ------------ ------------- -------------
0 7000000f95daff8 110b41460 110815cd0
1
2
3 70000010e665488 0 1104ac990
4
................
......
***********END PLSQL RUNTIME DUMP************
*** 2007-10-26 11:48:31.626
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [pfri.c: pfri8: plio mismatch ],
[], [], [], [], [], [], []
ORA-04061: existing state of package body "TIA.P1100" has been invalidated
ORA-04065: not executed, altered or dropped package body "TIA.P1100"
.
WORKAROUND:
-----------
There is not workaround for this issue.
.
RELATED BUGS:
-------------
Bug.6354886 (33) ORA-00600 [PFRI.C PLIO MISMATCH ] Gen PLSQL-9208 V9208:
Bug.6116852 (10) ORA-00600 [PFRI.C PLIO MISMATCH ] Gen PLSQL-9208 V9208:
Bug.3578005 (35) ORA-00600 [PFRI.C PFRI8 PLIO MISMATCH ] Gen RDBMS-1010
V1010:
Bug.5843151 (33) ORA-ERROR STACK (00600[PFRI.C PFRI8 PLIO MISMATCH]) Gen
PLSQL-1020 V1020:
Bug.6169013 (93) HRDBA HZ121RW1 OTHER ISSUE Gen HRDBA-1 V1:
.
REPRODUCIBILITY:
----------------
.
TEST CASE:
----------
Can not provide a testcase as the issue occurs intermittently and it is not
reproducible at will.
.
STACK TRACE:
------------
ksedst ksedmp ksfdmp kgerinv kgerin pfri8_inst_spec pfri1_inst_spec pfrrun
plsql_run pricar pricbr prient2 prient kkxrpc kporpc opiodr ttcpip opitsk
opiino opiodr opidrv sou2o opimai_real main start
.
SUPPORTING INFORMATION:
-----------------------
Error trace file in: tiadev2_ora_1101952.zip and tiadev2_ora_815194.zip
.
24 HOUR CONTACT INFORMATION FOR P1 BUGS:
----------------------------------------
.
DIAL-IN INFORMATION:
--------------------
.
IMPACT DATE:
------------
.
*** 11/21/07 02:06 am *** (CHG: Sta->16)
*** 11/21/07 02:06 am ***
*** 11/22/07 10:11 am *** (CHG: Asg->NEW OWNER)
*** 11/22/07 10:11 am ***
*** 11/23/07 04:07 am ***
*** 11/23/07 04:48 am *** (CHG: Sta->10 Asg->NEW OWNER)
*** 11/23/07 04:48 am ***
*** 12/07/07 03:10 am *** (CHG: Sta->16)
*** 12/07/07 03:10 am ***
*** 12/07/07 03:11 am ***
*** 12/07/07 04:27 am ***
*** 12/10/07 04:35 am *** (CHG: Sta->10)
*** 12/10/07 04:35 am ***
*** 02/28/08 05:13 am *** (CHG: Sta->33)
*** 02/28/08 05:13 am ***
.

調查結果：
這個問題的出現是由於所引用的包處於invalidate狀態而觸發，但是根據metalink的介紹這個bug的產生是不規律的，隨機產生的問題。