Editing: Troubleshoot Configuration Issues in Microsoft Change Data Capture for Oracle by Attunity

Title
This article will list the top FAQ and Troubleshooting issues encountered with the Change Data Capture for Oracle by Attunity that is included with SQL Server 2012.<br /> <br /> << Back to [[articles:Microsoft SQL Server 2012 Change Data Capture for Oracle by Attunity Topics]]<br /> <hr /> <h2><a name="Validation_Errors"></a>Validation Errors </h2> When creating an Oracle CDC Instance via the wizard you may notice errors on the following page "Generate Oracle CDC Instance". The Errors under the Validate Oracle environment step are not critical at the moment but will become critical to resolve before you can run the CDC Instance. Therefore you should take a moment and ensure that corrective action is taken for each error before moving forward.  <br /> <br /> You cannot retry the validation to clear the errors, so in lieu of that you may delete the Oracle CDC instance and start over to ensure that all the errors (red X icons) are cleared and turned to green before moving forward int he environment.<br /> <br /> <a href="http://social.technet.microsoft.com/wiki/cfs-file.ashx/__key/communityserver-wikis-components-files/00-00-00-00-05/7028.CDCWizard_5F00_OracleInstance.png"><img alt="" style="border: 0px solid;" src="http://social.technet.microsoft.com/wiki/resized-image.ashx/__size/550x0/__key/communityserver-wikis-components-files/00-00-00-00-05/7028.CDCWizard_5F00_OracleInstance.png" /></a><br /> <br /> <br /> You want all green to ensure success with the CDC Instance later on.<br /> <a href="http://social.technet.microsoft.com/wiki/cfs-file.ashx/__key/communityserver-wikis-components-files/00-00-00-00-05/4846.CDC_5F00_Wizard_5F00_Success.png"><img alt="" style="border: 0px solid;" src="http://social.technet.microsoft.com/wiki/resized-image.ashx/__size/550x0/__key/communityserver-wikis-components-files/00-00-00-00-05/4846.CDC_5F00_Wizard_5F00_Success.png" /></a><br /> <br /> <br /> This page lists some errors you may encounter with the Create Oracle CDC Instance Wizard, and some approaches to resolve them.<br /> <br /> <hr /> <strong> <h2><a name="Error_1"></a>Scenario 1</h2> </strong><br /> <h3><a name="Error"></a>Error: </h3> <p>The database you specified is running in NOARCHIVELOG mode and not in ARCHIVELOG mode. Please contact your Oracle DBA to perform "ALTER DATABASE ARCHIVELOG".</p> <h3><a name="Cause"></a>Cause:</h3> <p>The Oracle database will not keep all the Archive Logs by default when NoArchiveLog mode is used, therefore CDC cannot capture changes unless the ArchiveLog mode is used.</p> <h3><a name="Resolution"></a>Resolution:</h3> <p>To resolve the error, it is best to work with a seasoned Oracle database administrator. These tips may be helpful:<br /> <br /> 1. Add the Archive Log destination location:<br /> edit your init.ora / spfile with the following information<br /> log_archive_dest='/<username>/oradata/archlog' (for example)<br /> log_archive_format='%t_%s.dbf' (for example)<br /> log_archive_start=true </p> <p> 2. On the local Oracle computer, connect using SQL Plus or another tool. Switch the user context to sysdba. Then shutdown the datatabase, and startup without opening the database (mount only), to change the Archivelog setting.</p> <p> </p> <div style="overflow-y: auto;border: #7f9db9 1px solid;" class="reCodeBlock"> <div style="background-color: #fff;"><code style="color: #000;">System@servername </code></div> <div style="background-color: #f8f8f8;"><code style="color: #069; font-weight: bold;">CONNECT</code> <code style="color: #000;">/ </code><code style="color: #069; font-weight: bold;">as</code> <code style="color: #000;">sysdba </code></div> <div style="background-color: #fff;"><code style="color: #000;">SHUTDOWN IMMEDIATE</code></div> <div style="background-color: #f8f8f8;"><code style="color: #000;">STARTUP MOUNT</code></div> <div style="background-color: #fff;"><code style="color: #069; font-weight: bold;">ALTER</code> <code style="color: #069; font-weight: bold;">DATABASE</code> <code style="color: #000;">ARCHIVELOG; </code></div> <div style="background-color: #f8f8f8;"><code style="color: #069; font-weight: bold;">ALTER</code> <code style="color: #069; font-weight: bold;">DATABASE</code> <code style="color: #069; font-weight: bold;">OPEN</code><code style="color: #000;">;</code></div> </div> <p>   </p> <hr />   <h2><a name="Scenario_2"></a>Scenario 2:</h2> <h2> </h2> <h3><a name="Error"></a>Error:</h3> <p>The database you specified is not setup for supplemental logging as required. Please contact your Oracle DBA to perform "ALTER DATABASE ADD SUPPLEMENTAL LOG DATA".</p> <h3><a name="Cause"></a>Cause:</h3> <p>The Oracle database will not log enough information for CDC to be successful in log mining by default, therefore you should manually enable Supplemental Log Data to ensure the nessary changes are logged for the log miner to capture.</p> <h3><a name="Resolution"></a>Resolution:</h3> <p>Connect to the database using SQL Plus or another tool and run the command to add the supplemental log data.</p> <div style="overflow-y: auto;border: #7f9db9 1px solid;" class="reCodeBlock"> <div style="background-color: #fff;"><code style="color: #069; font-weight: bold;">ALTER</code> <code style="color: #069; font-weight: bold;">DATABASE</code> <code style="color: #069; font-weight: bold;">ADD</code> <code style="color: #000;">SUPPLEMENTAL LOG DATA;</code></div> </div> <br /> <br /> <hr /> <p> << Back to [[articles:Microsoft SQL Server 2012 Change Data Capture for Oracle by Attunity Topics]]</p> <p> </p>
Comment
Tags
Please add 8 and 5 and type the answer here:

Products

Resources

Solutions

Updates

Trials

Related Sites

Training

Certifications

Other resources

Support options

More support

Not an IT pro?