How To Find The Object That Causing ORA-600 [kqlnrc_1] (文件 ID 1190673.1)

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 22-Feb-2016***

Goal

How to find the object that are causing an ORA-600 [kqlnrc_1] error.

Stack trace for the error is similar to:

... kqlnrc kgldpo0 kgldpo kglgbo kksaucd kksauc ...

Solution

Execute the following steps:

1. In trace file locate the error with further arguments, e.g.:

     *** 2010-08-16 02:37:13.507
     ksedmp: internal or fatal error
     ORA-00600: internal error code, arguments: [kqlnrc_1], [0x70000029A6C9410], [], [], [], [], [], []

2. Search for the second ORA-600 argument in the trace, in this case is it 70000029A6C9410:

     SO: 7000002ac124020, type: 54, owner: 70000028da74088, flag: INIT/-/-/0x00
     LIBRARY OBJECT PIN: pin=7000002ac124020 handle=70000029a6c9410 mode=S lock=700000290321750
     user=7000002d658fd38 session=7000002d658fd38 count=1 mask=0001 savepoint=0x79 flags=[00]
     ----------------------------------------
     SO: 700000290321750, type: 53, owner: 70000028da74088, flag: INIT/-/-/0x00
     LIBRARY OBJECT LOCK: lock=700000290321750 handle=70000029a6c9410 mode=S
     call pin=7000002ac124020 session pin=0 hpc=0000 hlc=0000
     htl=7000002903217d0[7000002bece2e98,7000002bece2e98] htb=7000002bece2e98 ssga=7000002b209aff0
     user=7000002d658fd38 session=7000002d658fd38 count=1 flags=PNC/[0400] savepoint=0x79
     LIBRARY OBJECT HANDLE: handle=70000029a6c9410 mtx=70000029a6c9540(0) cdp=0
     name=PUBLIC.TEST
     hash=4987a5716aa11b60f3aa1e2633f5d9e6 timestamp=01-07-2006 01:42:13
     namespace=TABL flags=REM/KGHP/TIM/SML/[02020000]
     kkkk-dddd-llll=0000-0001-0001 lock=S pin=S latch#=11 hpc=0dbc hlc=0dbc
     lwt=70000029a6c94b8[70000029a6c94b8,70000029a6c94b8] ltm=70000029a6c94c8[70000029a6c94c8,70000029a6c94c8]
     pwt=70000029a6c9480[70000029a6c9480,70000029a6c9480] ptm=70000029a6c9490[70000029a6c9490,70000029a6c9490]
     ref=70000029a6c94e8[70000029a6c94e8,70000029a6c94e8] lnd=70000029a6c9500[70000029a6c9500,70000029a6c9500]
       LIBRARY OBJECT: object=7000002b05b4a48
       type=SYNM flags=EXS/LOC[0005] pflags=[0000] status=INVL load=0

This shows that object PUBLIC.TEST is invalid in the library cache.

3. Query all objects with name TEST. e.g.:

SQL> SELECT object_name, object_type, owner, status
FROM dba_objects
WHERE object_name='TEST';

OBJECT_NAME    OBJECT_TYPE   OWNER STATUS
-------------- ------------- ---------------- -------
TEST           SYNONYM       PUBLIC           VALID
TEST           FUNCTION      PUB              VALID
TEST           SYNONYM       SCOTT            VALID

4. Recompile the synonym owned by public.

How To Find The Object That Causing ORA-600 [kqlnrc_1] (文件 ID 1190673.1)