4.1.4.4. Installing the Master Replicator

The master replicator reads information from the CDC tables and converts that information into THL, which can then be replicated to other Tungsten Replicator installations. The basic operation is to create an installation using tpm, using the connection information provided when executing the CDC configuration, including the subscriber and CDC type.

  1. Unpack the Tungsten Replicator distribution in staging directory:

    shell> tar zxf tungsten-replicator-6.1.tar.gz
  2. Change into the staging directory:

    shell> cd tungsten-replicator-6.1
  3. Obtain a copy of the Oracle JDBC driver and copy it into the tungsten-replicator/lib directory:

    shell> cp ojdbc6.jar ./tungsten-replicator/lib/
  4. shell> ./tools/tpm install SALES \
    --datasource-oracle-service=ORCL \
    --datasource-type=oracle \
    --install-directory=/opt/continuent \
    --master=host1 \
    --members=host1 \
    --property=replicator.extractor.dbms.transaction_frag_size=10 \
    --property=replicator.global.extract.db.password=password \
    --property=replicator.global.extract.db.user=tungsten \
    --replication-host=host1 \
    --replication-password=password \
    --replication-port=1521 \
    --replication-user=SALES_PUB \
    --role=master \
    --start-and-report=true \
    --svc-table-engine=CDCASYNC

    The description of each of the options is shown below; click the icon to hide this detail:

    Click the icon to show a detailed description of each argument.

If the installation process fails, check the output of the /tmp/tungsten-configure.log file for more information about the root cause.

Once the replicator has been installed, the current status of the replicator can be checked using trepctl status:

shell> trepctl status
Processing status command...
NAME                     VALUE
----                     -----
appliedLastEventId     : ora:16626156
appliedLastSeqno       : 67
appliedLatency         : 37.51
autoRecoveryEnabled    : false
autoRecoveryTotal      : 0
channels               : 1
clusterName            : SALES
currentEventId         : NONE
currentTimeMillis      : 1410430937700
dataServerHost         : tr-fromoracle1
extensions             : 
host                   : tr-fromoracle1
latestEpochNumber      : 67
masterConnectUri       : thl://localhost:/
masterListenUri        : thl://tr-fromoracle1:2112/
maximumStoredSeqNo     : 67
minimumStoredSeqNo     : 67
offlineRequests        : NONE
pendingError           : NONE
pendingErrorCode       : NONE
pendingErrorEventId    : NONE
pendingErrorSeqno      : -1
pendingExceptionMessage: NONE
pipelineSource         : UNKNOWN
relativeLatency        : 38.699
resourcePrecedence     : 99
rmiPort                : 10000
role                   : master
seqnoType              : java.lang.Long
serviceName            : SALES
serviceType            : local
simpleServiceName      : SALES
siteName               : default
sourceId               : tr-fromoracle1
state                  : ONLINE
timeInStateSeconds     : 37.782
transitioningTo        : 
uptimeSeconds          : 102.545
useSSLConnection       : false
version                : Tungsten Replicator 6.1.1 build 54
Finished status command...