DG4MSQL 11gR2 - ORA-28506: parse error in data dictionary translation for ALL_CATALOG stored in sys.hs_all_dd (Doc ID 2195422.1)

Last updated on FEBRUARY 01, 2017

Applies to:

Oracle Database Gateway for SQL Server - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Oracle database 11.2.0.4 on Windows server 2008, database gateway for MSSQL (dg4msql) 11.2.0.4 too.

SQL Server upgraded from 2005 to 2012.

Running the following query accessing SQL Server 2005 - works fine
  select * from all_catalog@DBLINK - Getting 1256 rows.

Running the same query pointing to the new SQL Server 2012 sql server, getting the below error:

ORA-28506: parse error in data dictionary translation for ALL_CATALOG stored in sys.hs_all_dd
ORA-28559: FDS_CLASS_NAME is MSSQL11.2.0.4.0_0019, FDS_INST_NAME is tg4msqlr
ORA-00604: error occurred at recursive SQL level 1
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ORA-02063: preceding 4 lines from DBLINK

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms