使用DG4ODBC连接到Postgresql 数据库时报ORA-28500

ORA-28500: Connection From ORACLE To A Non-Oracle System Returned This Message: C (文档 ID 2325424.1)

APPLIES TO:

Oracle Database - Standard Edition - Version 11.2.0.1 to 12.2.0.1 [Release 11.2 to 12.2]
Information in this document applies to any platform.

SYMPTOMS

When using Database Gateway for ODBC (DG4ODBC) to connect to a Postgresql database using a Postgres ODBC connection the following error is encountered:

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
c
 

CAUSE

The issue is caused by a problem with character and language settings.
 

SOLUTION

Add the following to the DG4ODBC init.ora file:

HS_NLS_NCHAR=UCS2
HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P1