|Skip Navigation Links|
|Exit Print View|
|Oracle Solaris Cluster Data Service for Oracle Guide Oracle Solaris Cluster 4.0|
Perform the following verification tests to make sure that you have correctly installed HA for Oracle.
These sanity checks ensure that all the nodes that run HA for Oracle can start the Oracle instance and that the other nodes in the configuration can access the Oracle instance. Perform these sanity checks to isolate any problems in starting the Oracle software from HA for Oracle.
Use the sqlplus command with the user/password variable that is defined in the connect_string property.
# sqlplus sysdba/passwd@tns_service
The Oracle Solaris Cluster software restarts the Oracle instance because the Oracle instance is under Oracle Solaris Cluster control.
# clresourcegroup switch -n node-zone-list resource-group
Specifies the name of the resource group that you are switching.
Clients must always refer to the database by using the network resource, not the physical hostname. The network resource is an IP address that can move between physical nodes during failover. The physical hostname is a machine name.
For example, in the tnsnames.ora file, you must specify the network resource as the host on which the database instance is running. See How to Set Up Oracle Database Permissions.
Note - Oracle client-server connections cannot survive a HA for Oracle switchover. The client application must be prepared to handle disconnection and reconnection or recovery as appropriate. A transaction monitor might simplify the application. Further, HA for Oracle node recovery time is application dependent.
Each instance of the HA for Oracle data service maintains log files in subdirectories of the /var/opt/SUNWscor directory.
The /var/opt/SUNWscor/oracle_server directory contains log files for the Oracle server.
The /var/opt/SUNWscor/oracle_listener directory contains log files for the Oracle listener.
The /var/opt/SUNWscor/oracle_asm directory contains log file for Oracle ASM.
These files contain information about actions that the HA for Oracle data service performs. Refer to these files to obtain diagnostic information for troubleshooting your configuration or to monitor the behavior of the HA for Oracle data service.