关于ORA-600 [kgmimio1]

OS:Solaris10

DB:ORA9206

早上查看服务器的alert.log发现如下错误：

Thu Jul 14 17:20:44 2011
Errors in file /oracle/app/admin/china111/udump/china111_ora_1393.trc:
ORA-00600: internal error code, arguments: [kgmimio1], [], [], [], [], [], [], []

Thu Jul 14 17:25:47 2011
Errors in file /oracle/app/admin/china111/udump/china111_ora_18307.trc:
ORA-00600: internal error code, arguments: [kgmimio1], [], [], [], [], [], [], []

。。。。。。

google了下没有找到相应的素材，metalink下找到如下资料：

ORA-600 [kgmimio1] [ID 309990.1]

* Errors in the alert.log file:

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

* Select from table or other fuction fails with ORA-00600 [kgmimio1]

* Call Stack Trace in the trace file shows the following function list:

ksedmp ksfdmp kgerinv kgeasnmierr kgmimio kgmexec evapls

又看了下trace，完全符合描述信息：

----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedmp()+328 CALL ksedst() 00000000B ? 000000000 ?
000000000 ? 00000004A ?
FFFFFFFF7FFF77D8 ?
103312378 ?
kgerinv()+184 PTR_CALL 0000000000000000 00010373C ? 10373C000 ?
10373C968 ? 103741000 ?
000102C00 ? 000000000 ?
kgeasnmierr()+28 CALL kgerinv() 10373CBC8 ? 10385B348 ?
0000013C8 ? 000000000 ?
10373ECD4 ? 10373DF98 ?
kgmimio()+300 CALL kgeasnmierr() 10373CBC8 ? 10385B348 ?
103514278 ? 000000000 ?
788610BF0 ? 000001000 ?
kgmexec()+384 CALL kgmimio() 10373CBC8 ? 000000000 ?

。。。。。。。。。。。。。。

Bug 2522666 was logged for the issue, but it was closed because a test case was not provided.

果然是bug。。。。

下面是解决的方法，restart db 就算了，找业务不繁忙的时候刷新一下shared pool 试试吧。。。
Recompile the failing object (the package) although it does not show 'INVALID' status.
If you have revoked and granted privileges then revert the changes.
If still fails then flush the shared pool or restart the database and check if the problem reproduces.

[@more@]

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

转载于:http://blog.itpub.net/7417660/viewspace-1052503/