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 instance from this node or zone.
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
Shut down the Oracle instance.
The Sun Cluster software restarts the Oracle instance because the Oracle instance is under Sun Cluster control.
Switch the resource group that contains the Oracle database resource to another cluster member.
# clresourcegroup switch -n node-zone-list resource-group
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.
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.