Issue with connecting to TD using Oracle Database Gateway for Teradata

Third Party Software
Highlighted

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.



 



http://docs.oracle.com/cd/B28359_01/gateways.111/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



 



Error



 



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 11.2.0.1.0 - 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



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?



 



Thanks



Amit