Setting up Gateway to Teradata

From: Thomas Day <tomdaytwo_at_gmail.com>
Date: Thu, 14 Feb 2013 11:32:25 -0500
Message-ID: <CAMa2=-d+mq2oMBdtpMOD1t2T0MVXL73J4JCQeiJHybpo1Kh7Vw_at_mail.gmail.com>

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_at_TERADATA;
SELECT * FROM DUAL_at_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.

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

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