Verifying the HA for Oracle Installation

Perform the following verification tests to make sure that you have correctly installed HA for Oracle.

These sanity checks ensure that all the nodes or zones that run HA for Oracle can start the Oracle Database instance and that the other nodes or zones in the configuration can access the Oracle Database instance. Perform these sanity checks to isolate any problems in starting the Oracle Database software from HA for Oracle.

How to Verify the HA for Oracle Installation

Log in as oracle to the node or zone that currently masters the Oracle resource group.
Set the environment variables ORACLE_SID and ORACLE_HOME.
Confirm that you can start the Oracle Database instance from this node or zone.
Confirm that you can connect to the Oracle Database instance.
Use the sqlplus command with the user/password variable that is defined in the connect_string property.
```
# sqlplus user/passwd@tns_service
```
tns_service

Specifies the network name service provided by the $ORACLE_HOME/network/admin/tnsnames.ora file or the value of the TNS_ADMIN environment variable.
Shut down the Oracle Database instance.
The Oracle Solaris Cluster software restarts the Oracle instance because the Oracle instance is under Oracle Solaris Cluster control.
Switch the resource group that contains the Oracle Database resource to another cluster member.
```
# clresourcegroup switch -n node-zone-list resource-group
```
-n node-zone-list

Specifies a comma-separated, ordered list of zones that can master this resource group. The format of each entry in the list is node:zone. In this format, node specifies the name or ID of a node and zone specifies the name of a non-global Solaris zone. To specify the global zone, or to specify a node without non-global zones, specify only node.
The order in this list determines the order in which the nodes or zones are considered primary during failover. This list is optional. If you omit this list, the global zone of each cluster node can master the resource group.

resource-group

Specifies the name of the resource group that you are switching.
Log in as oracle to the node or zone that now contains the resource group.
Repeat Step 3 and Step 4 to confirm interactions with the Oracle Database instance.

Oracle Clients

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. The network resource is a logical hostname or a shared address. 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.

Location of HA for Oracle Log Files

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.

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.

Skip Navigation Links
Exit Print View
	Oracle Solaris Cluster Data Service for Oracle Guide Oracle Solaris Cluster