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

asked 15 Jul '13, 08:29

vojto's gravatar image

vojto
94
accept rate: 0%


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

link

answered 15 Jul '13, 10:12

Samet%20Basaran's gravatar image

Samet Basaran
1372
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

link

answered 15 Jul '13, 11:23

vojto's gravatar image

vojto
94
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

By RSS:

Answers

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

Tags:

×5

Asked: 15 Jul '13, 08:29

Seen: 1,161 times

Last updated: 15 Jul '13, 11:23


© Copyright Gerger 2017