This section describes how to upgrade Mirror Replication Agent for Oracle 12.6 or 15.0 to 15.1.
Mirror Replication Agent 15.1 must be installed on the
same host on which the primary Oracle server is running.
To upgrade a log-based Replication version 12.6
or 15.0 to 15.1
For each existing Mirror Replication Agent for Oracle instance, Sybase recommends that you first back up the Mirror Replication Agent System Database (RASD), as described in the Mirror Activator 15.1 Administration Guide. Then, back up the complete existing Mirror Replication Agent instance directory.
Install the Mirror Replication Agent 15.1 software as described in "Installing the Mirror Replication Agent software" in the Mirror Replication Agent 15.1 Installation Guide. Sybase recommends that you install Mirror Replication Agent 15.1 into the same SYBASE directory as the previous version of Mirror Replication Agent.
Download and install the Oracle JDBC driver, and set the CLASSPATH environment variable, as described in the Mirror Replication Agent 15.1 Installation Guide. If the CLASSPATH contains another Oracle JDBC driver, be sure to remove it. Only the Oracle JDBC driver required by Mirror Replication Agent 15.1 should be in the CLASSPATH.
Create the 15.1 version of all valid existing Mirror Replication Agent instances.
This step creates new Mirror Replication Agent 15.1
instances for all valid existing instances of the previous version
of Mirror Replication Agent, regardless of whether the existing
instances are for ASE, Oracle, or Microsoft SQL Server. To complete
the upgrade for Microsoft SQL Server instances, see the appropriate
section in this appendix. If you do not want to run a newly-created
instance on this host, simply delete the new instance directory.
On UNIX, set the SYBASE environment variables by changing directory to the SYBASE directory in which Mirror Replication Agent 15.1 is installed and source the SYBASE script:
For C Shell: source SYBASE.csh
For Bourne or Korn shell: . SYBASE.sh
Change directory to the Mirror Replication Agent 15.1 bin directory:
On UNIX:
cd $SYBASE/MA-15_1/bin
On Windows:
cd %SYBASE%\MA-15_1\bin
Use the ma_admin utility to create new versions of all valid existing instances:
ma_admin -u src_directory
Here, src_directory is the full path name of the previous Mirror Replication Agent version's installation directory. This is the source directory. For example:
ma_admin -u d:\sybase\MA-15_0
For information about the instances that failed to upgrade, refer to the administration logs (…/MA-15_1/admin_logs). After you correct the problem, re-run this command. This command will not upgrade again those Mirror Replication Agent instances that have already been successfully upgraded.
If necessary, set the RA_JAVA_DFLT_CHARSET environment variable in the Mirror Replication Agent 15.1 RUN_instance script to the name of the Java character set that is equivalent to the one being used at the primary database. For detailed information, see the Mirror Activator 15.1 Administration Guide.
In the primary Oracle database, grant the previously existing pds_username user any additional required privileges. See “Mirror Replication Agent permissions”.
To prevent any loss of replicated data, deny users (other than the previously existing Mirror Replication Agent pds_username user) any further access to the primary Oracle instance.
Log in to the previously existing Mirror Replication Agent instance, verify that it is in Replicating state, and allow replication to finish. To verify that replication has completed:
Periodically issue the ra_statistics command, watching until all of the following statistics are zero (0):
Operation queue size
Operation data hash size
Input queue size
Output queue size
When all of these values are zero, note the Last QID Sent from the last set of statistics.
Issue the ra_locator update command so that Mirror Replication Agent retrieves the truncation point from Replication Server.
Wait, then issue the ra_locator command again and compare the displayed locator with that of the Last QID Sent. If they are different, wait and repeat this step.
Quiesce the Mirror Replication Agent instance by issuing the quiesce command.
Shut down the Replication instance by issuing the shutdown command.
Start and log in to the Mirror Replication Agent 15.1 instance and migrate the Mirror Replication Agent metadata by issuing the ra_migrate command.
Allow all users to access the primary Oracle.
Log in to the RSSD, and set the Replication Server locator to zero:
rs_zeroltm source_ds, source_db
Here, source_ds matches the previous Mirror Replication Agent instance values for rs_source_ds, and source_db matches the previous Mirror Replication Agent instance values for rs_source_db.
This step is required because the format of the QID
has changed in version 15.1, requiring the previous value held by
Replication Server be replaced. The rs_source_ds and rs_source_db values
were migrated from the previous version of Mirror Replication Agent and
do not need to be changed.
In the Mirror Replication Agent 15.1 instance, do the following:
If you want to have automatic archiving turned off, set pdb_include_archives to false. If you want to have automatic archiving turned on, set pdb_include_archives to true, set pdb_archive_path to the directory containing the archive logs, and set pdb_archive_remove to false. For more information, see “Redo and archive log setup”. Do this prior to resuming replication.
Resume replication by issuing the resume command.
