2010-02-09

ORA-600 [kkxprpic8]

Versiune DB : 9.2.0.8

Symptoms: ORA-600 [kkxprpic8] when executing a query referencing PL/SQL objects. 

This is due to an invalid object being encountered.  Check the underlying trace file generated for any invalid objects and recompile them, e.g. search for "status=INVL", then look above for the object name:

3 comentarii:

  1. Hello. I read your this article after I faced same problem in our dbsystem. But I can't understand to solve this problem. Actually, we also use to call PL/SQL procedure in the system. How to solve this problem?? We didn't meet this problem before...

    RăspundețiȘtergere
    Răspunsuri
    1. Probably you have an invalid object ( procedure, package, function, view ... etc ) in your oracle database .

      You can check for invalid objects with :
      select * from dba_objects where status like '%INV%'

      Ștergere
  2. The metalink note 549637.1 says :
    Applies to:

    Oracle Server - Enterprise Edition - Version: 9.2.0.8 and later [Release: 9.2 and later ]
    Information in this document applies to any platform.
    Symptoms

    ORA-600 [kkxprpic8] error when executing a query referencing PL/SQL objects.
    Cause

    This is due to an invalid object being encountered. Check the underlying trace file generated for any invalid objects and recompile them, e.g. search for "status=INVL", then look above for the object name:

    SO: c000000588c4ed88, type: 51, owner: c00000057550a4d0, flag: INIT/-/-/0x00
    LIBRARY OBJECT LOCK: lock=c000000588c4ed88 handle=c0000005f85d96a0 mode=N
    call pin=c0000005d19f7ec0 session pin=0000000000000000
    htl=c000000588c4edf8[c0000005e751b5b8,c0000005b97a0168] htb=c0000005e751b5b8
    user=c00000057550a4d0 session=c00000057550a4d0 count=1 flags=PNC/[04] savepoint=237
    LIBRARY OBJECT HANDLE: handle=c0000005f85d96a0
    name=EHUBADM.XDI_OA_IM_PKG <----- Object Name
    hash=c7aac018 timestamp=01-17-2008 15:01:20
    namespace=BODY/TYBD flags=KGHP/TIM/SML/[02000000]
    kkkk-dddd-llll=0000-0039-00bf lock=N pin=S latch#=34
    lwt=c0000005f85d96d0[c0000005f85d96d0,c0000005f85d96d0] ltm=c0000005f85d96e0[c0000005f85d96e0,c0000005f85d96e0]
    pwt=c0000005f85d9700[c0000005f85d9700,c0000005f85d9700] ptm=c0000005f85d9790[c0000005f85d9790,c0000005f85d9790]
    ref=c0000005f85d96b0[c0000005f85d96b0, c0000005f85d96b0] lnd=c0000005f85d97a8[c0000005f85d97a8,c0000005f85d97a8]
    LIBRARY OBJECT: object=c0000005ff56b3e0
    type=PKBD flags=EXS/LOC[0005] pflags=NST [01] status=INVL load=0
    DEPENDENCIES: count=92 size=96

    Solution

    Recompile the invalid object.

    RăspundețiȘtergere