Sun Cluster Data Service for Oracle RAC Guide for Solaris OS

Configuring Resources for Oracle RAC Database Instances

Resources for Oracle RAC database instances enable the database instances to be administered from Sun Cluster.

If you are using Oracle 10g R2 RAC, these resources also enable Sun Cluster and Oracle Cluster Ready Services (CRS) to interoperate.

The software architectures of Oracle 9i, Oracle 10g R1, and Oracle 10g R2 are different. As a result of these differences, the resources for Oracle RAC database instances that Sun Cluster requires depend on the version of Oracle that you are using.


Note –

If you are using Oracle 10g R1, omit this task. In Oracle 10g R1, Oracle CRS and Sun Cluster cannot interoperate. Instead, Oracle CRS start and shut down Oracle RAC database instances.



Note –

You can also use the Oracle 10g R2 RAC Plug-in for Sun N1 Service Provisioning System to deploy Oracle 10g R2 RAC software in a Sun Cluster configuration. Follow instructions in the documentation at http://wikis.sun.com/display/SunCluster/Oracle+RAC+10g+R2+Plug-in.


Tools for Registering and Configuring Resources for Oracle RAC Database Instances

Sun Cluster provides the following tools for registering and configuring resources for Oracle RAC database instances:

The clsetup utility and Sun 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.

ProcedureHow to Enable Sun Cluster and Oracle 10g R2 CRS to Interoperate

When you perform this task, the clsetup utility creates the following resources for interoperation with Oracle 10g R2:

Before You Begin

Ensure that the following prerequisites are met:

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:

  1. On one node of the cluster, become superuser.

  2. Start the clsetup utility.


    # clsetup
    

    The clsetup main menu is displayed.

  3. Type the number that corresponds to the option for data services and press Return.

    The Data Services menu is displayed.

  4. Type the number that corresponds to the option for configuring Sun Cluster Support for Oracle RAC and press Return.

    The clsetup utility displays information about Sun Cluster Support for Oracle RAC.

  5. Press Return to continue.

    The clsetup utility prompts you to select whether you are performing the initial configuration of Sun Cluster Support for Oracle RAC or administering an existing configuration.

  6. Type the number that corresponds to the option for performing the initial configuration of Sun Cluster Support for Oracle RAC and press Return.

    The clsetup utility displays a list of components of Oracle RAC to configure.

  7. Type the number that corresponds to the option for resources for Oracle RAC database instances and press Return.

    The clsetup utility prompts you to select the Oracle RAC clusters location – global cluster or zone cluster.

  8. Type the number that corresponds to the option for the location of the Oracle RAC clusters, and press Return.

    • If you have selected the global cluster option the clsetup utility displays the list of components of Oracle RAC to configure. Go to Step 10.

    • If you have selected the zone cluster option the clsetup utility prompts you to select the required zone cluster. Go to Step 9.

  9. Type the number that corresponds to the option for the required zone cluster, and press Return.

    The clsetup utility displays the list of components of Oracle RAC to configure.

  10. Type the number that corresponds to the option for the component of Oracle RAC, and press Return.

    The clsetup utility displays the list of prerequisites for performing in this task.

  11. Verify that the prerequisites are met, and press Return.

    The clsetup utility displays a list of versions of Oracle that you can configure by using this utility.

  12. Type the number that corresponds to the option for Oracle 10g R2 and press Return.

    The clsetup utility displays a list of Oracle CRS home directories that exist on the cluster.

  13. Specify the Oracle CRS home directory for your installation of the Oracle CRS software.

    • If the directory is listed, type the number that corresponds to the directory that you are selecting and press Return.

      The clsetup utility displays a list of names of Oracle RAC databases that are configured on the cluster.

    • If the directory is not listed, specify the directory explicitly.

      1. Type e and press Return.

        The clsetup utility prompts you for the Oracle CRS home directory.

      2. Type the full path to the Oracle CRS home directory and press Return.

        The clsetup utility displays a list of names of Oracle RAC databases that are configured on the cluster.

  14. Specify the name of the Oracle RAC database that you are configuring.

    • If the name is listed, type the number that corresponds to the name that you are selecting and press Return.

      The clsetup utility displays a list of Oracle home directories that exist on the cluster.

    • If the name is not listed, specify the name explicitly:

      1. Type e and press Return.

        The clsetup utility prompts you for the name of the Oracle RACdatabase that you are configuring.

      2. Type the name of the Oracle RAC database that you are configuring and press Return.

        The clsetup utility displays a list of Oracle home directories that exist on the cluster.

  15. Specify the Oracle home directory for your installation of the Oracle RAC software.

    • If the directory is listed, type the number that corresponds to the directory that you are selecting and press Return.

      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.

    • If the directory is not listed, specify the directory explicitly:

      1. Type e and press Return.

        The clsetup utility prompts you for the Oracle home directory.

      2. Type the full path to the Oracle home directory and press Return.

        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.

  16. Specify the Oracle SID of the Oracle RAC database instance for the node that you are configuring.

    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.


    • If the SID is listed, type the number that corresponds to the SID that you are selecting and press Return.

      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 Sun Cluster storage resources for Oracle files that are configured. For information about these resources, see Registering and Configuring Storage Resources for Oracle Files.

    • If the SID is not listed, specify the SID explicitly.

      1. Type e and press Return.

        The clsetup utility prompts you for the SID.

      2. Type the SID and press Return.

        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 Sun Cluster storage resources for Oracle files that are configured. For information about these resources, see Registering and Configuring Storage Resources for Oracle Files.

  17. Type a comma-separated or space-separated list of the numbers that correspond to the storage resources that you are using, and press Return.

    The clsetup utility displays the names of the Sun Cluster objects that the utility will create.

  18. If you require a different name for any Sun Cluster objects, change each name as follows.

    1. Type the number that corresponds to the name that you are changing and press Return.

      The clsetup utility displays a screen where you can specify the new name.

    2. At the New Value prompt, type the new name and press Return.

    The clsetup utility returns you to the list of the names of the Sun Cluster objects that the utility will create.

  19. To confirm your selection of Sun Cluster object names, press Return.

    The clsetup utility displays information about the Sun Cluster configuration that the utility will create.

  20. To create the configuration, type c and Press Return.

    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.

  21. Press Return to continue.

    The clsetup utility returns you to the list of options for configuring Sun Cluster Support for Oracle RAC.

  22. (Optional) Type q and press Return repeatedly until you quit the clsetup utility.

Resource Configuration

The following table lists the default configuration of Sun Cluster resources that the clsetup utility creates when you complete this task.

Resource Type, Resource Name, and Resource Group 

Dependencies 

Description 

Resource type: SUNW.crs_framework

Resource name: crs_framework-rs

Resource group: rac-framework-rg

Strong dependency on the RAC framework resource. 

Offline-restart dependencies on all scalable device-group resources for Oracle files, if any. 

If you are using a shared file system without a volume manager, this resource has an offline-restart dependency on all scalable file-system mount-point resources for Oracle files. 

If you are not using a shared file system or a volume manager, this resource has no offline-restart dependencies on any other resources. 

Oracle CRS framework resource. 

Resource type: SUNW.scalable_rac_server_proxy

Resource name: rac_server_proxy-rs

Resource group: rac_server_proxy-rg

Strong dependency on the RAC framework resource. 

Offline-restart dependency on the Oracle CRS framework resource. 

Proxy resource for the Oracle RAC database server. 


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 CRS resource for each Sun Cluster resource for scalable device groups and scalable file-system mountpoints on which Oracle components depend.

The name of each Oracle CRS resource that the clsetup utility creates is as follows:

sun.node.sc-rs

The replaceable items in this name are as follows:

The Oracle CRS resource for the database instance on node depends on the Oracle CRS resource that the clsetup utility creates for that node. Oracle CRS resources for database instances are created during the installation and configuration of the Oracle RAC

The name of the Oracle CRS resource for the database instance on a node is as follows:

ora.dbname.sid.inst

The replaceable items in this name are as follows:

Next Steps

Go to Verifying the Installation and Configuration of Sun Cluster Support for Oracle RAC.

ProcedureHow to Automate the Startup and Shutdown of Oracle 9i RAC Database Instances

Before You Begin

Ensure that the following prerequisites are met:

Ensure that you have the following information:

  1. On one node of the cluster, become superuser.

  2. Start the clsetup utility.


    # clsetup
    

    The clsetup main menu is displayed.

  3. Type the number that corresponds to the option for data services and press Return.

    The Data Services menu is displayed.

  4. Type the number that corresponds to the option for configuring Sun Cluster Support for Oracle RAC and press Return.

    The clsetup utility displays information about Sun Cluster Support for Oracle RAC.

  5. Press Return to continue.

    The clsetup utility prompts you to select whether you are performing the initial configuration of Sun Cluster Support for Oracle RAC or administering an existing configuration.

  6. Type the number that corresponds to the option for performing the initial configuration of Sun Cluster Support for Oracle RAC and press Return.

    The clsetup utility displays a list of components of Oracle RAC to configure.

  7. Type the number that corresponds to the option for resources for Oracle RAC database instances and press Return.

    The clsetup utility prompts you to select the Oracle RAC clusters location – global cluster or zone cluster.

  8. Type the number that corresponds to the option for the location of the Oracle RAC clusters, and press Return.

    • If you have selected the global cluster option the clsetup utility displays the list of components of Oracle RAC to configure. Go to Step 10.

    • If you have selected the zone cluster option the clsetup utility prompts you to select the required zone cluster. Go to Step 9.

  9. Type the number that corresponds to the option for the required zone cluster, and press Return.

    The clsetup utility displays the list of components of Oracle RAC to configure.

  10. Type the number that corresponds to the option for the component of Oracle RAC, and press Return.

    The clsetup utility displays the list of prerequisites for performing in this task.

  11. Verify that the prerequisites are met, and press Return.

    The clsetup utility displays a list of versions of Oracle that you can configure by using this utility.

  12. Type the number that corresponds to the option for Oracle 9i and press Return.

  13. Type the number that corresponds to the option to configure both the listener and the server.

    The clsetup utility displays a list of Oracle home directories that exist on the cluster.

  14. Specify the Oracle home directory for your installation of the Oracle RAC software.

    • If the directory is listed, type the number that corresponds to the directory that you are selecting and press Return.

      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.

    • If the directory is not listed, specify the directory explicitly:

      1. Type e and press Return.

        The clsetup utility prompts you for the Oracle home directory.

      2. Type the full path to the Oracle home directory and press Return.

        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.

  15. Specify the Oracle SID of the Oracle RAC database instance for the node that you are configuring.

    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.


    • If the SID is listed, type the number that corresponds to the SID that you are selecting and press Return.

      The clsetup utility displays the values of properties for the node of the Sun Cluster resources that the utility will create.

    • If the SID is not listed, specify the SID explicitly.

      1. Type e and press Return.

        The clsetup utility prompts you for the SID.

      2. Type the SID and press Return.

        The clsetup utility displays the values of properties for the node of the Sun Cluster resources that the utility will create.

  16. If you require a different value for any Sun Cluster resource properties, change each property as follows.

    The wizard prompts you to perform this step for each node in the list of nodes where Oracle RAC is to run.

    1. Type the number that corresponds to the property that you are changing and press Return.

      The clsetup utility displays a screen where you can specify the new value.

    2. At the New Value prompt, type the new value and press Return.

      The clsetup utility returns you to the values of properties for the node.

    3. To confirm your selection of Sun Cluster resource properties, press Return.

      The response of the clsetup utility depends on whether you have specified the Sun Cluster resource properties for all nodes where Oracle RAC is to run.

      • If you have not specified Sun 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 Sun Cluster resource properties for all nodes, the clsetup utility displays a list of logical hostname resources that are configured.

  17. Configure a logical hostname resource for each node where Oracle RAC is to run.

    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.

    • If the logical hostname resource is listed, type the number that corresponds to the resource that you are selecting and press Return.

      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 Sun Cluster storage resources for Oracle files that are configured. For information about these resources, see Registering and Configuring Storage Resources for Oracle Files.

    • If the logical hostname resource is not listed, create the resource as follows:

      1. Type c and press Return.

        The clsetup utility prompts you for the logical hostname that the resource is to make available.

    • Type the logical hostname and press Return.

      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.

    • Type the number that corresponds to the resource that you are creating and press Return.

      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 Sun Cluster storage resources for Oracle files that are configured. For information about these resources, see Registering and Configuring Storage Resources for Oracle Files.

  18. Type a comma-separated or space-separated list of the numbers that correspond to the storage resources that you are using, and press Return.

    The clsetup utility displays the names of the Sun Cluster objects that the utility will create.

  19. If you require a different name for any Sun Cluster objects, change each name as follows.

    1. Type the number that corresponds to the name that you are changing and press Return.

      The clsetup utility displays a screen where you can specify the new name.

    2. At the New Value prompt, type the new name and press Return.

    The clsetup utility returns you to the list of the names of the Sun Cluster objects that the utility will create.

  20. To confirm your selection of Sun Cluster object names, press Return.

    The clsetup utility displays information about the Sun Cluster configuration that the utility will create.

  21. To create the configuration, type c and Press Return.

    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.

  22. Press Return to continue.

    The clsetup utility returns you to the list of options for configuring Sun Cluster Support for Oracle RAC.

  23. (Optional) Type q and press Return repeatedly until you quit the clsetup utility.

Resource Configuration

The following table lists the default resource configuration that the clsetup utility creates when you complete this task.

Resource Type, Resource Name, and Resource Group 

Dependencies 

Description 

Resource type: SUNW.LogicalHostname

Resource name: lh-name, where lh-name is the logical hostname that you specified when you created the resource

Resource group: rac-lhN-rg, where N is an integer in the range 1 to the number of nodes where Oracle RAC is to run. These integers are assigned in the order in which the resource groups are created.

None. 

Logical hostname resource. One logical hostname resource is created for each node where Oracle RAC is to run. 

Resource type: SUNW.scalable_rac_listener

Resource name: rac-listener-rs

Resource group: ora-sid-rg, where ora-sid is the SID on the primary node without any numbers in the SID

Strong dependency on each logical hostname resource. 

Scalable RAC listener resource. 

Resource type: SUNW.scalable_rac_server

Resource name: ora-sid-rs, where ora-sid - is the SID on the primary node without any numbers in the SID

Resource group: ora-sid-rg, where ora-sid is the SID on the primary node without any numbers in the SID

Strong dependency on the RAC framework resource. 

Weak dependency on the scalable RAC listener resource. 

Offline-restart dependencies on all scalable device-group resources for Oracle files, if any. 

Offline-restart dependencies on all scalable file-system mount-point resources for Oracle files. 

If you are not using a shared file system or a volume manager, this resource has no offline-restart dependencies on any other resources. 

Scalable RAC server resource. 


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 Sun Cluster Support for Oracle RAC.