Use the ora_cleansp utility to remove the current replication state on a system, including deactivating configurations.
Caution:
Oracle on Windows
Before running ora_cleansp, consider the following alternatives:
To use this utility, the Korn (ksh) shell must be installed on the system. The utility calls this shell during processing.
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:
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.
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.
Shut down sp_cop.
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).
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.
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
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.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center