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

Last updated on FEBRUARY 15, 2023

Applies to:

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

	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

Symptoms

Cause

Solution

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

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

Applies to:

Symptoms

Cause

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

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