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. C:\Windows\system32>tnsping formspider TNS Ping Utility for 32-bit Windows: Version 11.2.0.3.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 C:\Windows\system32>ping fsdb.formspideronline.com Pinging fsdb.formspideronline.com [23.21.241.63] with 32 bytes of data: Request timed out. Request timed out. Request timed out. Request timed out. Ping statistics for 23.21.241.63: Packets: Sent = 4, Received = 0, Lost = 4 (100% loss), C:\Windows\system32> 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 |
Hi, 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? Regards, Samet |