Oracle® Solaris Cluster Data Service for Oracle Database Guide

Exit Print View

Updated: September 2014, E39654–02
 
 

How to Verify the HA for Oracle Database Installation

  1. Log in as Oracle Database user oracle to the Oracle Solaris Cluster node that currently masters the Oracle Database resource group.
  2. Set the environment variables ORACLE_SID and ORACLE_HOME.
  3. Confirm that you can start the Oracle Database instance from this cluster node.
  4. 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 sysdba/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.

  5. Shut down the Oracle Database instance.

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

  6. Switch the resource group that contains the Oracle Database resource to another cluster member.
    # clresourcegroup switch -n node-zone-list resource-group
    resource-group

    Specifies the name of the resource group that you are switching.

  7. Log in as oracle to the cluster node that now contains the resource group.
  8. Repeat Step 3 and Step 4 to confirm interactions with the Oracle Database instance.