CDC Guide for Linux, UNIX, and Windows

10.2
- 10.2.2
- 10.2.1
- 10.0

Back Next

Customizing the dbmover Configuration File for Oracle CDC

Customize the dbmover configuration file to add some statements for PowerExchange Oracle CDC with LogMiner.

Enter the following statements for Oracle CDC with LogMiner:

CAPT_PATH statement: Path to the local directory on a Linux, UNIX, or Windows 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 statement: Path to the local directory on a Linux, UNIX, or Windows system that stores extraction maps for CDC.
ORACLEID statement: The Oracle source instance, database, and connection information for CDC.
ORCL CAPI_CONNECTION statement: A named set of parameters that the Consumer API (CAPI) uses to connect to the change stream and control CDC processing for Oracle sources.
UOWC CAPI_CONNECTION statement: A named set of parameters that the CAPI uses for the UOW Cleanser.
In this statement, the CAPINAME parameter points to an ORCL CAPI_CONNECTION statement.

If you plan to use continuous extraction mode, you must also include the following statement:

CAPX CAPI_CONNECTION statement: A named set of parameters that the CAPI uses for continuous extraction of change data from PowerExchange Logger for Linux, UNIX, and Windows log files.

Define the CAPI_CONNECTION statements in the dbmover configuration file on the system where the Oracle capture registrations are stored. This location corresponds to the

Location

node that you specify when defining a registration group. Usually, this location is where the source database resides.

Additionally, Informatica recommends including the LOGPATH and TRACING statements to make finding messages easier. The LOGPATH statement defines a directory specifically for PowerExchange message log files, and the TRACING statement enables PowerExchange to create an alternative set of message log files for each PowerExchange process.

For more information about all dbmover statements, see the

PowerExchange Reference Manual

PowerExchange Configuration for CDC with LogMiner

Example dbmover Statements for Oracle CDC with LogMiner

ORACLEID Statement

CAPI_CONNECTION - ORCL Statement

Oracle Catalog Parameters in the ORCL CAPI_CONNECTION Statement

CAPI_CONNECTION - UOWC Statement

CAPI_CONNECTION - CAPX Statement

CAPI_CONNECTION - ORCL Statement

CAPI_CONNECTION - UOWC Statement

ORACLEID Statement