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?
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.