- 论坛徽章:
- 0
|
The information in this article applies to:
Oracle Server - Enterprise Edition - Version: 9.2.0 to 9.2.0
This problem can occur on any platform.
Oracle Database
Symptoms
When starting the second instance of a RAC Cluster, The second node will hang indefinitely until the first node is stopped. Starting the second node first will result in the same behaviour for the first node. In essence, only one node can be brought up.
Changes
This would mostly occur in 9i so change that could trigger the problem is
1) Upgrade to 920
2) Applying the 9202 or 9203 patchset
Cause
If udp_sendspace and udp_recvspace is less than db_block_size * db_file_multiblock_read_count then there is a chance that some cr blocks are not received on the second instance which results in this hang
Fix
Check the udp send and recv parameters
For example on AIX we can get this values using
no -o udp_sendspace
no -o udp_recvspace
On increasing these values the problem does not reproduce.
udp_recvspace = 65536
udp_sendspace = 65536
解决办法:
加大udp_sendspace(用no –o udp_sendspace更改,并加入到rc.net,5L也可以使用¬-p参数使重启后还生效),如果还有问题,请把db_file_multiblock_read_count改小 |
|