Installing and Configuring HA for Oracle
Overview of the Installation and Configuration Process for HA for Oracle
How to Configure the Oracle Database Access Using Solaris Volume Manager
How to Configure the Oracle Database Access Using Veritas Volume Manager
How to Configure the Oracle Database Access Using Oracle ASM
How to Install the Oracle ASM Software
How to Verify the Oracle ASM Software Installation
Installing the Oracle Software
How to Install the Oracle Software
How to Set the Oracle Kernel Parameters
Verifying the Oracle Installation and Configuration
How to Verify the Oracle Installation
How to Create a Primary Oracle Database
Setting Up Oracle Database Permissions
How to Set Up Oracle Database Permissions
Installing the HA for Oracle Packages
How to Install the HA for Oracle Packages
Registering and Configuring HA for Oracle
Tools for Registering and Configuring HA for Oracle
Setting HA for Oracle Extension Properties
How to Register and Configure HA for Oracle by Using the clsetup Utility
Verifying the HA for Oracle Installation
How to Verify the HA for Oracle Installation
Location of HA for Oracle Log Files
Tuning the HA for Oracle Fault Monitors
Operation of the Oracle Server Fault Monitor
Operation of the Main Fault Monitor
Operation of the Database Client Fault Probe
Operations to Monitor the Partition for Archived Redo Logs
Operations to Determine Whether the Database is Operational
Actions by the Server Fault Monitor in Response to a Database Transaction Failure
Scanning of Logged Alerts by the Server Fault Monitor
Operation of the Oracle Listener Fault Monitor
Obtaining Core Files for Troubleshooting DBMS Timeouts
Customizing the HA for Oracle Server Fault Monitor
Defining Custom Behavior for Errors
Changing the Response to a DBMS Error
Responding to an Error Whose Effects Are Major
Ignoring an Error Whose Effects Are Minor
Changing the Response to Logged Alerts
Changing the Maximum Number of Consecutive Timed-Out Probes
Propagating a Custom Action File to All Nodes in a Cluster
Specifying the Custom Action File That a Server Fault Monitor Should Use
How to Specify the Custom Action File That a Server Fault Monitor Should Use
Upgrading HA for Oracle Resource Types
Upgrading the SUNW.oracle_listener Resource Type
Information for Registering the New Resource Type Version
Information for Migrating Existing Instances of the Resource Type
Upgrading the SUNW.oracle_server Resource Type
Information for Registering the New Resource Type Version
Information for Migrating Existing Instances of the Resource Type
Changing the Role of an Oracle Data Guard Instance
How to Change the Role of an Oracle Data Guard Instance
A. HA for Oracle Extension Properties
B. Preset Actions for DBMS Errors and Logged Alerts
This section contains the information that you need to plan your HA for Oracle installation and configuration.
Note - Unless otherwise stated, instructions and information for Oracle 11g apply to both Oracle 11g release 1 and Oracle 11g release 2.
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. These requirements apply to HA for Oracle only. You must meet these requirements before you proceed with your HA for Oracle installation and configuration. HA for Oracle can be configured to run in non-global zones if required. If you are configuring HA for Oracle to run in a non-global zone, you must use a highly available local file system. You can also configure the HA for Oracle in a zone cluster.
Caution - Raw devices from Oracle Solaris Cluster device groups are not supported in non-global zones. |
For requirements that apply to all data services, see Configuration Guidelines for Oracle Solaris Cluster Data Services in Oracle Solaris Cluster Data Services Planning and Administration Guide.
Oracle application files – These files include Oracle 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 Data Services Planning and Administration Guide for the advantages and disadvantages of placing the Oracle 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. Raw devices from Oracle Solaris Cluster device groups are not supported in non-global zones.
Oracle ASM configuration – Oracle Automatic Storage Management (Oracle ASM) is a new storage option introduced with Oracle database 10g that provides the services of a file system, logical volume manager, and software redundant array of independent disks (RAID) in a platform independent manner. If you are planning to install Oracle ASM, you should choose the appropriate Oracle ASM instance and disk group for your Oracle database installation. There are two types of Oracle ASM instances, single Oracle ASM instance and clustered Oracle ASM instance. See Choosing the Appropriate Oracle ASM Instance for information on choosing the appropriate Oracle ASM instance. For more information on Oracle ASM, see the Oracle documentation corresponding to the Oracle database version you are using.
Note - Single instance Oracle ASM is not supported with Oracle 11g release 2.
If the single instance Oracle database is installed on a node using an Oracle ASM disk group, then certain files are not included within the Oracle ASM disk group and they resided only locally. You should ensure that these files are copied to the other cluster nodes from the node where the single instance Oracle database is created.
If you are using an Oracle 11g release 1 database, you copy the following directories to other cluster nodes:
${ORACLE_BASE}/diag/rdbms/sid
${ORACLE_BASE}/admin
${ORACLE_HOME}/dbs/pfile.ora
If you are using an Oracle 10g database, you copy the following directories to other cluster nodes:
${ORACLE_HOME}/admin
${ORACLE_HOME}/dbs/initsid.org
In the following example, you use the /usr/sfw/sbin/wget command from the target cluster node to recursively copy the ${ORACLE_HOME}/admin directory in Oracle 10g.
# su dbuser cd ORACLE_HOME /usr/sfw/bin/wget -r -nH --Cut-dirs=n ftp://user:password@host:ORACLE_HOME/admin
In the /usr/sfw/sbin/wget command, the -r option is for recursive copy and -nH option is for disabling prefixing of host directories. Specify the --Cut-dirs option to ignore directory components. For the detailed description of options for /usr/sfw/sbin/wget, see wget man page.
Use the questions in this section to plan the installation and configuration of HA for Oracle. Write the answers to these questions in the space that is provided on the data service worksheets in Configuration Worksheets in Oracle Solaris Cluster Data Services Planning and Administration Guide.
What resource groups will you use for network addresses and application resources and the dependencies between them?
What is the logical hostname (for failover services) or shared address (for scalable services) 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 Data Services Planning and Administration Guide for the advantages and disadvantages of placing the Oracle binaries on the local file system rather than the cluster file system.
Does your database setup require standby instances?
If you use the clsetup utility to register and configure HA for Oracle, some of these questions are answered automatically by the utility.
For information about standby databases, see your Oracle documentation.
Are you planning to use Oracle ASM storage?
If you are planning to use Oracle ASM storage, you should decide if you require single instance or clustered instance Oracle ASM. See Choosing the Appropriate Oracle ASM Instance for information on how to choose the appropriate Oracle ASM installation.
For information about standby databases, see your Oracle documentation.