Error message when you use the Microsoft Change Data Capture Service for Oracle by Attunity: "ORA-00600: internal error code"

The Microsoft Change Data Capture Service for Oracle by Attunity is included with Microsoft SQL Server 2012.

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 Microsoft 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

Note After you view the trace information, delete the property in the Advanced Settings grid to avoid performance issues.

References

For more information about the updates that are described in the "Resolution" section, visit the following Oracle website, and search for bug 6707725:

https://support.oracle.com
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.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×