ORA-00600: internal error code, arguments: [kpoal8-1]

Problem:

When attempting to pull data from sql server with db link in Oracle database, ORA-600 error occurs.

Reason:

Setting the cursor_sharing parameter to force on the database parameters causes this error. (Bug: 11858021 – ORA-600 KPOAL8-1 SELECTING USING DG4DRDA WITH CURSOR_SHARING = FORCE)

Solution:

Change the cursor_sharing parameter to exact or apply the 11858021 patch. This patch can be applied if the database version is 11.2.0.2.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *