Setting up Gateway to Teradata

From: Thomas Day <tomdaytwo@xxxxxxxxx>
To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 14 Feb 2013 11:32:25 -0500

I've been reading the wonderful manual,
http://docs.oracle.com/cd/E11882_01/gateways.112/e12061.pdf, 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:
SQL> SELECT * FROM DUAL@TERADATA;
SELECT * FROM DUAL@TERADATA
                   *
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

  (SID_DESC=
         (SID_NAME=dg4tera)
         (ORACLE_HOME=C:\oracle\product\11.2.0\tg_1)
         (PROGRAM=dg4tera)

 
(ENVS=PATH=C:\oracle\product\11.2.0\tg_1\bin;C:\oracle\product\11.2.0\tg_1\dg4tera\driver\lib;C:\oracle\product\11.2.0\tg_1\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\)
      )

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
'(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=VMGATEWAY)(PORT=1521))(CONNECT_DATA=(SID=dg4tera))(HS=OK))';

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.


--
//www.freelists.org/webpage/oracle-l

Setting up Gateway to Teradata

Other related posts: