Site icon Database Tutorials

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.

Exit mobile version