群里网友贴图求助,数据库能正常启动,但是告警日志中出现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了解。