stoperp 发表于 2014-6-24 23:27:57

一则ORA-07445&ORA-00600错误

操作系统： windows 2008
数据库： Oracle10204
RAC+ASm系统
事件：
客户端无法连接，查看实例2数据库日志，报以下错误：
Errors in file c:\oracle\product\10.2.0\admin\veoliadb\udump\veoliadb2_ora_72972.trc:
ORA-00600: internal error code, arguments: , , [], [], [], [], [], []

Fri Jun 20 14:49:10 2014
Trace dumping is performing id=
Fri Jun 20 14:49:20 2014
Errors in file c:\oracle\product\10.2.0\admin\veoliadb\udump\veoliadb2_ora_73152.trc:
ORA-00600: internal error code, arguments: , , [], [], [], [], [], []

Fri Jun 20 14:49:20 2014
Errors in file c:\oracle\product\10.2.0\admin\veoliadb\udump\veoliadb2_ora_73152.trc:
ORA-07445: exception encountered: core dump []
ORA-00600: internal error code, arguments: , , [], [], [], [], [], []

Fri Jun 20 14:49:20 2014
Errors in file c:\oracle\product\10.2.0\admin\veoliadb\udump\veoliadb2_ora_73152.trc:
ORA-07445: exception encountered: core dump []
ORA-00600: internal error code, arguments: , , [], [], [], [], [], []

怀疑是oracle bug导致？请大家帮忙看下

Maclean Liu(刘相兵 发表于 2014-6-25 00:14:41

ORACLE V10.2.0.4.0 - 64bit Production vsnsta=0

ORA-00600: internal error code, arguments: , , [], [], [], [], [], []
kghfre kghfrmrg

  handle    number  name
0000001FEEBA0AF8       152  procedure VEOLIAUSER.CS_SELKG_BIAOKAXXGCSDYN
0000001F44E608F8         1  anonymous block

启用了ASMM +  ASM
KGH

Maclean Liu(刘相兵 发表于 2014-6-25 00:23:50

free of permanently -allocated memory , kghfre

17147+ kghfrmrg 相关的bug较多， 但是从stack call和其他表现看 和Shared pool分配以及SQL解析有关

看下这个库的当时解析情况

stoperp 发表于 2014-6-25 10:56:12

下面是MOS上的回复：
These are internal heap errors, which means a memory corruption has been detected.
In each case it is the same memory address.
This can be cleared by flushing the shared pool or by bouncing the instance.
页: [1]
查看完整版本: 一则ORA-07445&ORA-00600错误