Planning the HA for Oracle Database Installation and Configuration

Language:

This section contains the information that you need to plan your HA for Oracle Database installation and configuration.

For information about supported versions, see Oracle Solaris Cluster 4 Compatibility Guide (http://www.oracle.com/technetwork/server-storage/solaris-cluster/overview/solariscluster4-compatibilityguide-1429037.pdf).

Configuration Requirements

Caution - Your data service configuration might not be supported if you do not adhere to these requirements.

Use the requirements in this section to plan the installation and configuration of HA for Oracle Database software. These requirements apply to HA for Oracle Database only.

You can configure HA for Oracle Database in a global cluster or a zone cluster.

For requirements that apply to all data services, see Configuration Guidelines for Oracle Solaris Cluster Data Services in Oracle Solaris Cluster 4.3 Data Services Planning and Administration Guide.

Oracle Grid Infrastructure software requirements - If you will use Oracle Grid Infrastructure (Oracle ASM and Oracle Clusterware), ensure that the cluster meets Oracle Grid Infrastructure software requirements. See information about Oracle Grid Infrastructure software requirements in the Oracle Grid Infrastructure installation guide for your version of Oracle Grid Infrastructure software.
Oracle application files – These files include Oracle Database binaries, configuration files, and parameter files. You can install these files either on the local file system, the highly available local file system, or on the cluster file system.

See Configuration Guidelines for Oracle Solaris Cluster Data Services in Oracle Solaris Cluster 4.3 Data Services Planning and Administration Guide for the advantages and disadvantages of placing the Oracle Database binaries on the local file system, highly available local file system, and the cluster file system.
Database-related files– These files include the control file, redo logs, and data files. You must install these files on either raw devices or as regular files on the highly available local or cluster file system. For additional information about file systems in a zone cluster, see Adding File Systems to a Zone Cluster in Oracle Solaris Cluster 4.3 Software Installation Guide.
Oracle ASM configuration – Oracle Automatic Storage Management (Oracle ASM) is a storage option that provides the services of a file system, logical volume manager, and software redundant array of independent disks (RAID) in a platform independent manner. For more information on Oracle ASM, see the Oracle Database documentation corresponding to the Oracle Database version you are using.

If the single instance Oracle Database software is installed on an Oracle Solaris Cluster node using an Oracle ASM disk group, then certain files are not included within the Oracle ASM disk group and they reside only locally. Ensure that the following files are copied to the other cluster nodes from the node where the Oracle Database single instance is created:
- ${ORACLE_BASE}/diag/rdbms/sid
- ${ORACLE_BASE}/admin
- ${ORACLE_HOME}/dbs/pfile.ora
After you copy these directories to the cluster nodes, ensure that the copied directories have the same user and group permissions as on the source system.

Configuration Planning Questions

Use the questions in this section to plan the installation and configuration of HA for Oracle Database.

What resource groups will you use for network addresses, Oracle Database application resources, and the dependencies between them?
Do you need the data service configured with Oracle Database application resources for the server, the listener, or both?
What is the logical hostname for clients that will access the data service?
Where will the system configuration files reside?

See Configuration Guidelines for Oracle Solaris Cluster Data Services in Oracle Solaris Cluster 4.3 Data Services Planning and Administration Guide for the advantages and disadvantages of placing the Oracle Database binaries on the local file system rather than the cluster file system.
Does your database setup require standby instances?

For information about standby databases, see your Oracle Database documentation.
Are you planning to use Oracle ASM storage?

For information about standby databases and Oracle ASM storage, see your Oracle Database documentation.

If you use the clsetup utility or the Oracle Solaris Cluster Manager browser interface to register and configure HA for Oracle Database, some of these questions are answered automatically by the tool.