404 Resource at '/content/informaticadita-com/en_us/data-integration/powerexchange-for-cdc-and-mainframe/10-2/_cdc-guide-for-linux-unix-and-windows_powerexchange-for-cdc-and-mainframe_10-2_ditamap/powerexchange_cdc_data_sources_1/express_cdc_for_oracle/configuring_oracle_for_express_cdc/jcr:content/header/menupage.nocache.html/informaticadita-com/components/content/menu-hover' not found: No resource found

Resource at '/content/informaticadita-com/en_us/data-integration/powerexchange-for-cdc-and-mainframe/10-2/_cdc-guide-for-linux-unix-and-windows_powerexchange-for-cdc-and-mainframe_10-2_ditamap/powerexchange_cdc_data_sources_1/express_cdc_for_oracle/configuring_oracle_for_express_cdc/jcr:content/header/menupage.nocache.html/informaticadita-com/components/content/menu-hover' not found: No resource found

Cannot serve request to /content/informaticadita-com/en_us/data-integration/powerexchange-for-cdc-and-mainframe/10-2/_cdc-guide-for-linux-unix-and-windows_powerexchange-for-cdc-and-mainframe_10-2_ditamap/powerexchange_cdc_data_sources_1/express_cdc_for_oracle/configuring_oracle_for_express_cdc/_jcr_content/header/menupage.nocache.html/informaticadita-com/components/content/menu-hover on this server

Apache Sling
English
  • PowerExchange for CDC and Mainframe 10.2
  • All Products

Table of Contents

Search

  1. Preface
  2. Part 1: PowerExchange CDC Introduction
  3. Part 2: PowerExchange CDC Components
  4. Part 3: PowerExchange CDC Data Sources
  5. Part 4: Change Data Extraction
  6. Part 5: Monitoring and Tuning
  7. Appendix A: DTL__CAPXTIMESTAMP Time Stamps

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

Back Next

Configuring Oracle for Express CDC

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:
  1. Specify an archive log destination for PowerExchange Express CDC for Oracle use if one is not already defined.
  2. Enable ARCHIVELOG mode if it is not already enabled.
  3. If you enable ARCHIVELOG mode, stop and restart the Oracle database.
  4. Create an Oracle user and grant user privileges.
  5. 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.
  6. 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.
0 COMMENTS
We’d like to hear from you!