3 Replies Latest reply on Oct 16, 2019 6:57 PM by L. Fernigrini

    oracle dblink to dba2 Express-C

    7dedb4d9-53cf-41c7-87c6-b36db56ccaf7

      Hi everyone.

       

      I have in the first computer, Windows Server 2012 R2 with Oracle 11g, and also I have in the second computer Ubuntu Server 16.04 with DB2 Express-C. I would like to connect oracle 11g database to DB2 Express-C database using DBLINK, however I have in the file "tnsnames.ora" the next sentence.

       

      DB2_HS =

      (DESCRIPTION =

      (ADDRESS =

        (PROTOCOL = TCP)

        (HOST = DB2Host)

        (PORT = 50000)

      )

      (CONNECT_DATA =

      (SID = DB2_HS)

      )

      (HS = OK)

      )

       

      And  when I write in the command prompt "tnsping DB2_HS", it gives me the next error.

       

      TNS-12537: TNS: Connection closed.

       

      Can you help me with this problem? there is a tutorial step by step updated? Thank you in advance.