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:
DSN name from var/odbc/ODBC.ini file.
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 or PostgreSQL source database.
If you have received one-off builds of SharePlex, confirm that those builds are included as fixes in the new release that you are installing. This applies to Linux/Unix only as applicable.
To verify one-offs:
Run the sp-bininfo utility from the util subdirectory of the product directory of your current SharePlex installation.
$ cd path_to_SharePlex_proddir/util
$ ./sp-bininfo
When replicating to an open target (non-Oracle), 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 Linux:
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.
The SharePlex installer on Linux and Unix, as applicable, is a self-extracting installation file with the extension .tpm.
Oracle and Open Target:
There is a separate SharePlex installer build for each supported platform.
SharePlex-release#-build#-platform-chipset.tpm
For Oracle Solaris (Sun), there is a separate SharePlex installer build for each supported operating system version. If the operating system version that you have is not listed, choose the highest number that is below your version.
SharePlex-release#-build#-platform-version-chipset.tpm
The installer creates a temporary target directory, within the current directory, for extraction. This temporary target directory is removed upon installation completion. You can extract the files to a file system that is separate from the SharePlex installation location by using the -t option when running the .tpm file.
Note: The installation file (.tpm) file for the PostgreSQL database is available only for the Linux platform.
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.
Perform the below steps to download the SharePlex patches:
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 when configured for an Oracle or PostgreSQL database running on a Linux or Unix system.
Important!:
|
To upgrade SharePlex in the current product directory:
(If using copy/append) In sp_ctrl on the target systems, stop sp_sync_launcher before applying the SharePlex upgrade.
sp_ctrl> stop launcher
(applicable only for Oracle source) In sp_ctrl on the source system, use the set param command to stop DDL replication by setting the SP_OCT_REPLICATE_ALL_DDL parameter to 0.
sp_ctrl> set param SP_OCT_REPLICATE_ALL_DDL 0
Shut down the SharePlex instance that you are upgrading.
sp_ctrl> shutdown
Note: Before shutting down the SharePlex instance, stop the Capture process if your source database is PostgreSQL with logical replication.
Verify that all SharePlex processes in that SharePlex instance are stopped, and stop any that are still running.
# ps -ef | grep sp_
sp_ctl> stop process
Run the SharePlex installation program.
Prompt | Input |
---|---|
Installation type |
Select the current product directory of the SharePlex installation you are upgrading. |
SharePlex Admin group |
Select the DBA-privileged group to which the SharePlex Administrator user belongs. |
Proceed with upgrade? | Press Enter to confirm the SharePlex environment and proceed with the upgrade. |
License key (do you want to upgrade?) |
Press Enter to accept the default of N (no) to keep the existing license, or enter Y to specify a new license key if required for this upgrade. |
Please specify platform for license key (select a number): |
Please select the appropriate number from the following list of platforms to install the license key: 1) Oracle 2) File
3) JMS 4) Kafka 5) SQL Server 6) Postgres 7) MySQL 8) Snowflake 9) Event Hubs 10) All Platforms q) Quit License Utility Note: To install a trial version of SharePlex, users need to select the All Platforms option. |
License key |
(If Y was selected) Enter the new license key that you received from Quest. |
Note: The installer will upgrade the default variable-data directory that is listed in the default.yaml file, which is located in the data sub-directory of the product directory.
PostgreSQL: pg_setup
Start SharePlex using the following syntax with options as appropriate.
$ cd /productdir/bin
$ ./sp_cop [-uidentifier] &
where:
Note: After upgrading, to bring up your existing setup, activate the same configuration file again if your source is PostgreSQL with logical replication. This will add newly created SharePlex internal tables to the publication used for logical replication before starting the Capture process.
(applicable only for Oracle source) In sp_ctrl on the source system, set the the SP_OCT_REPLICATE_ALL_DDL parameter to 1.
sp_ctrl> set param SP_OCT_REPLICATE_ALL_DDL 1
To upgrade SharePlex to a new product directory:
sp_ctrl> shutdown
You are prompted for the following:
Prompt |
Input |
---|---|
Installation type |
Select <New Installation>. |
Product directory location (path) |
Enter the path to the SharePlex installation directory. If the specified directory does not exist, the installer creates it. If the directory exists, it must be empty. The installer quits if the directory contains prior SharePlex installations or other files. (Applicable only for Oracle source) In a cluster, install on the shared disk. For more information, see Installation and setup for Oracle cluster in the Installation and Setup Guide document. |
Variable data directory location |
Specify an empty directory. The installer creates the specified directory if it does not exist. Important! Do not install this directory into the SharePlex product directory. (Applicable only for Oracle source) In a cluster, install the variable-data directory on the shared disk. For more information, see Installation and setup for Oracle cluster in the Installation and Setup Guide document. |
SharePlex Admin group |
Enter the DBA-privileged group to which the SharePlex Administrator user belongs, which will own the SharePlex binaries. If the default group of the SharePlex Administrator is oinstall, select any option, and make certain this user is listed under oinstall in the etc/group file. For more information, see Installer checklist in the Installation and Setup Guide document. |
TCP/IP port for SharePlex |
Enter the port number to use for SharePlex TCP/IP communications. |
License key (do you have?) |
Press Enter to accept the default of Y (yes). If you do not have a license, enter no. For licensing on a cluster, see Installation and setup for Oracle cluster in the Installation and Setup Guide document. At any point before you run SharePlex you can add the license key with the splex_add_key utility. For more information, see SharePlex license utilities in the Installation and Setup Guide document. |
Please specify platform for license key (select a number): |
Please select the appropriate number from the following list of platforms to install the license key: 1) Oracle 2) File
3) JMS 4) Kafka 5) SQL Server 6) Postgres 7) MySQL 8) Snowflake 9) Event Hubs 10) All Platforms q) Quit License Utility Note: To install a trial version of SharePlex, users need to select the All Platforms option. |
License key |
Enter the license key you received from Quest. |
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center