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: 11.1.0.6 to 11.1.0.7 - Release: 11.1 to 11.1
Information in this document applies to any platform.

Symptoms


The Oracle database and Database Gateway for Teradata (DG4Teradata) are installed on RED Hat Linux.
 
The gateway version is 11.1.0.7 + 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/libHGicu22.so"
Entered hgolofns at 2010/12/06-16:04:58
hoaerr:28500
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/libodbcinst.so(SQLGetPrivateProfileString)

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