random ports (again) [message #140694] |
Wed, 05 October 2005 04:37 |
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 #140736 is a reply to message #140694] |
Wed, 05 October 2005 07:34 |
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.
|
|
|
|
|