Sun Cluster Data Service for Oracle Guide for Solaris OS

How to Verify the Sun Cluster HA for Oracle Installation

  1. Log in as oracle to the node that currently masters the Oracle resource group.

  2. Set the environment variables ORACLE_SID and ORACLE_HOME.

  3. Confirm that you can start the Oracle instance from this node.

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

    Use the sqlplus command with the user/password variable that is defined in the connect_string property.

    # sqlplus user/passwd@tns_service
  5. Shut down the Oracle instance.

    The Sun Cluster software restarts the Oracle instance because the Oracle instance is under Sun Cluster control.

  6. Switch the resource group that contains the Oracle database resource to another cluster member.

    The following example shows how to complete this step.

    # scswitch -z -g resource-group -h node 
  7. Log in as oracle to the node that now contains the resource group.

  8. Repeat Step 3 and Step 4 to confirm interactions with the Oracle instance.