ORACLE11GRAC alert日志ORA-600 [kqlnrc_1]错误处理

今早检查发现DBRAC库节点1数据库ORA-600 [kqlnrc_1]，经分析发现是通过PL/SQL Developer连上来运行存储过程报错，
其存储过程使用到同义词失效引起！

具体分析过程如下：
1、查看alert日志如下：
Mon Mar 03 11:04:29 2014
Sweep [inc][1992719]: completed
Sweep [inc][1992718]: completed
Sweep [inc2][1992718]: completed
Errors in file /oraclelog/diag/rdbms/dbrac1/dbrac1i1/trace/dbrac1i1_ora_61080830.trc  (incident=1992720):
ORA-00600: internal error code, arguments: [kqlnrc_1], [0x70000113FC52DB8], [], [], [], [], [], [], [], [], [], []
Incident details in: /oraclelog/diag/rdbms/dbrac1/dbrac1i1/incident/incdir_1992720/dbrac1i1_ora_61080830_i1992720.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /oraclelog/diag/rdbms/dbrac1/dbrac1i1/trace/dbrac1i1_ora_61080830.trc  (incident=1992721):
ORA-00600: internal error code, arguments: [kqlnrc_1], [0x70000113FC52DB8], [], [], [], [], [], [], [], [], [], []
Incident details in: /oraclelog/diag/rdbms/dbrac1/dbrac1i1/incident/incdir_1992721/dbrac1i1_ora_61080830_i1992721.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Mon Mar 03 11:04:38 2014
Errors in file /oraclelog/diag/rdbms/dbrac1/dbrac1i1/trace/dbrac1i1_ora_61080830.trc  (incident=1992722):
ORA-00600: internal error code, arguments: [kqlnrc_1], [0x70000113FC52DB8], [], [], [], [], [], [], [], [], [], []
Incident details in: /oraclelog/diag/rdbms/dbrac1/dbrac1i1/incident/incdir_1992722/dbrac1i1_ora_61080830_i1992722.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
 
2、查看trace日志如下：
*** 2014-03-03 11:03:22.426
*** SESSION ID:(7208.55105) 2014-03-03 11:03:22.426
*** CLIENT ID:() 2014-03-03 11:03:22.426
*** SERVICE NAME:(dbrac1) 2014-03-03 11:03:22.426
*** MODULE NAME:(PL/SQL Developer) 2014-03-03 11:03:22.426
*** ACTION NAME:(SQL Window - New) 2014-03-03 11:03:22.426
 
Incident 1992718 created, dump file: /oraclelog/diag/rdbms/dbrac1/dbrac1i1/incident/incdir_1992718/dbrac1i1_ora_61080830_i1992718.trc
ORA-00600: internal error code, arguments: [kqlnrc_1], [0x70000113FC52DB8], [], [], [], [], [], [], [], [], [], []


3、继续分析DUMP文件：
LibraryHandle:  Address=70000113fc52db8 Hash=31dbed4 LockMode=S PinMode=S LoadLockMode=0 Status=INVL 
  ObjectName:  Name=TEST_OWNER.TEST_TAB@DBLNK_TESTDB2   
    FullHashValue=7f26177bcf3fe188cf0fbb3d031dbed4 Namespace=TABLE/PROCEDURE(01) Type=SYNONYM(05) Identifier=0 OwnerIdn=2147483644 
  Statistics:  InvalidationCount=2 ExecutionCount=0 LoadCount=1 ActiveLocks=1 TotalLockCount=5 TotalPinCount=5 
  Counters:  BrokenCount=1 RevocablePointer=1 KeepDependency=0 BucketInUse=19 HandleInUse=19 HandleReferenceCount=0 
  Concurrency:  DependencyMutex=70000113fc52e68(0, 31, 0, 0) Mutex=70000113fc52ee8(7208, 90587, 0, 6) 
  Flags=REM/PIN/TIM/[00022801] 
  WaitersLists:  
    Lock=70000113fc52e48[70000113fc52e48,70000113fc52e48] 
    Pin=70000113fc52e28[70000113fc52e28,70000113fc52e28] 
    LoadLock=70000113fc52ea0[70000113fc52ea0,70000113fc52ea0] 
 通过以上日志我们可以看出由于在library cache中同义词TEST_OWNER.TEST_TAB@DBLNK_TESTDB2无效导致！
 
4、查看TESTDB2库对象状态如下：
SQL> set pagesize 10000 linesize 300
SQL> SELECT object_name,object_type,owner,status
  2             FROM   dba_objects 
  3           WHERE  object_name='TEST_TAB' and owner = 'TEST_OWNER';
 
OBJECT_NAME                 OBJECT_TYPE         OWNER                          STATUS
--------------------------- ------------------- ------------------------------ -------
TEST_TAB             SYNONYM             TEST_OWNER                  VALID
发现同义词状态正常，ORA-600此时在alert日志中没报。
 
综上所述：
如果发现ORA-600错误一直报出，重新编译同义词解决问题！
 
详细见官档：
ORA-600 [kqlnrc_1] (文档 ID 1274843.1)

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

转载于:http://blog.itpub.net/25964700/viewspace-1154268/