My Oracle Support Banner

Select Using DG4Teradata Gives Error Ora-28500 (Doc ID 1272943.1)

Last updated on SEPTEMBER 20, 2019

Applies to:

Oracle Database Gateway for Teradata - Version to [Release 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/


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.