Select Using DG4Teradata Gives Error Ora-28500

(Doc ID 1272943.1)

Last updated on DECEMBER 23, 2010

Applies to:

Oracle Database Gateway for Teradata - Version: to - Release: 11.1 to 11.1
Information in this document applies to any platform.


The Oracle database and Database Gateway for Teradata (DG4Teradata) are installed on RED Hat Linux.
The gateway version is + 7565834 and Teradata is  version12

A select using the gateway gives the following error -

select * from dual@database link received
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:

A gateway debug trace file shows -

LD_LIBRARY_PATH from environment is "/u01/app/oracle/product/11.1.0/tg_1/lib32:/u01/app/oracle/product/11.1.0/tg_1/dg4tera/driver/lib32:/usr/lib/:/opt/teradata/tdicu/lib"
Setting LD_LIBRARY_PATH to "/u01/app/oracle/product/11.1.0/tg_1/dg4tera/driver/lib:/u01/app/oracle/product/11.1.0/tg_1/lib32:/u01/app/oracle/product/11.1.0/tg_1/dg4tera/driver/lib32:/usr/lib/:/opt/teradata/tdicu/lib"
HOSGIP for "HS_FDS_SHAREABLE_NAME_ICU" returned "/u01/app/oracle/product/11.1.0/tg_1/dg4tera/driver/lib/"
Entered hgolofns at 2010/12/06-16:04:58
Exiting hgolofns at 2010/12/07-11:06:36
Failed to load ODBC library symbol: /u01/app/oracle/product/11.1.0/tg_1/dg4tera/driver/lib/


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