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.