Upgrading the Replication Agent for Oracle from XStream to XStream

To upgrade the Replication Agent for Oracle from 15.7.1 SP120 to version15.7.1 SP200 with XStream APIs Log Reader, use the ra_admin command with the -u option.

Prerequisites

Make sure the primary database version is Oracle11.2.0.3 or later.
Initialize the Replication Agent.
Set the Oracle library path and the XStream JDBC driver in the CLASSPATH environment variable for your platform. See Setting Up the Oracle XStream JDBC Driver.
Shut down the Replication Agent instance and make sure no database operations are running to avoid risking data loss due to missed replication.

Task

To use maximum-strength password encryption, install Java Cryptography Extension (JCE) policy files and reset the system administrator account.

See Installing Java Cryptography Extension (JCE) Unlimited Strength Jurisdiction Policy Files 7 in the Replication Agent Administration Guide.
Set the SYBASE environment variable by changing the SYBASE directory in which Replication Agent is installed.
- For C Shell: source SYBASE.csh
- For Bourne or Korn shell: . SYBASE.sh
- For Windows, run: SYBASE.bat
Change to the Replication Agent bin directory using the command line prompt:
- On UNIX:
```
cd $SYBASE/RAX-15_5/bin
```
- On Windows:
```
cd %SYBASE%\RAX-15_5\bin
```

Upgrade the Replication Agent instances to use Oracle XStream APIs.

Option	Description
Upgrading instances within the same product installation	To upgrade a specific Replication Agent instance in the Replication Agent installation directory, at the command prompt, run: On UNIX: ./ra_admin.sh -u instance=<`instance_name>` On Windows: ra_admin.bat -u instance=<`instance_name`> To upgrade all Replication Agent instances in the Replication Agent installation directory, at the command prompt, run: ./ra_admin.sh -u all ra_admin.bat -u all Note: Because the current version upgrade is not supported, you cannot upgrade the Replication Agent for Oracle 15.7.1 SP200 Log Reader component to use XStream APIs.
Upgrading instances in a separate product installation	To upgrade a specific Replication Agent instance in the specified source instance directory from the current product installation directory, run: On UNIX: ./ra_admin.sh -u `<source_instance_directory>` On Windows: ra_admin.bat -u `<source_instance_directory>` To upgrade all Replication Agent instances in the specified source installation directory from the current product installation directory, at the command prompt, run: ./ra_admin.sh -u `<source_installation_directory>` ra_admin.bat -u `<source_installation_directory>`

Option

Description

Upgrading instances within the same product installation

To upgrade a specific Replication Agent instance in the Replication Agent installation directory, at the command prompt, run:
On UNIX:
```
 ./ra_admin.sh -u instance=<instance_name>
```
On Windows:
```
ra_admin.bat -u instance=<instance_name>
```
To upgrade all Replication Agent instances in the Replication Agent installation directory, at the command prompt, run:
```
./ra_admin.sh -u all 
```
```
ra_admin.bat -u all
```
Note: Because the current version upgrade is not supported, you cannot upgrade the Replication Agent for Oracle 15.7.1 SP200 Log Reader component to use XStream APIs.

Upgrading instances in a separate product installation

To upgrade a specific Replication Agent instance in the specified source instance directory from the current product installation directory, run:
On UNIX:
```
 ./ra_admin.sh -u <source_instance_directory> 
```
On Windows:
```
ra_admin.bat -u <source_instance_directory>
```
To upgrade all Replication Agent instances in the specified source installation directory from the current product installation directory, at the command prompt, run:
```
./ra_admin.sh -u <source_installation_directory>
```
```
ra_admin.bat -u <source_installation_directory>
```

In the commands above:

all – upgrades all instances of Replication Agent within the current product installation directory except the Replication Agent 15.7.1 SP200 instance with the XStream component. The configuration files are backed up before the upgrade. If an error occurs, the upgrade is rolled back.
instance_name – is the name of the Replication Agent instance to be upgraded.

When you enter instance_name, the upgrade is performed directly on the specified instance. The configuration file is backed up before the upgrade for use in error recovery, if required. If an error occurs, the upgrade is rolled back.
source_installation_directory – is the Replication Agent source installation directory.

When you enter the source_installation_directory, all instances of Replication Agent in the specified source installation directory are upgraded from the current product installation directory provided the earlier version of the Replication Agent instance uses XStream component to read from the transaction logs. The instance is first copied to and then updated within the current product installation directory

Start the Replication Agent instance.
On UNIX:
```
$SYBASE/RAX-15_5/<instance>/RUN_<instance>
```
On Windows:
```
%SYBASE%\RAX-15_5\<instance>\RUN_<instance>
```
where instance is the Replication Agent instance name.
Log in to the Replication Agent instance and migrate the metadata by running:
```
ra_migrate
```
This command initiates the upgrade process from an earlier version instance.
(Optional) Execute ra_finalize_upgrade to finalize the upgrade from an earlier version instance.
Resume replication.
```
resume
```
Note: Before resuming replication, wait for the upgrade process to complete. Otherwise, data inserted during upgrade is not replicated.