OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » random ports (again)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: random ports (again) [message #140729 is a reply to message #140694]

Wed, 05 October 2005 07:23

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

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.

Report message to a moderator