Chat now with support
Chat with Support

SharePlex 11.3 - Administration Guide

About this Guide Conventions used in this guide Revision History Overview of SharePlex Run SharePlex Run multiple instances of SharePlex Execute commands in sp_ctrl Set SharePlex parameters Configure data replication Configure replication to and from a container database Configure named queues Configure partitioned replication Configure replication to a change history target Configure a replication strategy Configure DDL replication Configure error handling Configure data transformation Configure security features Assign SharePlex users to security groups Start replication on your production systems Monitor SharePlex Prevent and solve replication problems Repair out-of-sync data Tune the Capture process Tune the Post process Recover replication after Oracle failover Make changes to an active replication environment Apply an Oracle application patch or upgrade Back up Oracle data on the source or target Troubleshooting Tips Appendix A: Peer-To-Peer Diagram Appendix B: SharePlex environment variables

Appendix A: Peer-To-Peer Diagram

This diagram visually explains the concept of peer-to-peer replication. For more information, see Configure Peer-to-Peer Replication .

Appendix B: SharePlex environment variables

SharePlex uses the following environment variables, which you may need to set in certain situations. Usually you must perform additional steps before or after setting a variable, so refer to the recommended instructions before setting a SharePlex variable.

Environment Variable Description
EDITOR Sets the default ASCII text editor for sp_ctrl commands that use one, for example the create config command.
HOST Sets a host name for all locally run sessions of sp_ctrl.
SP_COP_TPORT

Sets a non-default port number for an instance of SharePlex. The default port number is 2100. You may need to set a different port number if one of the following is true:

  • You are setting up additional instances of sp_cop.
  • A different port number than 2100 must be used.
SP_SYS_HOST_NAME

Sets the host name that SharePlex binds to during configuration activation. This variable is used for the following:

  • Sets the virtual IP address (also known as the global cluster package name) on a clustered system, such as Oracle RAC. This variable must be set on all cluster nodes.
  • If SP_SYS_HOST_NAME is set to an IPV6 address on the source system, SharePlex on the target system must be version 9.0 or later.

SP_SYS_VARDIR Sets the full path to the SharePlex variable-data directory so that sp_cop can locate the configuration data, queues, logs and other information. If there is only one instance of sp_cop on the local system, this variable is set by default*. If there are multiple instances of sp_cop on the local system, always set this variable to point to the correct variable-data directory of an instance before setting any other SharePlex variables for that instance.
SP_SYS_SECURE_MODE

Suppresses the output of the compare and repair SQL log file for all compare and repair runs while the current instance of SharePlex is running. This variable must be set before starting SharePlex, so if the sp_cop process is running it must be restarted after setting this variable. When sp_cop is run with this environment variable, the compare and repair commands will not put data into SQL files and the Post process will not put data into the SharePlex error log.

* On Unix and Linux, the variable-data directory is set in the proddir/data/default.yaml file.

To set an environment variable in Unix or Linux:

ksh shell:

export variable_name=value

csh shell:

setenv variable_name value

 

ksh shell:

export SP_SYS_VARDIR=full_path_of_variable-data_directory

csh shell:

setenv SP_SYS_VARDIR full_path_of_variable-data_directory

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating