To configure PowerExchange Oracle CDC with LogMiner, use the readme_oracapt.txt file and the sample SQL script files in the PowerExchange installation directory.
The readme_oracapt.txt file describes the following sample SQL script files that PowerExchange provides for preparing Oracle for CDC:
Setup_Archive_Logging.sql
(non-RAC environments) or
Setup_Archive_Logging_rac.sql
(RAC environments). Defines the archive log destination and enables ARCHIVELOG mode.
Setup_Minimal_Supplemental_Logging.sql
. Enables global minimal supplemental logging.
Setup_Logminer_Tablespace.sql
. Creates a tablespace for exclusive LogMiner use.
Create_ORACAPT_user.sql
. Defines an Oracle CDC user and grants user privileges.
Optional_GRANT_for_registrations.sql
. Grants the privilege that the Oracle CDC user requires to run generated DDL for creating a supplemental log group at capture registration completion in the PowerExchange Navigator.
Copy_Oracle_Dictionary.sql
. Copies the Oracle catalog to the archived redo logs.
DataGuard_Logon_Trigger.sql
. Creates a Data Guard logon trigger for the Oracle CDC user to prevent database row test or PowerExchange Logger failures when capturing changes from an Oracle Data Guard logical standby database.