Chat now with support
Chat with Support

SharePlex 9.2.5 - Reference Guide

About this guide Conventions used in this guide SharePlex commands SharePlex parameters General SharePlex utilities Database Setup utilities SharePlex environment variables

ora_cleansp

Description

Use the ora_cleansp utility to remove the current replication state on a system, including deactivating configurations.

Caution:

  • Running ora_cleansp can be acceptable in a test or demonstration environment, but it rarely is appropriate in a production environment. The effects of the cleanup are not reversible.
  • If the SharePlex instance for which you are running ora_cleansp is configured to capture from or post to multiple databases, ora_cleansp will remove the replication configuration and supporting data for all of those databases.

Supported databases

Oracle on Unix, Linux, and Windows

Other alternatives to ora_cleansp

Before running ora_cleansp, consider the following alternatives:

  • To stop activity for a configuration without restoring replication to an initial state, you might be able to use the abort config or purge config command in sp_ctrl.
  • To truncate the SharePlex tables without purging files in the variable-data directory, you can run the cleanup.sql script from the bin sub-directory (Unix and Linux systems) or the util sub-directory (Windows systems) of the product directory.
  • On Unix and Linux systems, you can purge the files in the variable-data directory, without truncating the SharePlex tables, by running the clean_vardir.sh script from the bin sub-directory of the SharePlex product directory.

Shell requirement

To use this utility, the Korn (ksh) shell must be installed on the system. The utility calls this shell during processing.

How ora_cleansp works

ora_cleansp works in two stages to restore replication to an initial state, as follows:

truncate internal tables: First ora_cleansp truncates any SharePlex internal tables that can be truncated safely. It does not remove the SharePlex Oracle user, password, or demonstration objects.

clean the variable-data directory: Next, ora_cleansp removes the following components from the SharePlex variable-data directory:

    • The queue files in the rim sub-directory.
    • The log files in the log sub-directory. The Event log retains one entry reflecting the outcome of the ora_cleansp procedure.
    • The contents of the statusdb file in the data sub-directory.
    • The contents of the dump and state sub-directories.
    • Any transactions in the oos sub-directory, if the SP_OPO_SAVE_OOS_TRANSACTION parameter is enabled.

ora_cleansp preserves user-created files such as configuration files, conflict-resolution files, transformation files, hint files, the paramdb, and the oramsglist file.

ora_cleansp deactivates configurations. To start replication after running ora_cleansp, you must activate a configuration.

Run ora_cleansp

Important! ora_cleansp must be run on all source and target systems to restore replication to an initial state. To verify if and when ora_cleansp was run on a system, view the Event Log on that system.

  1. Log on as a SharePlex Administrator.
  2. [Unix and Linux ONLY] Set the SP_SYS_VARDIR environment variable to point to the SharePlex variable-data directory. If you are running multiple instances of sp_cop using multiple variable-data directories, set SP_SYS_VARDIR for the variable-data directory that you want to clean up.

    ksh shell:

    $export SP_SYS_VARDIR=/SharePlex_vardir_absolute_path

    csh shell:

    $setenv SP_SYS_VARDIR /SharePlex_vardir_absolute_path
  3. Run sp_ctrl from the bin sub-directory of the SharePlex product directory.
  4. Shut down sp_cop.

    sp_ctrl> shutdown
  5. Verify that all SharePlex processes are stopped by using either the ps -ef | grep sp_ command on Unix and Linux systems or Taskmgr from the SpUtil program on Windows systems.
  6. Kill all orphan SharePlex processes by using either the kill -9 command on Unix and Linux systems or the KillSharePlex.bat program on Windows systems.
  7. [Unix and Linux ONLY] If you have not done so already, view the oratab file to determine the values for ORACLE_HOME and ORACLE_SID for the instance.

    $cd /etc
    $ more oratab
  8. [Unix and Linux ONLY] Set the ORACLE_HOME and ORACLE_SID environment variables.

    ksh shell:

    $export ORACLE_HOME=[value from oratab file]
    $export ORACLE_SID=[value from oratab file]

    csh shell:

    $ setenv ORACLE_HOME [value from oratab file]
    $ setenv ORACLE_SID [value from oratab file]
  9. On the command line of the operating system, change directories to the bin sub-directory of the SharePlex product directory (note: this must be the current working directory).

  10. Run ora_cleansp as the SharePlex user account in the Oracle instance. Note: If run as a different user, ora_cleansp does not truncate the SharePlex tables.

    Additionally, on Unix and Linux, include the database/datasource name (Oracle_SID) as defined in the connections.yaml file.

    Unix and Linux:

    $ ./ora_cleansp database_name/SharePlex_username[/SharePlex_password]

    (For an Oracle PDB): $./ora_cleansp tns_alias for pdb/SharePlex_username[/SharePlex_password]

    Windows:

    C:\users\splex\bin>ora_cleansp SharePlex_username[/SharePlex_password]

    (For an Oracle PDB): C:\users\splex\bin>ora_cleansp SharePlex_username[/SharePlex_password@tns_alias for pdb]

    Important! On Windows, if you installed SharePlex on any port other than the default of 2100, use the -r option to specify the port number. For example, in the following command the port number is 9400:

    C:\users\splex\bin>ora_cleansp SharePlex_username[/SharePlex_password] -r9400

  11. View the Event Log after you run the utility to confirm its results.

    Note: If the utility generates an error message stating that it cannot remove the .../ save_SharePlex_version directory, you can ignore the message and remove this directory.

ppas_cleansp

Description

Use the pg_cleansp utility to remove the current replication state on a system where SharePlex is replicating to an Postgres target.

Caution: The effects of pg_cleansp are not reversible. To stop replication without restoring it to an initial state, you might be able to use the abort config or purge config command.

Usage guidelines

  • To use this utility, the Korn (ksh) shell must be installed on the system. The utility calls this shell during processing.

  • pg_cleansp must be run on all Postgres target systems in the replication configuration.
  • To fully remove the replication environment, run the ora_cleansp utility on all Oracle source systems in the replication configuration. To verify if and when pg_cleansp or ora_cleansp was run on a system, view the SharePlex event log on that system.

What this utility does

pg_cleansp does the following on the target system:

  • Truncates the SHAREPLEX_OPEN_TRANS internal table in the SharePlex schema and any other SharePlex-installed tables as applicable.
  • Removes the following from the variable-data directory: the queue files, the process log files, the contents of the statusdb (but not the file), the contents of the dump and state directories, and all but one entry in the event log (the status entry for pg_cleansp)

pg_cleansp preserves the following:

  • The SharePlex database, account, and password, and only cleans the data in the SharePlex tables.
  • User-created files such as the paramdb and the target configuration settings

Supported databases

All implementations of the Postgres open-source database on supported platforms

Run pg_cleansp

  1. Stop all SharePlex processes on the system.
  2. Shut down sp_cop.
  3. Run the pg_cleansp utility from the bin sub-directory of the SharePlex product directory with the following syntax:

    C:\users\splex\bin>pg_cleansp [port number ] database_name/user_name

    where:

    • port number is the port number of the SharePlex instance, if other than the default of 2100.
    • database_name is the name of the SharePlex database.
    • user_name is the name of the SharePlex user account.
  4. Enter the password at the prompt.

    Enter the password for the Shareplex User :

  5. Type Y to confirm that you want to run cleanup for this SharePlex instance.

    Are you sure you want to perform the clean for '/splex/vardir/var2' and port 2200? [N] : Y

td_cleansp

Overview

Use the td_cleansp utility to remove the current replication state on a system where SharePlex is replicating to a Teradata target.

Caution: The effects of td_cleansp are not reversible. To stop replication without restoring it to an initial state, you might be able to use the abort config or purge config command.

Usage guidelines

  • To use this utility, the Korn (ksh) shell must be installed on the system. The utility calls this shell during processing.

  • td_cleansp must be run on all Teradata target systems in the replication configuration.
  • To fully remove the replication environment, run the ora_cleansp utility on all Oracle source systems in the replication configuration. To verify if and when td_cleansp or ora_cleansp was run on a system, view the SharePlex event log on that system.

What this utility does

td_cleansp does the following on the target system:

  • Truncates the SHAREPLEX_OPEN_TRANS internal table in the SharePlex schema and any other SharePlex-installed tables as applicable.
  • Removes the following from the variable-data directory: the queue files, the process log files, the contents of the statusdb (but not the file), the contents of the dump and state directories, and all but one entry in the event log (the status entry for td_cleansp)

td_cleansp preserves the following:

  • The SharePlex database, account, and password, and only cleans the data in the SharePlex tables.
  • User-created files such as the paramdb and the target configuration settings

Supported databases

Teradata on supported platforms

Run td_cleansp

  1. Stop all SharePlex processes on the system.
  2. Shut down sp_cop.
  3. Run the td_cleansp utility from the bin sub-directory of the SharePlex product directory with the following syntax:

    C:\users\splex\bin>td_cleansp [port number ] database_name/user_name

    where:

    • port number is the port number of the SharePlex instance, if other than the default of 2100.
    • database_name is the name of the SharePlex database.
    • user_name is the name of the SharePlex user account.
  4. Enter the password at the prompt.

    Enter the password for the Shareplex User :

  5. Type Y to confirm that you want to run cleanup for this SharePlex instance.

    Are you sure you want to perform the clean for '/splex/vardir/var2' and port 2200? [N] : Y

License utilities

Description

Use the SharePlex license utilities to view and add license keys to hosts in the SharePlex replication environment. Each installation of SharePlex requires a valid license key. There are three types of SharePlex license keys:

  • Temporary license keys (demonstration licenses)
  • Permanent license keys
  • Site license keys

The current license model for SharePlex is to license for a specific host, which depending on edition is licensed by core(s) or socket(s) and specific message repository (i.e. database, JMS/text files) etc. Specifics of license terms should be obtained from your account manager.

If you do not have a valid license key, you may obtain one from Quest Technical Support or your Quest sales representative. Use the appropriate procedure in this documentation to obtain the necessary information to support your license request.

License utilities on Unix and Linux

On Unix and Linux systems, separate utilities are used to:

Gather information to request a license

Use the splex_uname utility to collect information about the local host that is required for Quest to generate a license key. Run this utility from the util sub-directory of the SharePlex product directory.

$ /proddir/util/splex_uname

The information is similar to the following example:

Local system info:
Host Name	 	= irvspxu09
Host ID	 	= 2198894273 (831076C1 HEX)
Operating System	= SunOS
Machine model		= SUNW,UltraAX-i2
CPU Type		= sparc9
CPU Speed	 	= 500
Number of CPUs	 	= 1

Add a license key

Use the splex_add_key utility to add a license key to a machine during the installation of SharePlex or afterward to convert from one type of license to another.

You can use the splex_add_key utility as follows:

  • You can use splex_add_key on the primary node of a cluster to install licenses for all secondary nodes in the cluster, because they all share one variable-data directory.
  • You cannot use splex_add_key to add licenses for non-clustered machines from one machine. It must be run on each non-clustered replication system so that the license information is stored in the variable-data directory on each system.

To run splex_add_key

  1. Log on to the system as the SharePlex Administrator.
  2. Run sp_ctrl on the machine where you want to install a license key.
  3. If SharePlex is running, shut it down.

    sp_ctrl> shutdown

  4. Run splex_add_key from the install sub-directory of the SharePlex product directory.

    $ /proddir/install/splex_add_key

  5. Choose the appropriate option for how to install the key:

    SharePlex License Utility
    1) Read license key from file
    2) Enter license key manually
    3) Add license key for alternate host
    q) Quit License Utility
    Enter option:

    Note: Use option 3 when installing on secondary nodes in a cluster. To install SharePlex in a cluster, see "Preinstallation instructions for Oracle cluster" in the SharePlex Installation and Setup Guide for Oracle.

  6. If you are entering the key manually, type the license key exactly as you received it from Quest, including the SPLEXKEY= string if one prepends the key, any spaces, and any capitalization. Press Enter when finished typing the key.

  7. Enter the SiteMessage text string provided by Quest with the license key.

    Note: If you selected option 3 to install in a cluster, the utility continually prompts for another machine ID to license, until you exit the license utility.

  8. Enter q to exit the utility.
  9. Start SharePlex when you are ready for replication to resume.

View a license key

Use the splex_get_key utility to view the SharePlex license key, license type, and expiration date on a machine. Run this utility from the install sub-directory of the SharePlex product directory.

$ /proddir/install/splex_get_key

The information is similar to the following example:

$ /splex/proddir/install/splex_get_key
Customer Name = Quest
License Key = EANLCF3P56F8M1JB1K6RBJCBB6TBEP0
Product Name = SharePlex Oracle
License type = demo key
Expired on = 01/01/2008 12:00 AM

License utility on Windows

On Windows platforms, all licensing functions are performed through the SpUtils utility, including viewing the machine ID for a system. Launch the SpUtils utility from the shortcut on the Windows desktop.

Gather information to request a license

Select the Information tab to view information about the local host that is required for Quest to generate a license key. In a cluster, run SpUtils on each node.

Add a license key

Use SpUtils to add a license key to a machine during the installation of SharePlex or afterward to convert from one type of license to another. In a cluster, run SpUtils on the primary node.

  1. Log on to Windows as the SharePlex Administrator.
  2. If SharePlex is running, do the following:

    1. Select the SharePlex Services tab.
    2. Select the port number of the SharePlex instance for which you want to add a license key.
    3. Click Stop.
    4. Wait for Current State to display a message that the service stopped.
  3. Select the License Keys tab.
  4. Select the SharePlex port number from the Port list.

  5. Click Add License, then type or paste the information exactly as you received it from Quest, as follows:

    1. License Key: The license key, including any spaces. The key is case-sensitive.
    2. Customer Name: The text string that was included with the license. The name is case-sensitive.
  6. (Windows Cluster) To add a license for another node in a cluster, select the Add Alternate Host Id check box, then select the machine ID from the CPU ID list box. Repeat this step to add a license to all secondary nodes in the cluster.

  7. Click OK to close the utility.

  8. To start SharePlex, do the following:

    1. Select the SharePlex Services tab.
    2. Select the port number of the SharePlex instance that you licensed.
    3. Click Start.
    4. Wait for Current State to display a message that the service started.

View a license key

Select the License Key tab, then select the port number (if running multiple SharePlex instances) for which you want to view license information.

  • Under License Key, view the actual license key and SiteMessage text string.
  • Under Status, view the type of SharePlex installation, the license type, and the expiration date.

In a cluster, run SpUtils on each node to view the local license.

Related Documents