This discussion is archived
8 Replies Latest reply: Feb 1, 2013 8:38 AM by 937454 RSS

DBLINKS and Firewall

937454 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points