ORA-28513 Connecting From Oracle To SQL*Server Using DG4ODBC

(Doc ID 1928926.1)

Last updated on JANUARY 19, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

The following errors are shown in SQLPLUS using a fresh install of the Database Gateay for ODBC (DG4ODBC) v 11.2.0.3 to connect to SQL*Server -

SQL> select * from dual@hslink;
select * from dual@hslink
                  *
ERROR at line 1:
ORA-28513: internal error in heterogeneous remote agent
ORA-02063: preceding line from HSLINK

 

A gateway trace shows the following -

Exiting hgogprd, rc=0
Invalid HS_NLS_NCHAR value AMERICAN_AMERICA.US7ASCII specified
Setting HS_NLS_NCHAR to Server Default 2000
Invalid HS_NLS_NCHAR value AMERICAN_AMERICA.US7ASCII specified
Setting HS_NLS_NCHAR to Server Default 2000
Entered hgoinit
HOCXU_COMP_CSET=1
HOCXU_DRV_CSET=1
HOCXU_DRV_NCHAR=2000
HOCXU_DB_CSET=873
HS_LANGUAGE is AMERICAN_AMERICA.US7ASCII
LANG=en_US.UTF-8
HOCXU_SEM_VER=112000
Exiting hgoinit, rc=28513
Entered hgoexit
HS Gateway:  NULL connection context at exit
Exiting hgoexit, rc=0 with error ptr FILE:hgoexit.c LINE:110 FUNCTION:hgoexit() ID:Connection context

 

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