Error message when you use the Microsoft Change Data Capture Service for Oracle by Attunity

This article helps you resolve the problem that occurs when you use the Change Data Capture Service for Oracle by Attunity.

Original product version:   SQL Server 2012 Enterprise, SQL Server 2012 Developer
Original KB number:   2672759

Symptoms

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 SQL Server CDC database:

ORACDC517E:Oracle Call Interface (OCI) method failed: ORA-00600: internal error code, arguments: [krvxgintocol11

Cause

This issue occurs if the Oracle database is version 11.1.0.7 or an earlier version.

Resolution

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 11.2.0.1 or a later version.

More information

You can enable data collection to help detect the issue that is described in the "Symptoms" section. To do this, follow these steps:

1. Reproduce the issue.

2. Click Collect Diagnostics on the Status tab in the Oracle Change Data Capture Designer management console.

3. 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:

   • \app\administrator\diag\rdbms\orclcdc\orclcdc\alert\log.xml
   • \app\administrator\diag\rdbms\orclcdc\orclcdc\trace\orclcdc_ora_1932.trc

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

References

For more information about the updates that are described in the Resolution section, see My Oracle Support.

Third-party information disclaimer

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.