Home » RDBMS Server » Networking and Gateways » random ports (again)
random ports (again) [message #140694] Wed, 05 October 2005 04:37 Go to next message
N.Hamza
Messages: 2
Registered: October 2005
Junior Member
hello,

first of, yes i have used the search function, but was not able to find something, that solved my problem.

The problem is: we are using an application that accesses an Oracle 8 DB (running on a Windows 2000 Server machine) by making use of the SQL*Net client. The connection needs to go through a firewall, and i am unable to get the SQL*Net client to use only a specific set of ports. It does not matter much which ports are used but the way it works now is, the client opens a connection on port 1521 and a short time later opens another connection on a (seemingly) random port over 3810.
Is there a way to configure the client (server?) to only use one or several ports that don't change every time the connection is established?

The configuration in my TSNNAMES.ORA:



BV7ABBAT.MS.BGNET.DE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.48.201.177)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = bv7abbat)

)
)

Thank you for any suggestion you are willing to contribute,

Nahil Hamza
Re: random ports (again) [message #140729 is a reply to message #140694] Wed, 05 October 2005 07:23 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
What is your Operating system?

[Updated on: Wed, 05 October 2005 07:23]

Report message to a moderator

Re: random ports (again) [message #140736 is a reply to message #140694] Wed, 05 October 2005 07:34 Go to previous messageGo to next message
N.Hamza
Messages: 2
Registered: October 2005
Junior Member
The client uses a Windows XP SP2, the Server is a Windows 2000 Server system. The connection works, as long as it does not need to get by the Firewall so i suspect it is a strict problem of configuring the client and / or the server right. Only catch is i don't know what i have missed with the configuration.
Re: random ports (again) [message #140739 is a reply to message #140736] Wed, 05 October 2005 07:38 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
did you set USE_SHARED_SOCKET to true?
Search the forum for this.
Re: random ports (again) [message #140740 is a reply to message #140739] Wed, 05 October 2005 07:39 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://www.orafaq.com/forum/t/51214/0/
Previous Topic: Solaris 9, 10g network not connecting/object does not exist
Next Topic: connecting to database
Goto Forum:
  


Current Time: Fri Nov 22 08:46:50 CST 2024