Skip Headers
Oracle® Database Installation Guide
10g Release 2 (10.2) for hp OpenVMS

Part Number B25414-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

C Oracle RAC: Other Considerations

This appendix discusses troubleshooting and other considerations when using Oracle RAC.

Topics covered in this appendix are:

C.1 Documentation Sources

The information in this Appendix is meant to supplement the detailed information you will find in Oracle Real Application Clusters Administrator's Guide (B10765-02). Refer to this document as necessary when reading through this Appendix.

In addition, you will find important OpenVMS-specific installation and configuration information pertaining to Oracle RAC in Chapter 5, "Installing Oracle RAC" and Chapter 6, "Configuring Oracle RAC".

See Also:

For more information about configuring and using Oracle RAC, refer to the Oracle Real Application Clusters Installation and Configuration Guide

C.2 Troubleshooting the Oracle RAC Installation Process

The following sections contain troubleshooting information to assist you during the installation of Oracle RAC.

See Also:

The Oracle RAC documentation set that is included on the Oracle Database 10g Server Documentation DVD consists of the following documents:

Oracle RAC Management Tools Error Messages are in Oracle Database Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide

C.3 Preconversion Considerations

The following sections describe the considerations for converting from Oracle Database 10g single-instance databases to Oracle RAC databases.

If you are upgrading from Oracle Parallel Server to Oracle RAC or from an earlier version of Oracle RAC, then follow the steps described in Section 1.9, "Upgrade Issues". It is assumed that the original single-instance database and the target Oracle RAC database are of the same version of Oracle Database 10g and running on the same platform.

C.3.1 Prerequisites for Conversion

The system that you are converting to Oracle RAC must meet the following hardware and software requirements:

  • A supported hardware and operating system software configuration

  • An additional license for Oracle Database 10g Enterprise Edition with Oracle RAC

C.3.2 Administrative Considerations

Note the following administrative considerations before conversion:

  • Backup procedures should be available before converting from a single-instance Oracle Database to Oracle RAC.

  • The archive file format requires a thread number. In addition, the archived logs from all instances of a Oracle RAC database are required for media recovery. You must ensure that the disks on which the archive logs are placed are accessible from all nodes on which the cluster database has instances.

C.4 Converting from Single-Instance to Oracle RAC

Oracle recommends that you use Database Configuration Assistant to convert from single-instance Oracle Databases to Oracle RAC. Database Configuration Assistant automates the configuration of the control file attributes, creates the undo tablespaces and the redo logs, and makes the initialization parameter file entries for cluster-enabled environments. It also configures the Oracle Net Services and Oracle Clusterware resources and performs the configuration for Oracle RAC database management for use by Oracle Enterprise Manager or by the SRVCTL utility. This section describes the following scenarios:

C.4.1 Single-Instance Database on a Noncluster Computer to Oracle RAC

To convert from a single-instance Oracle Database that is on a noncluster computer to Oracle RAC, perform the following procedures in the order shown:

  1. Section C.4.1.1, "Backing Up the Original Single-Instance Database"

  2. Section C.4.1.2, "Performing the Preinstallation Steps"

  3. Section C.4.1.3, "Setting Up the Cluster"

  4. Section C.4.1.4, "Copying the Preconfigured Database Image"

  5. Section C.4.1.5, "Installing Oracle Database with Oracle RAC"

C.4.1.1 Backing Up the Original Single-Instance Database

Use Database Configuration Assistant to create a preconfigured image of the single-instance database. To do this, perform the following:

  1. Start Database Configuration Assistant with the DBCA command.

  2. On the Welcome screen, select Manage Templates.

  3. Select Create a database template.

  4. Select the database name from Database Name.

  5. Enter the template name and description and template data file location in Template Name. Use the database name as the default template name.

  6. Click Finish.

Database Configuration Assistant generates two files, a database structure file (template_name.DBC) and a database preconfigured image file (template_name.DFB). These files are generated by default in the ORA_ROOT:[ASSISTANTS.DBCA.TEMPLATES] directory.

C.4.1.2 Performing the Preinstallation Steps

Perform the preinstallation steps as documented in this book. Then, set up shared storage by referring to Section 2.13, "Creating Directories for Oracle Database or Recovery Files".

See Also:

Vendor-specific documentation about storage for information about how to mirror and stripe disks

C.4.1.3 Setting Up the Cluster

If have not already done so, create a cluster with the required number of nodes according to the vendor documentation. Once you have configured all the nodes in the cluster, install Oracle Clusterware by following the procedure in Section 5.9, "Installing Oracle Clusterware".

C.4.1.4 Copying the Preconfigured Database Image

This includes copying the database structure *.DBC file and the database preconfigured image *.DFB file to a temporary location on the node in the cluster from which you plan to run Database Configuration Assistant. These files are created by Database Configuration Assistant. For more information, refer to Section C.4.1.1, "Backing Up the Original Single-Instance Database".

C.4.1.5 Installing Oracle Database with Oracle RAC

Perform the following tasks to install Oracle Database 10g with Oracle RAC:

  1. Run Oracle Universal Installer.

  2. Select Cluster Installation Mode on the Specify Hardware Cluster Installation screen, and select the nodes to include in the Oracle RAC database.

  3. On the Database Configuration Types screen, select the Advanced install type.

    After installing the Oracle software, Oracle Universal Installer runs the postinstallation configuration tools, such as the Oracle Network Configuration Assistant, Database Configuration Assistant, and so on.

  4. On the Database Configuration Assistant Template Selection screen, use the template that you copied to a temporary location in the Section C.4.1.4, "Copying the Preconfigured Database Image" procedure. Use the browse option to select the template location.

  5. After creating the RAC database, Database Configuration Assistant displays the Password Management screen. On this screen, change the passwords for the privileged users with the SYSDBA and SYSOPER roles. Once Database Configuration Assistant exits, the conversion process is complete.

C.4.2 Single-Instance Database on a Cluster to Oracle RAC

There are three scenarios in which a single-instance database can exist on a cluster computer:

  • The Oracle home from which the single-instance database is running is installed on a cluster (Oracle Database 10g with RAC).

  • The Oracle home from which the single-instance database is running is installed on a cluster but the RAC feature is disabled.

  • The Oracle home from which the single-instance database is running is not installed on a cluster.

Use the following procedures to convert the single-instance database on a cluster computer to Oracle RAC for all of these scenarios.

C.4.2.1 Single Instance on a Cluster Running from a Cluster-Enabled Oracle Home

Perform the following tasks to convert a single-instance database on a cluster running from a cluster installed Oracle home.

  1. Use Database Configuration Assistant to create a preconfigured image of the single-instance database as described in Section C.4.1.1, "Backing Up the Original Single-Instance Database". To perform the conversion manually, shut down the single-instance database.

  2. To add nodes to the cluster, add and connect these nodes to the cluster as described in Section C.4.1.2, "Performing the Preinstallation Steps". Ensure that all these nodes can access the shared storage.

  3. From one of the newly added nodes, configure the listeners on the additional nodes using the Oracle Network Configuration Assistant. Select the same port number and protocol that you used on the existing node. If the Oracle Network Configuration Assistant displays the existing node on the Node List screen, then do not select this node because the listener is already configured on it.

  4. Convert the database using one of the following procedures:

C.4.2.2 Automated Conversion

The following steps describe the procedure to automatically convert the database:

  1. If you created the preconfigured image of the single instance database as described in Section C.4.1.1, "Backing Up the Original Single-Instance Database", then use Database Configuration Assistant to complete the conversion to a Oracle RAC database.

  2. Start Database Configuration Assistant from the initial node. Select the names of the nodes that you want to include as part of the cluster database. On the Template Selection screen, select the preconfigured template that you create in Step 0. Enter the database name and respond to the remaining Database Configuration Assistant prompts.

After creating the Oracle RAC database, Database Configuration Assistant displays the Password Management screen. Change the passwords for database privileged users who have SYSDBA and SYSOPER roles. Once Database Configuration Assistant exits, the conversion process is complete.

C.4.2.3 Manual Conversion

Perform the following steps to manually convert the database:

  1. Re-create the control files by running the CREATE CONTROLFILE SQL statement with the REUSE keyword, and specify MAXINSTANCES, MAXLOGFILES, and so on, as needed for the Oracle RAC configuration. The default MAXINSTANCES value is 32 (recommended).

  2. Shut down the database instance.

  3. If the single-instance database was using an SPFILE parameter file, then create a temporary PFILE from the spfile using the following SQL statement:

    CREATE PFILE='pfile_name' FROM SPFILE='spfile_name'
    
    
  4. Set the CLUSTER_DATABASE parameter to TRUE. Set the INSTANCE_NUMBER parameter to a unique value for each instance, using the sid.parameter=value syntax.

    If you optimized memory usage on the single-instance database, adjust the size of the System Global Area (SGA) to avoid swapping and paging when you convert to Oracle RAC. This is because Oracle RAC requires about 350 bytes for each buffer to accommodate the Global Cache Service (GCS). For example, if you have 10,000 buffers, Oracle RAC requires about 350 * 10,000 bytes more memory. Therefore, adjust the size of the SGA by changing the DB_CACHE_SIZE and DB_nK_CACHE_SIZE parameters accordingly.

  5. Start the database instance using the PFILE created in Step 3.

  6. If the single-instance database was using automatic undo management, then create an undo tablespace for each additional instance using the CREATE UNDO TABLESPACE SQL statement.

  7. Create redo threads that have at least two redo logs for each additional instance. Enable the new redo threads by using an ALTER DATABASE SQL statement. Then shut down the database instance.

  8. Copy the Oracle password file from the initial node, or from the node on which you are working, to the corresponding location on the additional nodes on which the cluster database will have an instance. Ensure that you replace the ORACLE_SID name in each password file for each additional instance.

  9. Add REMOTE_LISTENER=LISTENERS_DB_NAME and sid.LOCAL_LISTENER=LISTENER_SID parameters to the PFILE.

  10. Configure the Oracle Net Services entries for the database and instances and address entries for the LOCAL_LISTENER for each instance and REMOTE_LISTENER in the TNSNAMES.ORA file, and copy it to all nodes.

  11. Create the SPFILE from the PFILE as described in Section 6.12.2, "Procedures for Upgrading to the Server Parameter File".

  12. Create the ORA_ROOT:[DBS]INITsid.ora file that contains the following entry:

    spfile='spfile_path_name'
    
    

    where spfile_path_name is the complete path name of the SPFILE.

  13. Add the configuration for the Oracle RAC database and its instance-to-node mapping using the SRVCTL utility.

  14. Start the Oracle RAC database using SRVCTL.

    After starting the database with SRVCTL, the conversion process is complete. For example, you can run the following SQL statement to see the status of each instance in the Oracle RAC database:

    SELECT * FROM v$active_instances
    

C.4.2.4 Single-Instance Database on a Cluster Running from a Oracle RAC-Disabled Oracle Home

This installation is possible if you performed a one-node cluster (with Oracle RA C) installation but later disabled the Oracle RAC feature by unlinking it from the ORACLE binary before creating the single-instance database. However, you can also select the local, noncluster selection on the Node Selection screen to create a single-instance home on a cluster that is not Oracle RAC-enabled.

Perform the following procedures to convert this type of single-instance database to a Oracle RAC database:

  1. On the cluster node where the single-instance database is running, run Step 0 of Section C.4.2.1, "Single Instance on a Cluster Running from a Cluster-Enabled Oracle Home".

  2. Set default to ORA_ROOT:[RDBMS.BIN].

  3. Relink the ORACLE binary as follows:

    • Shut down the database if it is already running.

    • Remove the ORACLE binary by running the following command:

      $ REMORACLE
      
      
    • Create the single-instance Oracle image by running the following command:

      $ @ORA_ROOT:[BIN]RELINK ORACLE
      
      
    • Run the following command:

      $ INSORACLE
      
      
  4. Continue with Step 2.

C.4.2.5 Single-Instance Database on a Cluster Running from a Noncluster-Installed Oracle Home

This installation is only possible if you selected the local installation option on the Specify Hardware Cluster Installation screen during an Oracle Database 10g installation.

To covert this database to a RAC database, perform the procedures described under the following headings:

C.5 Postconversion Steps

After completing the conversion, note the following points as described in the Oracle RAC documentation:

The buffer cache and shared pool capacity requirements in Oracle RAC are slightly greater than those in single-instance Oracle Databases. Therefore, you may want to increase the size of the buffer cache by about 10% and the size of the shared pool by about 15%.

C.6 OpenVMS Directory Structures for Oracle RAC

Table C-1 shows the hierarchical directory tree of a sample database for RAC on OpenVMS-based systems.

Table C-1 Directory Structure for a Sample OpenVMS Environment

Root Level Second Level Third Level Fourth Level
ORACLE_HOME





[.ADMIN]



Administrative directory


[.DB_UNIQUE_NAME]


Database unique name, the same as dbname when the database name is eight or fewer characters in length



[.BDUMP]

[.CDUMP]

[.HDUMP]

[.UDUMP]

Dump destinations for the database server



[.PFILE]

Parameter file for the database server

ORA_CRS_HOME







[.BIN]


Subtree for Oracle binaries


[.LOG]

Subtree for log files for CRS daemons/RACG commands



[.NETWORK]


Subtree for Oracle Net


See Also:

Oracle Database Administrator's Reference for more information about the ORACLE_HOME and admin directories