Creating a Replication Agent Instance with a Resource File

Create a Replication Agent for Oracle instance and specify the resource file at the same time.

When you run ra_admin with the -r option, the utility first validates the specified resource file except:

If the Replication Agent for Oracle primary database user login does not exist in the primary data server, the utility creates it, if specified in the resource file (create_pds_username=yes).
If the user login exists in the primary data server but does not have all the required privileges, set create to yes, to have the utility grant all required permissions.
If the resource file specifies to initialize new Replication Agent instance (initialize_instance=yes), then:
- The Replication Agent primary database user login must either exist in the primary data server, or be created by ra_admin (create_pds_username=yes).
- The resource file must specify the instance type for Oracle XStream (instance_type=oraclexs).
- The resource file must specify to start the Replication Agent instance (start_instance=yes).

Otherwise, the utility returns an error message and does not create the instance.

Note: We recommend you to validate a new resource file before you create a Replication Agent instance using the new resource file.

Execute ra_admin, specifying the -r option and the name of the resource file:

ra_admin -r c:/raoxs.rs

where raoxs.rs is the name of the resource file.

Results are returned as one of:

Response-file processing completed.
Response-file processing completed with errors.

If the instance creation is successful, the oraclexs.cfg configuration file is created in $SYBASE/RAX/15_5/config directory. You can begin using the new Replication Agent instance.

The configuration file now includes the XStream specific LogReader and LogAdmin 'ra_log_reader=com.sybase.ra.lr.oracle.xstream.RAOXSLogReader' and 'ra_log_admin=com.sybase.ra.la.oracle.xstream.RAOXSLogAdmin'.