ORA-00600 [kqludp2]-优快云博客

环境: OS Solaris 10. DB version: 9.2.0.8

一直跑得好好的程序，开发人员报执行SP有错误：
ORA-04068: existing state of package has been discarded
ORA-04063: package body "..." has errors
ORA-06508: PL/SQL: could not fine program unit being called
ORA-06512: at line 1

[@more@]

最近也没对数据做什么变动，怎么会报包无效。查下DBA_OBJECTS,发出这个包目前的状态是INVALID,执行utl_recomp.recomp_serial()重新编译一下，再看一下DBA_OBJECTS里的status,竟然还是invalid！查看一下DBA_ERRORS,得到这样的错误信息：
350 PL/SQL: ORA-00600: internal error code, arguments: [kqludp2], [], [], [], [], [], [], []
查看一下第350代码，也没看出什么问题出来。查一下alert,记录了报这个错误时的tracle文件，一大堆看不懂的东西，后来参照文档605027.1，这文档里提到了:
this can occur if the package being compiled references system generated types and some of the system generated objects for this type no longer exist or are invalid. In such cases the trace file generated for the error will show reference to a system generated object, e.g. TEST.SYS_PLSQL_7728_DUMMY_1, and the state object definitions of these objects will be marked as non-existent (flags=NEX) in the trace file.

根据这个查看一下trace文件，里面果然有匹配SYS_PLSQL的:

SO: 3a8a7364, type: 51, owner: 3b18cd8c, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=3a8a7364 handle=40b3ae9c mode=N
call pin=3c9048d0 session pin=0
htl=3a8a73a0[3c91b20c,3c91b20c] htb=3c91b20c
user=3a17f718 session=3a17f718 count=1 flags=[00] savepoint=5151
LIBRARY OBJECT HANDLE: handle=40b3ae9c
name=SCHEMANAME.SYS_PLSQL_45691_DUMMY_2
hash=8821d88d timestamp=NULL
namespace=TABL/PRCD/TYPE flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch#=16
lwt=40b3aeb4[40b3aeb4,40b3aeb4] ltm=40b3aebc[40b3aebc,40b3aebc]
pwt=40b3aecc[40b3aecc,40b3aecc] ptm=40b3af24[40b3af24,40b3af24]
ref=40b3aea4[40b3aea4, 40b3aea4] lnd=40b3af30[40b3af30,40b3af30]
LIBRARY OBJECT: object=40b2a910
flags=NEX[0002] pflags= [00] status=VALD load=0
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 40b2ab18 40b2a9a0 I/-/A 0 NONE
----------------------------------------
....
Cursor 2 (fe96025c): CURBOUND curiob: fe96c844
curflg: 7 curpar: 0 curusr: 0 curses 3c19b6dc
cursor name: select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 a
nd remoteowner is null and linkname is null and subname is null
child pin: 0, child lock: 3a8af3ec, parent lock: 3a8af1f4
xscflg: 20141426, parent handle: 3df96bd0, xscfl2: 5000401
Dumping cursor sharing failures: 0
bhp size: 708/980
bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=fe96cfa0 bln=22 avl=03 flg=05
value=199
bind 1: dty=1 mxl=32(23) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1 size=32 offset=0
bfp=fe96cf74 bln=32 avl=23 flg=05
value="SYS_PLSQL_45691_DUMMY_2"
bind 2: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=08 oacfl2=1 size=24 offset=0
bfp=fe96c004 bln=24 avl=02 flg=05
value=1

但从dba_types里是找不到SYS_PLSQL_45691_DUMMY_2的。这就是产生ORA-600[kqludp2]的原因. 对于产生以SYS_PLSQL开头的对象一般是由自定义TYPE时，可能会产生的，定义Ｐipeline function是会产生。查看一下刚才有问题的那包，里面自定义了一TYPE:TYPE TY_DBCURSOR IS REF CURSOR; 要解决这个错误只能显示的用alter package PackageName compile,用utl_recomp不能让对象valid.

至于具体为什么会产生SYS_PLSQ, 还是没搞明白.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/45188/viewspace-1029195/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/45188/viewspace-1029195/