All Forums Third Party Software
amitbajpai 3 posts Joined 06/12
12 Jun 2012
Issue with connecting to TD using Oracle Database Gateway for Teradata

I tried to connect TD from Oracle using the Oracle Database Gateway for Teradata. I followed the steps mentioned in the below link. b31043/conf_teradata.htm#CIAFCCAC


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 - Production on 12-JUN-2

012 13:22:40


Copyright (c) 1997, 2010, Oracle.  All rights reserved.


Used parameter files:

C:\app\gdlabajp\product\11.2.0\dbhome_2\NETWORK\ADMIN\ sqlnet.ora



Used TNSNAMES adapter to resolve the alias


(HOST = = 5521))) ( CONNECT_DATA = (S

ID = dg4tera)) (HS=OK))

OK (110 msec)


Can someone help me in fixing the issue?




You must sign in to leave a comment.