4.7.2. Install Oracle Applier

4.7.2. Install Oracle Applier
Prev	^Up	4.7. Deploying the Oracle Applier	Next

4.7.2. Install Oracle Applier

The Applier replicator will read the THL from the remote Extractor and apply it into Oracle using a standard JDBC connection. The Applier replicator needs to know the Extractor hostname, and the datasource type.

Unpack the Tungsten Replicator distribution in staging directory:
copy
```
shell> tar zxf tungsten-replicator-7.1.4-10.tar.gz
```
Change into the staging directory:
copy
```
shell> cd tungsten-replicator-7.1.4-10
```
Obtain a copy of the Oracle JDBC driver and copy it into the tungsten-replicator/lib directory:
copy
```
shell> cp ojdbc7.jar ./tungsten-replicator/lib/
```
Configure the installation using tpm:
Show Staging
Show INI
copy
```
shell> ./tools/tpm configure defaults \
    --reset \
    --install-directory=/opt/continuent \
    --profile-script=~/.bash_profile \
    --skip-validation-check=InstallerMasterSlaveCheck \
    --rest-api-admin-user=apiuser \
    --rest-api-admin-pass=secret

shell> ./tools/tpm configure alpha \
    --master=sourcehost \
    --members=localhost \
    --datasource-type=oracle \
    --datasource-oracle-service=ORCL \
    --datasource-user=tungsten_alpha \
    --datasource-password=secret \
    --svc-applier-filters=dropstatementdata
```
copy
```
shell> vi /etc/tungsten/tungsten.ini
```
copy
```
[defaults]
install-directory=/opt/continuent
profile-script=~/.bash_profile
skip-validation-check=InstallerMasterSlaveCheck
rest-api-admin-user=apiuser
rest-api-admin-pass=secret

[alpha]
master=sourcehost
members=localhost
datasource-type=oracle
datasource-oracle-service=ORCL
datasource-user=tungsten_alpha
datasource-password=secret
svc-applier-filters=dropstatementdata
```
Configuration group defaults
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.
- --reset
  reset
  For staging configurations, deletes all pre-existing configuration information between updating with the new configuration values.
- --install-directory=/opt/continuent
  install-directory=/opt/continuent
  Path to the directory where the active deployment will be installed. The configured directory will contain the software, THL and relay log information unless configured otherwise.
- --profile-script=~/.bash_profile
  profile-script=~/.bash_profile
  Append commands to include env.sh in this profile script
- --skip-validation-check=InstallerMasterSlaveCheck
  skip-validation-check=InstallerMasterSlaveCheck
  The --skip-validation-check disables a given validation check. If any validation check fails, the installation, validation or configuration will automatically stop.
  Warning
  Using this option enables you to bypass the specified check, although skipping a check may lead to an invalid or non-working configuration.
  You can identify a given check if an error or warning has been raised during configuration. For example, the default table type check:
```
...
ERROR >> centos >> The datasource root@centos:3306 (WITH PASSWORD) » 
 uses MyISAM as the default storage engine (MySQLDefaultTableTypeCheck)
...
```
  The check in this case is MySQLDefaultTableTypeCheck, and could be ignored using --skip-validation-check=MySQLDefaultTableTypeCheck.
  Setting both --skip-validation-check and --enable-validation-check is equivalent to explicitly disabling the specified check.
- --rest-api-admin-user=apiuser
  rest-api-admin-user=apiuser
  Optional: Must be specified along with rest-api-admin-pass if you wish to access the full API features and use the Dashboard GUI for cluster installations.
- --rest-api-admin-pass=secret
  rest-api-admin-pass=secret
  Optional: Must be specified along with rest-api-admin-user if you wish to access the full API features.
Configuration group alpha
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.
- --master=sourcehost
  master=sourcehost
  The hostname of the primary (extractor) within the current service.
- --members=localhost
  members=localhost
  Hostnames for the dataservice members
- --datasource-type=oracle
  datasource-type=oracle
  Database type
- --datasource-oracle-service=ORCL
  datasource-oracle-service=ORCL
  Oracle Service Name
- --datasource-user=tungsten_alpha
  datasource-user=tungsten_alpha
  For databases that required authentication, the username to use when connecting to the database using the corresponding connection method (native, JDBC, etc.).
- --datasource-password=secret
  datasource-password=secret
  The password to be used when connecting to the database using the corresponding --replication-user.
- --svc-applier-filters=dropstatementdata
  svc-applier-filters=dropstatementdata
  Replication service applier filters
replication-host should be added to the above configuration if the target Oracle Database is on a different host to the applier installation
Note
If you plan to make full use of the REST API (which is enabled by default) you will need to also configure a username and password for API access. This must be done by specifying the following options in your configuration:
```
rest-api-admin-user=tungsten
rest-api-admin-pass=secret
```
Once the prerequisites and configuring of the installation has been completed, the software can be installed:
copy
```
shell> ./tools/tpm install
```

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

Once the installation has completed, the status of the service should be reported. The service should be online and reading events from the Extractor replicator.

The status of the replicator can be checked and monitored by using the trepctl command.

tar zxf tungsten-replicator-7.1.4-10.tar.gz
cd tungsten-replicator-7.1.4-10
cp ojdbc7.jar ./tungsten-replicator/lib/
./tools/tpm configure defaults \
    --reset \
    --install-directory=/opt/continuent \
    --profile-script=~/.bash_profile \
    --skip-validation-check=InstallerMasterSlaveCheck \
    --rest-api-admin-user=apiuser \
    --rest-api-admin-pass=secret

./tools/tpm configure alpha \
    --master=sourcehost \
    --members=localhost \
    --datasource-type=oracle \
    --datasource-oracle-service=ORCL \
    --datasource-user=tungsten_alpha \
    --datasource-password=secret \
    --svc-applier-filters=dropstatementdata
vi /etc/tungsten/tungsten.ini
[defaults]
install-directory=/opt/continuent
profile-script=~/.bash_profile
skip-validation-check=InstallerMasterSlaveCheck
rest-api-admin-user=apiuser
rest-api-admin-pass=secret

[alpha]
master=sourcehost
members=localhost
datasource-type=oracle
datasource-oracle-service=ORCL
datasource-user=tungsten_alpha
datasource-password=secret
svc-applier-filters=dropstatementdata
./tools/tpm install

Show Copy-friendly Text

Prev	Up	Next
4.7.1.3. Create the Destination Schema	^Level	4.8. Deploying the PostgreSQL Applier

Continuent Documentation

4.7.2. Install Oracle Applier

Warning

Note