Subject: ORACLE TERMINATES WITH FAILURE OF NODE IN A TWO-NODE CLUSTER
New Netfinity server RETAIN Tip:
Record number: H165892
Hit count: UHC00000
Success count: USC0000
Publication code: PC50
Date created: O99/02/10
Date last altered: A99/02/10
Owning B.U.: USA
Abstract: ORACLE TERMINATES WITH FAILURE OF NODE IN A TWO-NODE CLUSTER
Oracle database instance terminates after failure of one node in a two-node cluster.
PROBLEM ISOLATION AIDS:
IBM Netfinity Cluster Enabler Software
This problem has been reported to Oracle, and Oracle Bug number 812552 has been opened.
The fix will be determined by Oracle and is expected to be provided as a new patchset for Oracle V8.0.5.
The problem is related to the load placed on the nodes in the cluster and whether the client programs have a time-out period of less than about 30 minutes.
To avoid the problem, one or both of the following recommendations are made:
The termination of the database on the remaining node is caused by the extra heavy load placed on the remaining node after the first node terminates. Rather than degrading performance gracefully, the Oracle database may periodically pause for up to 20 minutes.
If clients have time-out periods shorter than this pause time, they will time-out.
If those client programs then terminate, the Oracle database must free up the resources (threads) allocated by the Oracle server for those clients.
If many clients terminate all at once, the Oracle database does not free up these resources correctly, and the remaining database instance terminates.
The workarounds address this problem by avoiding the pause condition and/or avoiding the termination of many clients at once.
This problem has not been seen on clusters with a greater number of nodes since the workload of a single failed node tends to be distributed among the multiple remaining nodes.
In this case, the database does not pause and clients do not time-out.
Microsoft, Windows, Windows NT, and the Windows logo are trademarks of Microsoft Corporation in the United States and/or other countries.
Other company, product and service names may be the trademarks or service marks of others.
Please see the LEGAL - Trademark notice.
Feel free - send a for any BUG on this page found - Thank you.