HS_NLS_NCHAR Value AL32UTF8 Causes ORA-28511 Using DG4MSQL (Doc ID 1305414.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database Gateway for SQL Server - Version 11.1.0.6 to 11.2.0.2 [Release 11.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 03-Sept-2012***

Symptoms

A connection using Database Gateway for SQL*Server (DG4MSQL) v11.1.0.6 may fail with errors:

select * from sys.objects@dblink;
*
ERROR at line 1:
ORA-02068: following severe error from DBLINK
ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxx.yyyy.zzzz)(PORT=151
1)))(CONNECT_DATA=(SID=dg4msql)))


In a gateway trace file the following errors are reported:

Oracle Corporation --- FRIDAY MAR 11 2011 16:36:02.066


Heterogeneous Agent Release
11.1.0.6.0


Invalid HS_NLS_NCHAR value AL32UTF8 specified
Setting HS_NLS_NCHAR to Server Default 2000
Invalid HS_NLS_NCHAR value AL32UTF8 specified
Setting HS_NLS_NCHAR to Server Default 2000



Changes

This is a new install, a formerly working environment after maintenance or Oracle products are installed.

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