Continuent Documentation

Search:
Page in Other Manuals

8.19. The setupCDC.sh Command

The setupCDC.sh script configures an Oracle database with the necessary CDC tables to enable heterogeneous replication from Oracle to MySQL.

The script accepts one argument, the filename of the configuration file that will define the CDC configuration. The file accepts the parameters as listed in Table 8.36, “setupCDC.conf Configuration Options”.

Table 8.36. setupCDC.conf Configuration Options

CmdLine OptionINI File OptionDescription
cdc_typecdc_typeThe CDC type to be used to extract data, either synchronous (using triggers) or asynchronous (using log processing).
delete_publisherdelete_publisherWhether the publisher user should be deleted.
delete_subscriberdelete_subscriberWhether the subscriber user should be deleted.
pub_passwordpub_passwordThe publisher password that will be created for the CDC service.
pub_userpub_userThe publisher user that will be created for this CDC service.
serviceserviceThe service name of the Tungsten Replicator service that will be created.
source_usersource_userThe source schema user with rights to access the database.
specific_pathspecific_pathThe path where the tungsten.tables file is located; the file must be in a shared location accessible by Tungsten Replicator.
specific_tablesspecific_tablesIf enabled, extract only the tables defined within a tungsten.tables file.
sys_passsys_passThe system password to connect to Oracle as SYSDBA.
sys_usersys_userThe system user to connect to Oracle as SYSDBA.
tungsten_pwdtungsten_pwdThe password for the subscriber user.
tungsten_usertungsten_userThe subscriber (Tungsten user) that will subscribe to the changes and read the information from the CDC tables.

Where:

cdc_type

Optioncdc_type
Config File Optionscdc_type
DescriptionThe CDC type to be used to extract data, either synchronous (using triggers) or asynchronous (using log processing).
Value Typestring
Valid ValuesCDCASYNCEnable asynchronous capture
 CDCSYNCEnable synchronous capture

The CDC type to be used to extract data, either synchronous (using triggers) or asynchronous (using log processing).

delete_publisher

Optiondelete_publisher
Config File Optionsdelete_publisher
DescriptionWhether the publisher user should be deleted.
Value Typestring
Valid Values0Do not the delete the user before creation
 1Delete the user before creation

Whether the publisher user should be deleted.

delete_subscriber

Optiondelete_subscriber
Config File Optionsdelete_subscriber
DescriptionWhether the subscriber user should be deleted.
Value Typestring
Valid Values0Do not the delete the user before creation
 1Delete the user before creation

Whether the subscriber user should be deleted.

pub_password

Optionpub_password
Config File Optionspub_password
DescriptionThe publisher password that will be created for the CDC service.
Value Typestring

The publisher password that will be created for the CDC service.

pub_user

Optionpub_user
Config File Optionspub_user
DescriptionThe publisher user that will be created for this CDC service.
Value Typestring

The publisher user that will be created for this CDC service.

service

Optionservice
Config File Optionsservice
DescriptionThe service name of the Tungsten Replicator service that will be created.
Value Typestring

The service name of the Tungsten Replicator service that will be created.

source_user

Optionsource_user
Config File Optionssource_user
DescriptionThe source schema user with rights to access the database.
Value Typestring

The source schema user with rights to access the database.

specific_path

Optionspecific_path
Config File Optionsspecific_path
DescriptionThe path where the tungsten.tables file is located; the file must be in a shared location accessible by Tungsten Replicator.
Value Typestring

The path where the tungsten.tables file is located; the file must be in a shared location accessible by Tungsten Replicator.

specific_tables

Optionspecific_tables
Config File Optionsspecific_tables
DescriptionIf enabled, extract only the tables defined within a tungsten.tables file.
Value Typestring
Valid Values0Extract all tables
 1Use a tables file to select tables

If enabled, extract only the tables defined within a tungsten.tables file.

sys_pass

Optionsys_pass
Config File Optionssys_pass
DescriptionThe system password to connect to Oracle as SYSDBA.
Value Typestring

The system password to connect to Oracle as SYSDBA.

sys_user

Optionsys_user
Config File Optionssys_user
DescriptionThe system user to connect to Oracle as SYSDBA.
Value Typestring

The system user to connect to Oracle as SYSDBA.

tungsten_pwd

Optiontungsten_pwd
Config File Optionstungsten_pwd
DescriptionThe password for the subscriber user.
Value Typestring

The password for the subscriber user.

tungsten_user

Optiontungsten_user
Config File Optionstungsten_user
DescriptionThe subscriber (Tungsten user) that will subscribe to the changes and read the information from the CDC tables.
Value Typestring

The subscriber (Tungsten user) that will subscribe to the changes and read the information from the CDC tables.

To use, supply the name of the configuration file to setupCDC.sh:

shell> ./setupCDC.sh sample.conf