8 Replies Latest reply: Feb 1, 2013 10:38 AM by 937454 RSS

    DBLINKS and Firewall

    937454
      Hi,

      DB version of A, B:
      Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

      Two databases A, B are residing on two different servers S1 and S2 respectively.
      I have to access a table that is in Database B from Database A.
      So, I created a dblink on A to access B.
      CREATE DATABASE LINK "DBLINK_TEST"
       CONNECT TO databaseB
       IDENTIFIED BY <PWD>
       USING '(DESCRIPTION =
          (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST =abcd.com )(PORT = 1521))
          )
          (CONNECT_DATA =
            (SID = xyz)
          )
        )';
      Also I can do
       
      SQL> conn db1/password1@databaseA
      Connected.
      SQL> conn db2/password2@databaseB
      Connected.
      SQL> conn db1/password1@databaseA
      Connected
      So I assume network configurations are in place.
      But when I do
      SELECT * FROM DUAL@DBLINK_TEST
      I get an error
      ORA-12170: TNS:Connect timeout occurred
      Do I need to open firewall between S1 and S2 for the dblink to work. As of now they are not opened.
      Or is there something else I am missing.
      Please advice.