Hi, I am trying to connect directly to FS online database but I falied.
FORMSPIDER = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = fsdb.formspideronline.com)(PORT = 1521)) ) (CONNECT_DATA = (SID = awsdb) ) )
I got this output when I tried tnsping or ping.
TNS Ping Utility for 32-bit Windows: Version 220.127.116.11.0 - Production on 15-JUL-2013 14:17:22
Copyright (c) 1997, 2011, Oracle. All rights reserved.
Used parameter files: C:\Oracle\product\11.2.0\client_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = fsdb.formspideronline.com)(PORT = 1521))) (CONNECT_DATA = (SID = awsdb))) TNS-12535: TNS:operation timed out
Pinging fsdb.formspideronline.com [18.104.22.168] with 32 bytes of data: Request timed out. Request timed out. Request timed out. Request timed out.
Ping statistics for 22.214.171.124: Packets: Sent = 4, Received = 0, Lost = 4 (100% loss),
Could you tell mi pls what ports shoul be opened on firewall to be able to establish a connection do DB using PLSQL Developer od Oracle SQL Developer?
Thank you in advance, Vojto
asked 15 Jul '13, 08:29
You cannot ping fsdb.formspideronline.com. We only opened 1521 port to reach this database. Did you try to connect with Oracle SQL Developer without using TNS names?
answered 15 Jul '13, 10:12
Problem solved. :) I asked our security staff to open port 1521 to fsdb DB server. Now the connection is established.
Thank you. Regards, Vojto
answered 15 Jul '13, 11:23