Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

9

积分

0

好友

3

主题
1#
发表于 2014-6-24 23:27:57 | 查看: 5018| 回复: 3
操作系统: 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: [17147], [0x1EFCE7D000], [], [], [], [], [], []

Fri Jun 20 14:49:10 2014
Trace dumping is performing id=[cdmp_20140620144910]
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: [17112], [0x1EFCE7D000], [], [], [], [], [], []

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 [ACCESS_VIOLATION] [kgscDump+90] [PC:0x5A94424] [ADDR:0x18] [UNABLE_TO_READ] []
ORA-00600: internal error code, arguments: [17112], [0x1EFCE7D000], [], [], [], [], [], []

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 [ACCESS_VIOLATION] [kgscDump+90] [PC:0x5A94424] [ADDR:0x18] [UNABLE_TO_READ] []
ORA-00600: internal error code, arguments: [17112], [0x1EFCE7D000], [], [], [], [], [], []

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

alert&trace.rar

5.93 MB, 下载次数: 701

2#
发表于 2014-6-25 00:14:41
ORACLE V10.2.0.4.0 - 64bit Production vsnsta=0

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

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

启用了ASMM +  ASM
KGH

回复 只看该作者 道具 举报

3#
发表于 2014-6-25 00:23:50
free of permanently -allocated memory , kghfre

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

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

回复 只看该作者 道具 举报

4#
发表于 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.

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-21 02:04 , Processed in 0.082639 second(s), 24 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569