CDC Guide for Linux, UNIX, and Windows

10.5
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Configuring the dbmover Configuration File

In the dbmover configuration file, define the statements that are required for PowerExchange Express CDC for Oracle. Include the optional statements as needed.

Define the following statements in the dbmover configuration file on the system where the capture registrations and CDC control files are stored, which is specified as the

Location

node in the registration group:

CAPT_PATH: Required. Path to the local directory on the system that contains the control files for CDC. These files are: the CCT file for capture registrations, the CDEP file for application names that are used for ODBC extractions, and the CDCT file for the PowerExchange Logger for Linux, UNIX, and Windows.
CAPT_XTRA: Required. Path to the local directory on a system that stores extraction maps for CDC.
ORACLE_CAPTURE_TYPE: Ensure that this statement specifies D
to use PowerExchange Express CDC use for the PowerExchange installation.

If multiple systems are involved in CDC processing, for example, because you run a separate PowerExchange Listener to handle registrations and extraction maps, check the ORACLE_CAPTURE_TYPE setting in the dbmover.cfg file on each system.
ORACLEID: Required. The Oracle source instance, database, and connection information that is used for CDC.

If you capture change data from a pluggable database (PDB) in an Oracle multitenant environment, you must include the following parameter settings:

In the second positional parameter, oracle_db, specify the name of the database that contains the PDB.
In the third positional parameter, source_connect_string, specify the Oracle connection string, defined in TNS, that is used to connect to the Oracle database that contains the tables in the PDB. The PowerExchange Navigator requires this parameter value to access the source database when you create capture registrations or perform database row tests.
In the fourth positional parameter, capture_connect_string, specify the name of the PDB service entry in the tnsnames.ora file.
ORACLE_UNHANDLED_NUMASCHAR: Optional. Controls whether capture registration processing for PowerExchange Express CDC sources handles NUMBER columns that have a precision greater than 28 or an undefined length as variable length strings and handles FLOAT columns that have a precision greater than 15 as variable length strings.
ORAD CAPI_CONNECTION: Required. A named set of parameters that the Consumer API (CAPI) uses to connect to the change stream and control PowerExchange Express CDC for Oracle processing for Oracle data sources. In this statement, you can include the PARMFILE parameter to point to the separate configuration file that contains statements and parameters specifically for PowerExchange Express CDC for Oracle. Include the PARMFILE parameter if you want to override the default file name of pwxorad.cfg.

For more information about the ORACLE_CAPTURE_TYPE, ORACLE_UNHANDLED_NUMASCHAR, and ORAD CAPI_CONNECTION statements, see the following detailed descriptions. For more information about all other DBMOVER statements, see the

PowerExchange Reference Manual

Configuring PowerExchange for Express CDC

ORACLEID Statement

ORACLE_CAPTURE_TYPE Statement

CAPI_CONNECTION - ORAD Statement

ORACLE_UNHANDLED_NUMASCHAR Statement

Example dbmover Configuration File for the Oracle Change Capture System

CAPI_CONNECTION - ORAD Statement

CAPI_CONNECTION - CAPX Statement

ORACLEID Statement

ORACLE_UNHANDLED_NUMASCHAR Statement

ORACLE_CAPTURE_TYPE Statement