Skip Headers
Oracle® Real Application Clusters Installation Guide
11g Release 1 (11.1) for Microsoft Windows

B28251-06
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
PDF · Mobi · ePub

3 Creating Oracle RAC Databases with the Database Configuration Assistant

This chapter describes how to use the Database Configuration Assistant (DBCA) in standalone mode to create and delete Oracle Real Application Clusters (Oracle RAC) databases. The topics in this chapter include:

3.1 Using Database Configuration Assistant with Oracle RAC

DBCA has the following primary database functions:

In addition DBCA has the following primary ASM functions:

See Also:

  • "Creating an Oracle RAC Database with DBCA" for more information about using DBCA in standalone mode

  • Oracle Database Net Services Administrator's Guide to resolve problems—for example, with the listener configuration—and for further information about Lightweight Directory Access Protocol (LDAP)-compliant directory support

3.2 Benefits of Using Database Configuration Assistant

Oracle recommends that you use DBCA to create your Oracle RAC database, because DBCA's preconfigured databases optimize your environment for features such as ASM, the server parameter file, and automatic undo management. DBCA also provides pages to create new ASM disk groups if they are needed; if you use ASM or cluster file system storage, then DBCA also configures recovery and backup disk space.

With DBCA, you can create site-specific tablespaces as part of database creation. If you have data file requirements that differ from those offered by DBCA templates, then create your database with DBCA and modify the data files later. You can also run user-specified scripts as part of your database creation process.

DBCA also configures your Oracle RAC environment for various Oracle high availability features, such as services and cluster administration tools. It also starts any database instances required to support your defined configuration.

3.3 Verifying DBCA Requirements

To help to verify that your system is prepared to create the oracle database with Oracle RAC successfully, enter a cluster verification utility command using the following command syntax:

cluvfy.bat stage -pre dbcfg -n node_list -d oracle_home [-verbose]

In the preceding syntax example, the variable node_list is the list of nodes in your cluster, separated by commas, and the variable oracle_home is the path for the Oracle home under which the database is to be created or its configuration is to be modified.

For example, to perform a check to determine if your system is prepared for an Oracle database with Oracle RAC on a two-node cluster with nodes node1 and node2, and with the Oracle home path c:\oracle\product\11.1.0, enter the following command:

cluvfy.bat stage -pre dbcfg -n node1,node2 -d c:\oracle\product\11.1.0

You can select the option -verbose to receive progress updates as the CVU performs its system checks, and detailed reporting of the test results.

If the CVU summary indicates that the cluster verification check failed, then review and correct the relevant system configuration steps, and run the test again.

The command cluvfy stage -pre dbcfg verifies the following:

Note:

If the user who performed the Oracle RAC installation was not a Windows domain user, then you may need to add the software owner user to the ORA_DBA group on all nodes in the cluster except the one on which the installation was performed.

3.4 Creating an Oracle RAC Database with DBCA

On Windows-based platforms, click Start, and select Programs, Oracle - Oracle_home name, Configuration and Migration Tools, and then Database Configuration Assistant

To create a database with DBCA in standalone mode without ASM or a cluster file system, you must have configured shared storage devices. In addition, you must have run the Oracle Net Configuration Assistant (NETCA) to configure your Oracle Net listener.ora file.

On Windows-based systems, if you plan to use ASM storage, then before you use DBCA to create a database, you must first create logical partitions without primary partitions on the same drive and delete the drive letters for these partitions on all nodes, or stamp these partitions with asmtool.

If you select DBCA templates that use preconfigured data files and if you do not use ASM or a cluster file system, then during database creation, DBCA first verifies that you created shared storage devices for each tablespace. If you have not configured the shared storage devices, then you must configure the devices and replace the default data file names that DBCA provides with the device names on the DBCA Storage page to continue database creation.

To start DBCA, connect as the Administrator to one of your nodes where Oracle RAC is installed and enter the command dbca command from the %ORACLE_HOME%\bin directory.

When you start DBCA, the first page it displays is the Welcome page for Oracle RAC, which includes the option to select an Oracle RAC database. DBCA displays this Oracle RAC Welcome page only if the Oracle home from which it is started was installed on a cluster.

If the Oracle RAC Welcome page opens, then provide information as prompted by DBCA. Click Help if you need assistance.

If DBCA does not display the Welcome page for Oracle RAC, then DBCA was unable to detect if the Oracle home is installed on a cluster. Perform clusterware diagnostics by using the following CVU command syntax:

CRS_home\bin\cluvfy\runcluvfy.bat stage -post crsinst -n nodelist.

For example, if the Oracle Clusterware software is installed in D:\crs and the cluster consists of nodes node1 and node2, run the following command:

D:\crs\bin\cluvfy.bat stage -post crsinst -n node1,node2

Note the following important information when using DBCA:

After you respond to the DBCA prompts, review the Summary dialog information and click OK, DBCA does the following:

Caution:

After you have created the database, if you decide that you want to install additional Oracle Database 10g products in the Oracle Database 11g database you have created, then you must stop all processes running in the Oracle home before you attempt to install the additional products. For the Oracle Universal Installer to relink certain executables and libraries, all database processes must be down. Refer to Appendix B, "Stopping Processes in Oracle Real Application Clusters Databases" for additional information.

3.5 Automatic Listener Migration from Earlier Releases

If your system has an Oracle Database 10g (10. 1) installation, and you install Oracle Database 11g release 1 (11.1) either to coexist with or to upgrade the Oracle Database 10.1 or 10.2 installation, then most installation types automatically migrate the Oracle Database 10.1 listener to the 11g release 1 (11.1) Oracle home. During migration, they configure and start a default Oracle Net listener using the same TCP/IP port as the existing listener, with the IPC key value EXTPROC. This process occurs through one of the following scenarios:

The listener migration process stops the listener in the existing Oracle home, and restarts the listener from the new Oracle home. During migration, client applications may not be able to connect to any databases that are registered to the listener that is being migrated.

3.6 Deleting an Oracle Real Application Clusters Database with DBCA

This section explains how to delete an Oracle RAC database with DBCA. This process deletes a database and removes a database's initialization parameter files, instances, OFA structure, and Oracle network configuration. However, this process does not remove data files if you placed the files on raw devices or on raw partitions.

To delete a database with DBCA:

  1. Start DBCA on one of the nodes:

    On Windows-based platforms, click Start, and select Programs, Oracle - Oracle_home name, Configuration and Migration Tools, then Database Configuration Assistant

    The DBCA Welcome page appears.

  2. Select Oracle Real Application Clusters and click Next.

    After you click Next, DBCA displays the Operations page.

  3. Select Delete a database, click Next. DBCA displays the List of Cluster Databases page.

  4. If your user ID and password are not operating-system authenticated, then the List of Cluster Databases page displays the user name and password fields. If these fields appear, then enter a user ID and password that has SYSDBA privileges.

  5. Select the database to delete and click Finish.

    After you click Finish, DBCA displays a dialog to confirm the database and instances that DBCA is going to delete.

  6. Click OK to begin the deletion of the database and its associated files, services, and environment settings, or click Cancel to stop the operation.

When you click OK, DBCA continues the operation and deletes all of the associated instances for this database. DBCA also removes the parameter files and password files.

At this point, you have accomplished the following: