Revision #1

You are currently reviewing an older revision of this page.
Go to current version
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.


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. 

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.




This page lists some errors you may encounter with the Create Oracle CDC Instance Wizard, and some approaches to resolve them.


Error 1


The database you specified is running in NOARCHIVELOG mode and not in ARCHIVELOG mode. Please contact your Oracle DBA to perform "ALTER DATABASE ARCHIVELOG".

Resolution Tips:
To resolve the error, it is best to work with a seasoned Oracle database administrator. These tips may be helpful:

1. Add the Archive Log destination location:
edit your init.ora / spfile with the following information
log_archive_dest='/<username>/oradata/archlog' (for example)
log_archive_format='%t_%s.dbf' (for example)
log_archive_start=true

 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.

 

System@servername
CONNECT as sysdba
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;

 

 


 

Error 2

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".

Connect to the database using SQL Plus or another tool and run the command to add the supplemental log data.

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;



 

 

Revert to this revision