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.

 

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

You must sign in to leave a comment.