Verifying the Sun Cluster HA for Oracle Installation

Perform the following verification tests to ensure the Sun Cluster HA for Oracle installation was performed correctly.

The purpose of these sanity checks is to ensure that the Oracle instance can be started by all nodes running Sun Cluster HA for Oracle and can be accessed successfully by the other nodes in the configuration. Perform these sanity checks to isolate any problems starting Oracle from the Sun Cluster HA for Oracle data service.

How to Verify the Sun Cluster HA for Oracle Installation

1. Log in to the node mastering the logical host, and set the Oracle environment variables.

   Log in as oracle to the node that currently masters the logical host, and set the environment variables ORACLE_SID and ORACLE_HOME.

   1. Confirm that you can start the Oracle instance from this host.

   2. Confirm that you can connect to the Oracle instance.

      Log in as root and use the sqlplus command with the tns_service variable defined in the tnsnames.ora file:

      # su - oracle_id -c "echo 'select * from v\$sysstat;' | \ sqlplus user/password@tns_service"

   3. Shut down the Oracle instance.

2. Transfer the logical host containing the Oracle database to another node in the cluster.

   For example:

   # haswitch phys-hahost2 hahost1

3. Log in to the node now mastering the logical host, and repeat the checks listed in Step 1.

   Log in as oracle to the new master node and confirm interactions with the Oracle instance.