Chat now with support
Chat with Support

SharePlex 11.4 - Upgrade Guide

Upgrade on Linux/Unix for Open Target Databases

These instructions are for upgrading SharePlex when configured for an open target database running on a Linux or Unix system.

Important!
  • If you are upgrading some SharePlex installations in a configuration, but not others, view the SharePlex Release Notes for interoperability support between versions.
  • Perform the upgrade on all Linux machines that host open targets involved in SharePlex replication.
  • See Before you Upgrade for any pre-installation items that apply to your SharePlex installation.

Pre-requisite for Snowflake database setup:

If any user has used Snowflake setup utility of a version prior to 11.4, they should first perform the following cleanup steps:

  1. Drop the role 'SHAREPLEX_ROLE' from the Snowflake account using the owner role. For example, if 'SHAREPLEX_ROLE' was created with a user having the 'ACCOUNTADMIN' role, execute the following query using the same privileges:

    drop role "SHAREPLEX_ROLE";

  2. Drop the table 'SHAREPLEX_OPEN_TRANS' from the target DB.SCHEMA. Refer to the query below:

    drop table SHAREPLEX_OPEN_TRANS;

    Re-run the Snowflake setup utility now, following the guidelines below. 'SHAREPLEX_ROLE' will be re-created correctly by the setup using the 'USERADMIN' role."

To run the upgrade:

  1. 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.

  2. (Reinstallations) If sp_cop is running, shut it down.
  3. Copy the installation file to a temporary directory where you have write permissions.
  4. Grant executable permissions to the file.

    # chmod 555 installation_file

  5. 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

  6. 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.

    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.

    The installer displays the location of the install log file and then quits.

  7. Run the appropriate Database Setup utility for your database to upgrade the SharePlex database account. See SharePlex Utilities

  8. Repeat all of the installation procedures for all Unix and Linux machines that host an Open Target database.

Verify Partition Schemes

If you are upgrading from a SharePlex version earlier than 9.0, the method of creating and storing partition schemes and row partitions for horizontal partitioning has changed. This information no longer is stored in the database.

When you run database setup during an upgrade, it converts the data from the SHAREPLEX_PARTITION table to the new internal storage format. After the conversion, you can view the partitions with the view partitions command in sp_ctrl to ensure that the partitions converted properly.

Note: For more information about the view partitions command, see theSharePlex Reference Guide.

To view row partitions:

  1. Run sp_ctrl on the source system.
  2. Issue the following command with either option, depending on whether you want to view all partitions or just those for a particular partition scheme.

    sp_ctrl> view partitions for {scheme_name | all}

The following is an example of converted partition schemes. Note that the conversion program populates the Name field with the name of the queue from the Route column.

Scheme        Name           Route                            Hash     Condition
-----------   -------------  ------------------------------   ------   ---------------
HASH4         hash           sys02:hash|#@o.ora112            4        ROWID
TEST_CT       highvalues     sys02:highvalues@o.ora112                 sales>=10000
TEST_CT       lowvalues      sys02:lowvalues@o.ora112                  sales<10000
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating