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

被折叠的 条评论
为什么被折叠?



