|
2.762 bytes |
Service Hints & Tips |
Document ID: MCGN-436QZE |
|
This document is provided to IBM and our Business Partners to help sell and/or service IBM products. It is not to be distributed beyond that audience or used for any other purpose. |
Oracle Parallel Server - Oracle client sessions can no longer connect to one of the nodes
Applicable to: World-Wide
Symptom:
Client sessions can no longer connect to one of the nodes in the database, and/or the some rows/tables cannot be accessed from the other nodes. The node to which the client sessions can no longer connect cannot see the shared storage when viewing the drives with the NT Disk Administrator. This node had been up and running OK -- this scenario has occurred without rebooting this node.
Explanation:
A hardware failure may have occurred preventing access to the shared storage on this node. If this has occurred, the database instance on this node may behave in one of three ways:
1) The database instance terminates. This node is evicted from the cluster.
2) The database instance terminates, but not completely. The ORACLE80.EXE process is still running. This node is evicted from the cluster.
3) The database instance does not terminate. This node is not evicted from the cluster.
In all cases, provided the client application is written properly, the clients will failover from the node that can no longer communicate with the shared storage. In the first case, no problems will occur. In the second case, the ORACLE80.EXE process may continue to use up CPU and memory on this node, but the clients should not see a problem. In the third case, the clients will not be able to access certain rows or tables in the database (the ones that they had been working with on the failed node prior to its failure).
Action:
None is required in the first case. In the second and third cases, the OracleServiceOPSn should be stopped with the "net stop" command or the Services applet in the control panel. If this does not work, the ORACLE80.EXE process should be terminated with the NT Task Manager.
|
Search Keywords |
| |
|
Document Category |
Oracle Parallel Server | |
|
Date Created |
14-12-98 | |
|
Last Updated |
15-12-98 | |
|
Revision Date |
| |
|
Brand |
IBM PC Server | |
|
Product Family |
Clustering | |
|
Machine Type |
Various | |
|
Model |
Various | |
|
TypeModel |
| |
|
Retain Tip (if applicable) |
| |
|
Reverse Doclinks |