Setting Up an Oracle RAC Instance for Replication

Set up the Oracle RAC destination instance so that you can perform the replication operation.

Before You Begin

1. Install the Oracle Agent on Windows or UNIX on the auxiliary instance database host. For more information, see Getting Started for Oracle.

2. Add the destination database in the CommCell Console. For more information, see Managing Instances.

Procedure

1. On the destination database instance host, copy the init<SID>.ora file from the source database host to the destination database instance host.

2. The db_name parameter value must be the same value on the source and destination databases. The db_unique_name parameter value can be same or different on the source and destination databases.

3. Compare the value of the db_files parameter that is in the init<SID>.ora file on the source and destination databases. If the value on the source database is greater than the Oracle default value of 200, and it does not match the value in the destination database, then set the db_files parameter on the destination database to the source database value. On the SQL command line, type the following to view the db_files parameter value:

   sql> show parameter db_files;
   

   After you set the parameter, shut down and then restart all of the destination database.

4. To use the TNS connect string instead of "/" to connect the destination instance, create a password file.

   UNIX

   On the command line, go the ORACLE_HOME/dbs directory, and then type the following command:

   orapwd file=orapwSID password= password for sys user 
    entries=Number of user accounts to permit in the file

   Example

   The destination database name is dupdb.

   orapwd file=orapwdupdb password= password for sys user entries=100

   Windows

   On the command line, go the ORACLE_HOME\database directory, and then type the following command:

   orapwd file=PWDSID password= password for sys user 
    entries=Number of user accounts to permit in the file

   Example

   The destination database name is testdb1.

   orapwd file==PWDtestdb1 password= password for sys user entries=100

5. For Windows configurations, create a new Windows service on the destination database host by using the oradim command.

   In the example, the PFILE is "C:\app\admin\product\11.2.0\dbhome_1\database\INIThostdb.ORA".

   C:> oradim -NEW -SID hostdb -STARTMODE manual -PFILE "C:\app\admin\product\11.2.0\dbhome_1\database\INIThostdb.ORA"

6. Add the destination database instance name in the listener.ora and tnsnames.ora files.

7. On the destination database instance host command line, type the command to restart the listener.

   $lsnrctl reload
   

8. On the destination database instance host command line, type the command to put the destination database instance in NOMOUNT mode.

   sql> startup nomount;