Use the ora_cleansp utility to remove the current replication state on a system, including deactivating configurations.
Caution:
|
Oracle on Unix and Linux
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.
To 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.
[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:
csh shell:
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.
ksh shell:
csh shell:
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]
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.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 利用規約 プライバシー Cookie Preference Center