ORA-00600: internal error code, arguments: [kglgtboX]


群里网友贴图求助,数据库能正常启动,但是告警日志中出现ORA-00600错误,具体信息如下:




第一张截图可以看出ORA-00600: internal error code, arguments: [kglgtbo1]错误;

第二张截图可以看到libraryhandle等信息,,也可以看到object_name的信息,应该与shared pool有关。


查看MOS:

ORA-600[kglgtbo2] Error Raised While Using Synonyms (文档 ID 744027.1)

IMP-00058: ORACLE Error 600 Importing 9.2.0.6 Export Dump Into 11.2 Database (文档 ID 1535533.1)

DROP SYNONYM Fails With ORA-7445 [Kggmd5process] (文档 ID 1398923.1)



In this Document
  Symptoms
  Cause
  Solution


Platforms: 1-914CU;

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

APPLIES TO:

Oracle Server - Enterprise Edition - Version: 10.2.0.3 and later   [Release: 10.2 and later ]

SYMPTOMS

The following error is seen in the alert log:
   ORA-00600: internal error code, arguments: [kglgtbo2]

The call stack can look like this:
   kglgtbo kgldpo0 kgldpo kgldon pkldon pkloud phnnrl_name_resolve_by_loading ...

The database uses synonyms.

CAUSE

This error is raised due to problems with synonyms.

SOLUTION

Drop and recreate any supporting synonyms.  Do not rely on [re]compile of the synonyms.

If the affected synonym is not apparent, consider the following example:

ORA-00600: internal error code, arguments: [kglgtbo2], [ 0x63E56058], [0x63E56058], [], [], [], [], []

Copy the second argument without "0x" (i.e. copy 63E56058) and search for:

handle=63e56058

inside trace file until locating the occurrence:

SO: 0x72adffb4, type: 53, owner: 0x74785750, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=72adffb4 handle=63e56058 mode=S
call pin=(nil) session pin=(nil) hpc=0000 hlc=0000
htl=0x72ae0000[0x72e8f03c,0x72e8f03c] htb=0x72e8f03c ssga=0x72e8eae8
user=756ee328 session=756ee328 count=1 flags=[0000] savepoint=0x29d5a
LIBRARY OBJECT HANDLE: handle=63e56058 mtx=0x63e5610c(0) cdp=0
name=PUBLIC.ALL_DIRECTORIES 
hash=d5c65282a976df298373adfdd0708e93 timestamp=01-06-2009 13:16:05
namespace=TABL flags=KGHP/TIM/SML/[02000000]
kkkk-dddd-llll=0000-0001-0001 lock=S pin=S latch#=1 hpc=0000 hlc=0000
lwt=0x63e560b4[0x63e560b4,0x63e560b4] ltm=0x63e560bc[0x63e560bc,0x63e560bc]
pwt=0x63e56098[0x63e56098,0x63e56098] ptm=0x63e560a0[0x63e560a0,0x63e560a0]
ref=0x63e560d4[0x63e560d4,0x63e560d4] lnd=0x63e560e0[0x70b83ba0,0x63e56238]
LIBRARY OBJECT: object=6b65b2dc
type=SYNM flags=EXS/LOC[0005] pflags=[0000] status=VALD load=0


From the above you will see the object name and type:
     name=PUBLIC.ALL_DIRECTORIES 
     type=SYNM  (i.e. synonym)

The synonym PUBLIC.ALL_DIRECTORIES should be dropped and recreated.



在网友的截图中,也出现了相关的object_name,type等信息,




需要进一步通过MOS了解。



  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值