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 laterInformation 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], [], [], [], [], [], []
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
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';
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.