ora-00600 [17182], [0x60000000005A49C8], [], [], [], [], [], []

本文详细分析了Oracle数据库中单节点主服务器关闭时出现的错误日志,指出可能存在内存错误及不同版本Oracle的bug。建议在频繁出现此错误时采取相应措施,但当前仅作为一次偶然现象。通过Metalink查找相关ID34779.1,发现可能原因包括内存问题与特定版本Oracle的已知bug。

environment:
hp unix Release:        B.11.23
Version:        U
Machine:        ia64
oracle 9.2.0.6 rac( two nodes)

When we shutdown the db of master node,alter.log shows:
____________________________________________________
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Fri Aug 27 00:28:10 2010
SHUTDOWN: waiting for detached processes to terminate.
Fri Aug 27 00:28:22 2010
Trace dumping is performing id=[00827002822]
Fri Aug 27 00:30:59 2010
Errors in file /home/oracle/admin/zxin/bdump/zxin1_diag_14713.trc:
ORA-00600: internal error code, arguments: [17182], [0x60000000005A49C8], [], [], [], [], [], []
__________________________________________________

Then,we check file zxin1_diag_14713.trc. It show that followed:
---------------------------------------------------------------------------------
*** SESSION ID:(2.1) 2010-06-13 01:13:37.634
kjzcprt:rcv port created
Node id: 0
List of nodes: 0, 1,
*** 2010-06-13 01:13:37.691
Reconfiguration starts [incarn=0]
I'm the master node
A rcfg proposal from node 1 is received
*** 2010-06-13 01:13:44.549
Reconfiguration completes [incarn=48]
*** 2010-06-13 09:48:11.957
Multi-instance trace dumping is requested by a FG process
Instance is terminating by an unknown process
Performing diagnostic data dump for this instance
Trace dumping is performing id=[cdmp_20100613094811]....
*** 2010-06-13 09:48:36.659
Trace dumping is done
*** 2010-06-13 13:12:48.753
Multi-instance trace dumping is requested by a FG process
Instance is terminating by an unknown process
Performing diagnostic data dump for this instance
Trace dumping is performing id=[cdmp_20100613131248]....
____________________________________________________

through metalink(ID 34779.1),it seem to me that there is memory error.It also shows there is bug in different release of oracle.But except oracle 9.2.0.6.
Now,I suggest is that if this error appears frequently,we must do someting for that,but not now(because It just appear one time).

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

转载于:http://blog.itpub.net/14730395/viewspace-671964/

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值