The Microsoft Change Data Capture Service for Oracle by Attunity is included with Microsoft SQL Server 2012.
The Microsoft Change Data Capture Service for Oracle by Attunity stops capturing data during idle periods. When this issue occurs, you receive the following message on the Status tab in the Oracle Change Data Capture Designer management console:
Trying to retrieve next change record from source database
Additionally, you receive the following message when you try to use the Collect Diagnostics link to read the Xdbcdc_trace table in the Microsoft SQL Server CDC database:
ORACDC517E:Oracle Call Interface (OCI) method failed: ORA-00600: internal error code, arguments: [krvxgintocol11
This issue occurs if the Oracle database is version 184.108.40.206 or an earlier version.
To resolve this issue, do one of the following:
Download and install an update for the existing version of the Oracle database.
Update the Oracle database to version 220.127.116.11 or a later version.
You can enable data collection to help detect the issue that is described in the "Symptoms" section. To do this, follow these steps:
Reproduce the issue.
Click Collect Diagnostics on the Status tab in the Oracle Change Data Capture Designer management console.
Review the output and log files for the error message that is mentioned in the "Symptoms" section. For example, the error message that is mentioned in the "Symptoms" section may appear in one or more of the following output files:
For more information about the issue, enable tracing in the Oracle Change Data Capture Designer management console. To do this, add a new property in the Advanced Settings grid on the Advanced tab, set the name of the property to "trace," and then set the value to "Source." After the issue occurs, run the following query to view the trace data:
SELECT * FROM xdbcdc_trace
Note After you view the trace information, delete the property in the Advanced Settings grid to avoid performance issues.
For more information about the updates that are described in the "Resolution" section, visit the following Oracle website, and search for bug 6707725:
Microsoft provides third-party contact information to help you find technical support. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information.
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.