CDC Guide for Linux, UNIX, and Windows

10.0
- 10.2.2
- 10.2.1
- 10.2

Back Next

Customizing the PowerExchange Express CDC for Oracle Configuration File

You specify PowerExchange Express CDC for Oracle parameters in a configuration file that is separate from the dbmover.cfg file.

PowerExchange supplies the sample pwxorad.cfg file in the directory that is specified in the PWX_HOME environment variable, or if that variable is not defined, in the PowerExchange bin directory. The sample file contains comments that describe the required and optional statements and keywords.

Copy the sample file and customize the copy. If you copy the file under another name or to another directory, you must include the PARMFILE parameter in the ORAD CAPI_CONNECTION statement in the dbmover.cfg file to point to the customized copy.

The following table summarizes the statements that you can define in the PowerExchange Express CDC for Oracle configuration file:

Statement	Required or Optional	Description
DATABASE	Optional	Provides overrides for database connection information, including the capture connection string and database user ID and password. Also includes the TDE encryption password, which is required if you capture changes from TDE-encrypted tablespaces.
DICTIONARY	Required	Indicates where PowerExchange gets the Oracle data dictionary information that it uses to interpret the redo logs and how PowerExchange reacts to DDL changes that might occur after the dictionary is read into memory.
DIRSUB	Optional	Specifies a path prefix that PowerExchange Express CDC for Oracle substitutes for the original path prefix that the Oracle server uses to access active and archived redo logs. This substitute path is required when the PowerExchange Express CDC log reader runs on a system other than the Oracle server and uses a different path to access the redo log files.
OPTIONS	Optional	Provides options for CDC processing, including the number of log records staged in memory, maximum spill file size, and capture of Oracle rowid values.
RAC	Optional	Specifies the number of member instances in an Oracle RAC from which you capture changes.
READER	Required	Provides options for reading the redo logs.
STANDBY	Optional	Defines a connection to an Oracle physical standby database when the database is not open for read-only access. This statement applies only when the CDC source is an Oracle physical standby database.