Converting Databases to Oracle RAC Using Oracle Enterprise Manager

You can use Oracle Enterprise Manager Cloud Control to convert a single-instance database to an Oracle RAC database. To use this feature, complete the following steps:

See Also:

Oracle Database Upgrade Guide for information about upgrading existing Oracle Database installations

  1. Log in to Oracle Enterprise Manager Cloud Control. From the Home page, click the Targets tab.

  2. On the Targets page, click the Databases secondary tab, and click the link in the Names column of the database to convert to Oracle RAC.

  3. On the Database Instance Home page, click the Change Database secondary tab.

  4. On the Administration page, in the Database Administration Change Database section, click Convert to Cluster Database.

  5. Log in as the database user SYS with SYSDBA privileges to the database you want to convert, and click Next.

  6. On the Convert to Cluster Database: Cluster Credentials page, provide a user name and password for the oracle user and password of the target database to convert. If the target database is using Oracle ASM, then also provide the SYSASM user and password, and then click Next.

  7. On the Hosts page, select the host nodes in the cluster to be cluster members in the installed Oracle RAC database. When you have completed your selection, click Next.

  8. On the Convert to Database: Options page, select whether you want to use the existing listener and port number, or specify a new listener and port number for the cluster. Also provide a prefix for cluster database instances on the cluster.

    When you have finished entering information, click Next, or click Help if you need assistance in deciding how to enter information.

  9. On the Convert to Cluster Database: Shared Storage page, either select the option to use your existing shared storage area, or select the option to have your database files copied to a new shared storage location. Also, decide if you want to use your existing fast recovery area or copy your recovery files to a new fast recovery area using files managed by Oracle Database.

    If you use Oracle ASM, then Oracle recommends that you place the data files and the recovery files in separate failure groups. A failure group is defined by shared hardware, such as a controller shared between two disks, or two disks that are on the same spindle. If two disks share hardware that could fail, making both disks unavailable, then theses disks are said to be in the same failure group. If you do not use Oracle ASM, then Oracle recommends that the data files and the recovery files are stored in separate locations, for example, separate Oracle ASM failure groups, so that a hardware failure does not affect availability.

    When you have finished entering information, click Next, or click Help if you need assistance in deciding how to enter information.

  10. On the Convert to Cluster Database: Review page, review the options you have selected. Click Submit Job to proceed with the conversion. To change any options you have selected, click Back. To cancel the conversion, click Cancel.

  11. On the Confirmation page, click View Job to check the status of the conversion.