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 - 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 [] with 32 bytes of data: Request timed out. Request timed out. Request timed out. Request timed out.

Ping statistics for 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

vojto's gravatar image

accept rate: 0%


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


answered 15 Jul '13, 10:12

Samet%20Basaran's gravatar image

Samet Basaran
accept rate: 24%

Hi Samet,

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

vojto's gravatar image

accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 15 Jul '13, 08:29

Seen: 2,354 times

Last updated: 15 Jul '13, 11:23

© Copyright Gerger 2017