Use the ora_cleansp utility to remove the current replication state on a system, including deactivating configurations.
Oracle on Unix, Linux, and 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.
[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.
Shut down sp_cop.
[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.
[Unix and Linux ONLY] Set the ORACLE_HOME and ORACLE_SID environment variables.
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.
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]
(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.