Setting up Gateway to Teradata

From: Thomas Day <>
Date: Thu, 14 Feb 2013 11:32:25 -0500
Message-ID: <>

I've been reading the wonderful manual,, and was able to set up a gateway to sql server without too much difficulty but Teradata has me stumped. I've followed the doc religiously but my database link still produces:

ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
Specified driver could not be loaded due to system error 126: The specified module could not be found. (Oracle 11g dg4tera-OraGtw11g_home1, C:\oracle\product\11.2.0\tg_1\dg4tera\driver\lib\HGtera23.dll). {IM003,NativeErr = 160}
ORA-02063: preceding 2 lines from TERADATA

This is Oracle 11.2 on windows server 2008 R2. I'm setting up the gateway on its own server, not shared with a database. The listener entry looks like




I can TNSPING the gateway fine but the database link won't work.

The database link is;

create public database link somelink connect to terauser identified by password using

Any clues as to what I'm doing wrong (besides using Windows -- I have no control over that) would be greatly appreciated. Thanks in advance.

Received on Thu Feb 14 2013 - 17:32:25 CET

Original text of this message