This guide contains instructions for upgrading SharePlex environment. It is intended for administrators, consultants, analysts, and any other IT professionals tasked with upgrading SharePlex™.
For the complete SharePlex documentation set, go to https://support.quest.com/shareplex/technical-documents.
You can download, view and save this document in Adobe PDF format. Click Download in the upper right-hand corner of this page. This action downloads the entire publication.
This section contains important information that you need to know before you select a SharePlex installer and begin the upgrade procedure.
You will need the following information about the installation that you want to upgrade:
If you are upgrading some SharePlex installations in a configuration, but not others, view the SharePlex Release Notes for interoperability support between versions. Parameter settings may be required.
Some steps in the upgrade procedures require the Administrator authorization level, which normally is only granted to the person or persons designated as the SharePlex Administrators. An upgrade can only be performed by a person who has this authorization and is familiar with SharePlex.
These requirements apply to SharePlex when it captures from an Oracle source database.
When replicating to an Open Target target (non-Oracle target), SharePlex supports replication from any Oracle Unicode character set and the US7ASCII character set. SharePlex posts data to Open Target in the Unicode character set, and therefore if the source data is Unicode or US7ASCII, no conversion on the target is required.
However, if the following are true, conversion is required on the target:
To perform conversion with an Oracle client on Windows
To apply Unicode and US7ASCII data without conversion
If the source data is Unicode or US7ASCII and you are not replicating LOB data, no conversion or Oracle client is needed. Set the SP_OPX_NLS_CONVERSION parameter to 0 to disable conversion, and then restart Post if it is running.
There are different installers for SharePlex based on the type of operating system. This topic helps you understand the differences and the naming conventions used.
On Windows, the SharePlex installer is named sp_setup_version.exe. It is a bundle that contains SharePlex binaries for all of the supported databases and versions.
The installer installs the following items:
Do not remove or modify any of these components while SharePlex is in production, including SharePlex Installer. These components all support SharePlex operation or upgrade.
Download the SharePlex installation package that matches the operating system you are using.
Additionally, download any SharePlex patches, so that you can install them after you install the base software.
Go to the Quest Software Support page: http://support.quest.com/
Click Download Software.
Click the arrow in the Download column for the version you need. You can also click the file name for access to more information and to download the file(s).
You are ready to begin the installation process. Be sure to thoroughly read the version specific Release Notes prior to running the installer.
These instructions are for upgrading SharePlex on the Windows platform.
Important!
Do not uninstall SharePlex or the MKS Toolkit® environment before upgrading. Install the upgrade over the existing version.
To run the upgrade
(If using copy/append) Stop sp_sync_launcher on the target systems before applying the SharePlex upgrade.
sp_ctrl> stop launcher
(Oracle as source only) In sp_ctrl, use the set param command to stop DDL replication (if active) by setting the SP_OCT_REPLICATE_ALL_DDL parameter to 0.
sp_ctrl>set param SP_OCT_REPLICATE_ALL_DDL 0
Important! Keep the setting at 0 until prompted otherwise.
Stop the SharePlex service:
Run the sp_setup installation program and follow the prompts:
Prompt | Input |
---|---|
Destination Folder |
Install the upgrade into the existing SharePlex product directory. |
Port number |
Select the port that this instance of SharePlex currently uses. |
Variable Data directory |
Specify the existing SharePlex variable-data directory. |
Program Manager group |
Specify the existing Programs menu location. |
MKS Platform Components |
Appears if this version of SharePlex contains a new version of MKS Toolkit®. Accept the default Program Files location. If prompted to restart your system, you can postpone the restart until after you finish this installation. |
Confirm installation | Confirm the installation information. |
SharePlex license |
Accept the existing license shown or enter a new one if applicable. |
Finish |
If you were prompted to restart the system after you installed the MKS Toolkit files, you may do so at any time after exiting the installer. |
Run the appropriate Database Setup utility:
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center