Skip Navigation Links | |
Exit Print View | |
Oracle Solaris Cluster Data Service for Oracle Real Application Clusters Guide |
1. Installing Support for Oracle RAC
2. Configuring Storage for Oracle Files
3. Registering and Configuring the Resource Groups
4. Enabling Oracle RAC to Run in a Cluster
Overview of Tasks for Enabling Oracle RAC to Run in a Cluster
Installing Oracle RAC Software
Installing Binary Files and Configuration Files on a Shared File System
Overriding Networking Defaults for Oracle 10g or 11g Oracle Clusterware
Installing Oracle Clusterware on a Subset of Oracle Solaris Cluster Nodes
Creating Node-Specific Files and Directories for a Shared File System
How to Create a Node-Specific Directory for a Shared File System
How to Create a Node-Specific File for a Shared File System
Verifying the Installation of Oracle RAC
How to Verify the Installation of Oracle 10g or 11g RAC
How to Verify the Installation of Oracle 9i RAC
Creating an Oracle ASM Instance and Disk Groups
How to Create an Oracle Oracle ASM Instance and Disk Groups
How to Specify the Location of Data Files on a Shared File System for Oracle 10g or 11g
How to Specify the Location of Data Files on a Shared File System for Oracle 9i
Configuring Resources for Oracle RAC Database Instances
Tools for Registering and Configuring Resources for Oracle RAC Database Instances
How to Automate the Startup and Shutdown of Oracle 9i RAC Database Instances
Verifying the Installation and Configuration of Support for Oracle RAC
How to Verify the Configuration of the RAC Framework Resource Group
How to Verify the Configuration of the Multiple-Owner Volume-Manager Framework Resource Group
How to Verify the Configuration of Storage Resources for Oracle Files
How to Verify the Configuration of Resources for Oracle 10g Release 2 or 11g RAC Database Instances
How to Verify the Configuration of Resources for Oracle 9i RAC Database Instances
How to Verify the Correct Behavior for Shutdown and Booting of the Cluster
5. Administering Support for Oracle RAC
6. Troubleshooting Support for Oracle RAC
7. Modifying an Existing Configuration of Support for Oracle RAC
8. Upgrading Support for Oracle RAC
A. Sample Configurations of This Data Service
B. Preset Actions for DBMS Errors and Logged Alerts
Resources for Oracle RAC database instances enable the database instances to be administered from Oracle Solaris Cluster.
If you are using Oracle 10g release 2 or 11g RAC, these resources also enable Oracle Solaris Cluster and Oracle Clusterware to interoperate.
The software architectures of Oracle 9i, Oracle 10g release 1, and Oracle 10g release 2 or 11g are different. As a result of these differences, the resources for Oracle RAC database instances that Oracle Solaris Cluster requires depend on the version of Oracle that you are using.
Note - If you are using Oracle 10g release 1, omit this task. In Oracle 10g release 1, Oracle Clusterware and Oracle Solaris Cluster cannot interoperate. Instead, Oracle Clusterware start and shut down Oracle RAC database instances.
This section contains the following information about configuring resources for Oracle RAC database instances:
Tools for Registering and Configuring Resources for Oracle RAC Database Instances
How to Automate the Startup and Shutdown of Oracle 9i RAC Database Instances
Oracle Solaris Cluster provides the following tools for registering and configuring resources for Oracle RAC database instances in the global cluster or in a zone cluster:
The clsetup(1CL) utility. For more information, see the following sections:
Oracle Solaris Cluster Manager. For more information, see the Oracle Solaris Cluster Manager online help.
Oracle Solaris Cluster maintenance commands. For more information, see the following sections:
The clsetup utility and Oracle Solaris Cluster Manager each provide a wizard for configuring resources for Oracle RAC database instances. The wizards reduce the possibility of configuration errors that might result from command syntax errors or omissions. These wizards also ensure that all required resources are created and that all required dependencies between resources are set.
When you perform this task, the clsetup utility creates the following resources for interoperation with Oracle 10g Release 2 or 11g:
A Oracle Solaris Cluster resource to act as a proxy for the Oracle RAC database
A Oracle Solaris Cluster resource to represent the Oracle Clusterware framework
Oracle Clusterware resources to represent scalable device groups
Oracle Clusterware resources to represent scalable file-system mount points
Before You Begin
Ensure that the following prerequisites are met:
The RAC framework resource group is created and is online.
Storage resources for Oracle files are configured.
Node-specific files and directories for a shared file system are created.
The Oracle database is running.
To determine whether the Oracle database is running, use the Oracle srvctl command as follows:
$ srvctl status database -d db-name
db-name specifies the name of the Oracle database.
Ensure that you have the following information:
The full path to the Oracle Clusterware home directory
The name of the Oracle RAC database for which you are configuring resources
The full path to the Oracle home directory
The Oracle system identifier (SID) for each instance of the database for which you are configuring resources
The names of all Oracle Solaris Cluster storage resources for Oracle files that you are using
# clsetup
The clsetup main menu is displayed.
The Data Services menu is displayed.
The clsetup utility displays information about Support for Oracle RAC.
The clsetup utility prompts you to select whether you are performing the initial configuration of Support for Oracle RAC or administering an existing configuration.
The clsetup utility prompts you to select the Oracle RAC cluster location. This location can be the global cluster or a zone cluster.
The clsetup utility displays the list of components of Oracle RAC to configure.
The clsetup utility displays the list of prerequisites for performing in this task.
The clsetup utility displays a list of versions of Oracle that you can configure by using this utility.
The clsetup utility displays a list of Oracle Clusterware home directories that exist on the cluster.
The clsetup utility displays a list of names of Oracle RAC databases that are configured on the cluster.
The clsetup utility displays a list of Oracle home directories that exist on the cluster.
The clsetup utility prompts you for the name of the Oracle RACdatabase that you are configuring.
The clsetup utility displays a list of Oracle home directories that exist on the cluster.
The clsetup utility displays a list of Oracle system identifiers that are configured on the cluster. The utility also prompts you to specify the system identifier for the first node in the list of nodes where Oracle RAC is to run.
The clsetup utility prompts you for the Oracle home directory.
The clsetup utility displays a list of Oracle system identifiers that are configured on the cluster. The utility also prompts you to specify the system identifier for the first node in the list of nodes where Oracle RAC is to run.
Perform this step for each node in the list of nodes where Oracle RAC is to run.
Note - You must specify a unique Oracle SID for each node. If you specify a duplicate SID, the clsetup utility warns you that the SID is a duplicate and prompts you to specify the SID again.
The response of the clsetup utility depends on whether you have specified the Oracle SID for all nodes where Oracle RAC is to run.
If you have not specified the Oracle SID for all nodes, the clsetup utility prompts you for the SID of the next node in the node list.
If you have specified the Oracle SID for all nodes, the clsetup utility displays a list of Oracle Solaris Cluster storage resources for Oracle files that are configured. For information about these resources, see Registering and Configuring Storage Resources for Oracle Files.
The clsetup utility prompts you for the SID.
The response of the clsetup utility depends on whether you have specified the Oracle SID for all nodes where Oracle RAC is to run.
If you have not specified the Oracle SID for all nodes, the clsetup utility prompts you for the SID of the next node in the node list.
If you have specified the Oracle SID for all nodes, the clsetup utility displays a list of Oracle Solaris Cluster storage resources for Oracle files that are configured. For information about these resources, see Registering and Configuring Storage Resources for Oracle Files.
The clsetup utility displays the names of the Oracle Solaris Cluster objects that the utility will create.
The clsetup utility displays a screen where you can specify the new name.
The clsetup utility returns you to the list of the names of the Oracle Solaris Cluster objects that the utility will create.
The clsetup utility displays information about the Oracle Solaris Cluster configuration that the utility will create.
The clsetup utility displays a progress message to indicate that the utility is running commands to create the configuration. When configuration is complete, the clsetup utility displays the commands that the utility ran to create the configuration.
The clsetup utility returns you to the list of options for configuring Support for Oracle RAC.
The following table lists the default configuration of Oracle Solaris Cluster resources that the clsetup utility creates when you complete this task.
|
Note - For detailed information for the resource configuration for zone clusters, see the figures in Appendix A, Sample Configurations of This Data Service.
The clsetup utility also creates an Oracle Clusterware resource for each Oracle Solaris Cluster resource for scalable device groups and scalable file-system mount points on which Oracle components depend.
The name of each Oracle Clusterware resource that the clsetup utility creates is as follows:
sun.node.sc-rs
The replaceable items in this name are as follows:
node specifies the name of the node where the Oracle Clusterware resource is to run.
sc-rs specifies the name of the Oracle Solaris Cluster resource that the Oracle Clusterware resource represents. This resource is created when the task in Registering and Configuring Storage Resources for Oracle Files is performed.
The Oracle Clusterware resource for the database instance on node depends on the Oracle Clusterware resource that the clsetup utility creates for that node. Oracle Clusterware resources for database instances are created during the installation and configuration of the Oracle RAC
The name of the Oracle Clusterware resource for the database instance on a node is as follows:
ora.dbname.sid.inst
The replaceable items in this name are as follows:
dbname specifies the database name of the database instance that the Oracle Clusterware resource represents.
sid specifies the Oracle SID of the database instance that the Oracle Clusterware resource represents.
Next Steps
Go to Verifying the Installation and Configuration of Support for Oracle RAC.
Before You Begin
Ensure that the following prerequisites are met:
The RAC framework resource group is created and is online.
Storage resources for Oracle files are configured.
Node-specific files and directories for a shared file system are created.
Ensure that you have the following information:
The full path to the Oracle home directory
The Oracle system identifier (SID) for each instance of the database for which you are configuring resources
The names of all Oracle Solaris Cluster storage resources for Oracle files that you are using
The logical hostnames, or the names of the logical hostname resources, that you are using for Oracle listeners
# clsetup
The clsetup main menu is displayed.
The Data Services menu is displayed.
The clsetup utility displays information about Support for Oracle RAC.
The clsetup utility prompts you to select whether you are performing the initial configuration of Support for Oracle RAC or administering an existing configuration.
The clsetup utility prompts you to choose the global cluster or a zone cluster.
The clsetup utility displays the list of components of Oracle RAC to configure.
The clsetup utility displays the list of prerequisites for performing in this task.
The clsetup utility displays a list of versions of Oracle that you can configure by using this utility.
The clsetup utility displays a list of Oracle home directories that exist on the cluster.
The clsetup utility displays a list of Oracle system identifiers that are configured on the cluster. The utility also prompts you to specify the system identifier for the first node in the list of nodes where Oracle RAC is to run.
The clsetup utility prompts you for the Oracle home directory.
The clsetup utility displays a list of Oracle system identifiers that are configured on the cluster. The utility also prompts you to specify the system identifier for the first node in the list of nodes where Oracle RAC is to run.
The wizard prompts you to perform this step for each node in the list of nodes where Oracle RAC is to run.
Note - You must specify a unique Oracle SID for each node. If you specify a duplicate SID, the clsetup utility warns you that the SID is a duplicate and prompts you to specify the SID again.
The clsetup utility displays the values of properties for the node of the Oracle Solaris Cluster resources that the utility will create.
The clsetup utility prompts you for the SID.
The clsetup utility displays the values of properties for the node of the Oracle Solaris Cluster resources that the utility will create.
The wizard prompts you to perform this step for each node in the list of nodes where Oracle RAC is to run.
The clsetup utility displays a screen where you can specify the new value.
The clsetup utility returns you to the values of properties for the node.
The response of the clsetup utility depends on whether you have specified the Oracle Solaris Cluster resource properties for all nodes where Oracle RAC is to run.
If you have not specified Oracle Solaris Cluster resource properties for all nodes, the clsetup utility prompts you to specify the system identifier for the next node in the list of nodes.
If you have specified the Oracle Solaris Cluster resource properties for all nodes, the clsetup utility displays a list of logical hostname resources that are configured.
The Oracle listener uses the logical hostname resource for a node to connect to the Oracle RAC database instance on the node.
The wizard prompts you to perform this step for each node in the list of nodes where Oracle RAC is to run.
The response of the clsetup utility depends on whether you have configured a logical hostname resource for all nodes where Oracle RAC is to run.
If you have not configured a resource for all nodes, the clsetup utility prompts you to configure a resource for the next node.
If you have configured a resource for all nodes, the clsetup utility displays a list of Oracle Solaris Cluster storage resources for Oracle files that are configured. For information about these resources, see Registering and Configuring Storage Resources for Oracle Files.
The clsetup utility prompts you for the logical hostname that the resource is to make available.
The clsetup utility returns you to the list of logical hostname resources. An entry for the logical hostname resource that the wizard will create is added to the list.
The response of the clsetup utility depends on whether you have configured a logical hostname resource for all nodes where Oracle RAC is to run.
If you have not configured a resource for all nodes, the clsetup utility prompts you to configure a resource for the next node.
If you have configured a resource for all nodes, the clsetup utility displays a list of Oracle Solaris Cluster storage resources for Oracle files that are configured. For information about these resources, see Registering and Configuring Storage Resources for Oracle Files.
The clsetup utility displays the names of the Oracle Solaris Cluster objects that the utility will create.
The clsetup utility displays a screen where you can specify the new name.
The clsetup utility returns you to the list of the names of the Oracle Solaris Cluster objects that the utility will create.
The clsetup utility displays information about the Oracle Solaris Cluster configuration that the utility will create.
The clsetup utility displays a progress message to indicate that the utility is running commands to create the configuration. When configuration is complete, the clsetup utility displays the commands that the utility ran to create the configuration.
The clsetup utility returns you to the list of options for configuring Support for Oracle RAC.
The following table lists the default resource configuration that the clsetup utility creates when you complete this task.
Note - For detailed information for the resource configuration for zone clusters, see the figures in Appendix A, Sample Configurations of This Data Service.
Next Steps
Go to Verifying the Installation and Configuration of Support for Oracle RAC.