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 Oracle for Express CDC

You must perform some configuration tasks in Oracle to prepare for PowerExchange Express CDC for Oracle.

If you have not configured the use of archived logs, enable ARCHIVELOG mode and specify a primary archive log destination. Then use the sample file, ora_orad.sql, that PowerExchange supplies in its installation directory to perform the other tasks. To run the SQL statements in the ora_orad.sql file, you must be assigned the role of DBA.

Complete the following Oracle configuration tasks:

Specify an archive log destination for PowerExchange Express CDC for Oracle use if one is not already defined.

Enable ARCHIVELOG mode if it is not already enabled.

If you enable ARCHIVELOG mode, stop and restart the Oracle database.

Create an Oracle user and grant user privileges.

If you use ASM and plan to connect to an ASM instance to read ASM-managed Oracle redo logs, create an ASM user that has SYSDBA or SYSASM authority.

Enable Oracle minimal global supplemental logging.

For configuration tasks specific to Oracle multitenant environments, see Task Flow: Configuring Change Capture from an Oracle Multitenant Pluggable Database.

Express CDC for Oracle

Specifying an Archive Log Destination

Enabling ARCHIVELOG Mode

Creating an Oracle User and Granting User Privileges