OraFAQ Forum: Server Administration » how to get a fixed port for the connections to a server in windows

Home » RDBMS Server » Server Administration » how to get a fixed port for the connections to a server in windows

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

how to get a fixed port for the connections to a server in windows [message #58696]

Fri, 26 September 2003 02:43

Teo
Messages: 2
Registered: September 2003

Junior Member

Hi all!

We are having a problem with ports when connecting to an Oracle database running on a W2000 system. When you connect to it with SQLplus it connects with port 1521, but then it does the communications through another port. This is a big issue when configuring firewalls.
I'm asking this to you because we are running more Oracle database on AIX systems and these only use 1521 port, so there are no problems with firewalls.
The question is "is there any way to fix the port used on windows systems?" or almost the same "can I avoid the use of different ports than 1521 when connecting to Oracle on Windows?"

Thanks in advance.

Report message to a moderator

Re: how to get a fixed port for the connections to a server in windows [message #58701 is a reply to message #58696]

Fri, 26 September 2003 06:14

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

This is windows registry paramter.
set the following in the windows registry.
reboot the machine. Now the the port redirections will be handled.

USE_SHARED_SOCKET=TRUE

Report message to a moderator

Re: how to get a fixed port for the connections to a server in windows [message #58734 is a reply to message #58701]

Mon, 29 September 2003 01:10

Teo
Messages: 2
Registered: September 2003

Junior Member

Many thanks to Mahesh Rajendran, your help has been much appreciated.

Report message to a moderator

Previous Topic:	Formatting query result set.
Next Topic:	Need Help - processes exceeding

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 29 12:59:06 CST 2025