These instructions are for upgrading SharePlex from version 7.6.3 or higher when configured for an Oracle database running on a Linux or Unix system. See also Upgrade on Linux/Unix for Open Target Databases.
Important!:
To run the upgrade
(If using copy/append) In sp_ctrl on the target systems, stop sp_sync_launcher before applying the SharePlex upgrade.
sp_ctrl> stop launcher
(If applicable) 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
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.
Verify that the information shown on the first prompt corresponds to the Oracle version and platform that you are upgrading.
Follow the prompts to supply the following information:
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. |
ORACLE_SID of the database |
Enter the Oracle SID of the database for which you are upgrading SharePlex. |
ORACLE_HOME | Enter the path to the Oracle HOME directory of the selected Oracle SID. |
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. |
License key |
(If Y was selected) Enter the new license key that you received from Quest. |
Customer name | If you added the license key, enter the SiteMessage text string provided by Quest with the license key. |
Run ora_setup for each variable-data directory in the installation of SharePlex that you upgraded. See Oracle Setup (ora_setup).
Start SharePlex using the following syntax with options as appropriate.
$ cd /productdir/bin
$ ./sp_cop [-uidentifier] &
where:
(If applicable) 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
Follow these instructions if you want to upgrade both SharePlex and Oracle at the same time, without reinstantiating the target data.
Recommended procedure - clean the replication environment then upgrade
These steps apply to UNIX.
Shut down sp_cop.
sp_ctrl> shutdown
Run the SharePlex installer with the following options. Refer to Upgrade on Linux/Unix for Oracle Database for full installation instructions.
To keep existing SharePlex product directory path:
To install SharePlex in a new location:
NOTE: A temporary $SP_SYS_VARDIR will be created during installation. Existing SP_SYS_ VARDIR(s) will be upgraded upon starting SharePlex.
Export the SP_SYS_VARDIR environment variable to the variable-data directory that you want to upgrade.
Run the Database Setup (
Start sp_cop.
$ /productdir/bin/sp_cop [-uidentifier] [-s] &
These instructions are for upgrading SharePlex when configured for an Open Target database running on a Linux or Unix system. See also Upgrade on Linux/Unix for Oracle Database.
Important!
To run the upgrade
Log in to the system as the user that will be named as the SharePlex Administrator during this installation. This user will own the installation files and binaries.
Grant executable permissions to the file.
# chmod 555 installation_file
Run the .tpm file. If installing SharePlex in a cluster, run the installer from the primary node (the one to which the shared disk is mounted)
# ./installation_file
You are prompted for the following:
Prompt for: | Input |
---|---|
Installation type |
Select <New Installation>. |
Product directory location (path) |
Enter the path to the existing SharePlex installation directory. |
Variable data directory location |
Enter the name of the existing variable-data directory. |
SharePlex Admin group |
Enter the DBA-privileged group to which the SharePlex Administrator user belongs, which owns the SharePlex binaries. |
TCP/IP port for SharePlex |
Enter the port number of the SharePlex instance you are upgrading. |
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. |
License key |
(If Y was selected) Enter the new license key that you received from Quest. |
Customer name | If you added the license key, enter the SiteMessage text string provided by Quest with the license key. |
The installer displays the location of the install log file and then quits.
Run database setup to upgrade the SharePlex database account.
These instructions are for upgrading from a version of SharePlex that is 7.6.3 or higher.
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
(Source system 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. |
Installation options | Specify the Oracle database version for which you are upgrading SharePlex. |
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 after exiting the installer. |
Re-run database setup:
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy