I tried to connect TD from Oracle using the Oracle Database Gateway for Teradata. I followed the steps mentioned in the below link.
Oracle DB: I installed a test Oracle DB (Oracle 11gR2) on my laptop
Teradata – TD express setup on a remote machine
Oracle Database Gateway for Teradata – I installed on my laptop
SQL> select * from dbcinfo@GFLEXTD;
select * from dbcinfo@GFLEXTD
ERROR at line 1:
ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: preceding 2 lines from GFLEXTD
TNSPING is working.
C:\Documents and Settings\gdlabajp>tnsping GatewayFlexTD
TNS Ping Utility for 32-bit Windows: Version 220.127.116.11.0 - Production on 12-JUN-2
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = gdlm8749.americas.ad.flextronics.com)(PORT = 5521))) ( CONNECT_DATA = (S
ID = dg4tera)) (HS=OK))
OK (110 msec)
Can someone help me in fixing the issue?