A single installation of the Replication Agent can support replication from multiple databases, however, one Replication Agent instance is needed for each Oracle database that is to be replicated.
Prepare and create a Replication Agent instance for each Oracle database being replicated.
Primary Database | Install |
---|---|
Oracle 12c | Oracle JDBC thin driver ojdbc7.jar |
Oracle 11g Release 2 | Oracle JDBC thin driver 11.2 for JDK 1.6 Note: Install the
xstreams.jar for Oracle XStream
JDBC driver in the CLASSPATH environment variable.
|
Oracle 10g or 11g Release 1 | Oracle JDBC thin driver for Oracle 10g or 11g and for JDK 1.4 and 1.5 |
Replication Agent may require a newer version of the JDBC driver, which can be found at http://www.oracle.com/technetwork/indexes/downloads/index.html.
setenv CLASSPATH /path_name/driver.jar:$CLASSPATHwhere driver.jar is your JDBC driver (ojdbc14.jar, ojdbc5.jar, ojdbc6.jar, or ojdbc7.jar).
set CLASSPATH=path_name\jdbc\lib\driver.jar;%CLASSPATH%where driver.jar is your JDBC driver (ojdbc14.jar, ojdbc5.jar, ojdbc6.jar, or ojdbc7.jar).
Record the ORACLE_SID value for the instance you want to connect to.
See "Verifying a JDBC Client Installation" in the Oracle JDBC Developer's Guide and Reference Guide.
The timezone.dat binary file is the default file that contains the most commonly used time zones.
The timezlrg.dat binary file contains a larger set of defined time zones.
The Oracle instance uses the timezone file from the ORA_TZFILE environment variable. If ORA_TZFILE is not set, use the default timezone file.
select * from V$TIMEZONE_FILE
The majority of configuration values required to create and initialize a Replication Agent can be recorded and stored in a resource file. Using a resource file provides a means to record or retain the configuration information for a Replication Agent instance, allowing an instance to be removed and re-created.
The resource file template (oracle.rs) is in the Replication Agent directory $SYBASE/RAX-15_5/init (UNIX or Linux) or %SYBASE%\RAX-15_5\init (Windows).
Copy the resource file template $SYBASE/RAX-15_5/init/oracle.rs (UNIX or Linux) or %SYBASE%\RAX-15_5\init\oracle.rs (Windows) to another file that contains the configuration information for a new instance, for example, myra.rs.
Change the values assigned to properties in the resource file so they match the values required for your environment. The majority of these values are the location, user, and password information listed in the tnsname.ora file for the Oracle, Replication Server, and RSSD connections.
Set the value of rs_source_ds to the value you chose for pds when you created a Replication Server connection from the primary database.
Set the value of rs_source_db to the value you chose for pdb when you created a Replication Server connection from the primary database.
The resource file is self-documenting, with each parameter described. See the Replication Agent Administration Guide. For a complete list of configuration parameters, see theReplication Agent Reference Manual.
Parameter |
Description |
Example Values |
---|---|---|
instance name |
Any valid name. |
myra |
admin_port |
Port number that Replication Agent uses. |
9030 (if in use, select a different port number) |
ltm_admin_user |
User name for administering the Replication Agent instance. |
sa |
ltm_admin_pw |
Password for the user administering the Replication Agent instance. |
The default password policy is that the password must be between 6 and 255 characters. |
pds_host_name |
Machine (host) where Oracle is installed. |
jdoe_host1 |
pds_port_number |
Port number for Oracle. |
1521 |
pds_database_name |
$ORACLE_SID |
NYora92 |
pds_username |
User ID that Replication Agent uses to access primary data server. |
RA_USER |
pds_password |
Password for pds_username. |
sybase |
rs_host_name |
Machine where Replication Server is installed. |
jdoe_host1 |
rs_port_number |
Port where Replication Server is installed. |
11752 |
rs_username |
Replication Server user with connect source and create object permissions. This is the user used to create a Replication Server connection from the primary database. |
SAMPLE_RS_ra |
rs_password |
Password for rs_username. |
sa_pass |
rs_charset |
Character set that Replication Server is using. Note:
The value defined for the rs_charset configuration
parameter must match the RS_charset value
in the Replication Server configuration file,
$SYBASE/REP-15_5/install/<server>.cfg (UNIX
or Linux) or %SYBASE%\REP-15_5\install\<server>.cfg (Windows).
|
|
rs_source_ds |
Valid name representing data server of Oracle primary database. This value is used to create a Replication Server connection from the primary database. |
pds |
rs_source_db |
Valid name representing Oracle primary database. This value is used to create a Replication Server connection from the primary database. |
pdb |
rssd_host_name |
Machine where RSSD resides. |
jdoe_host1 |
rssd_port_number |
Port number where RSSD resides. |
11751 |
rssd_database_name |
Database name for RSSD. |
SAMPLE_RS_ERSSD |
rssd_username |
Valid user for RSSD. |
SAMPLE_RS_RSSD_maint |
rssd_password |
Password for rssd_username. |
sa_pass |
pdb_timezone_file |
Path of the Oracle timezone file. |
/software/oracle/Ora10g/oracore/zoneinfo/timezone.dat |
start_instance |
Start the instance that was created. |
yes |
initialize_instance |
Initialize the Replication Agent instance. |
yes |
pdb_include_archives |
Enables or disables the use of Oracle archive log files. |
USE_DEFAULT |
pdb_archive_path |
Identifies directory path where Replication Agent expects to find archived Oracle redo log files. |
A valid directory path on the machine hosting Replication Agent that points to a location where Oracle puts the archived redo log files. |
If any validation fails, the ra_admin utility returns an error message and information about the failure. You can repeat the validation process as many times as necessary until it executes without error. No entities are changed or created.
On Windows:
%SYBASE%\RAX-15_5\bin\ra_admin.bat -r myra.rs
On UNIX or Linux:
$SYBASE/RAX-15_5/bin/ra_admin.sh -r myra.rs
where myra.rs is the path and name of the resource file.