prevent dynamic port allocation in dedicated server configuration

Posted on 2003-03-24
Medium Priority
Last Modified: 2013-12-11
I have an Oracle 8i database running in Dedicated server configuration. The issue i am facing with this configuration is that the ports being used for client communication are dynamically allocated which prevents implementation of a firewall to limit the ports being made available for communication.

I am interested to know if i can force a set of ports to be used everytime by the server porcesses? I know if i have MTS configuration then i can assign the ports to be used while defining the dispatchers in initsid.ora. But can i do something similar in dedicated server environment.

Just curious, can prespawned server processes help in this regard?

Thanks in advance!

Question by:amal_rakshit
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2

Expert Comment

ID: 8206831
Have a look at Connection Manager in the Net8 docs.

Alternatively, you can set USE_SHARED_SOCKET=TRUE in the registry (HKLM\Software\Oracle\Home<n>) or as a system environment parameter.
This will force all new connections to spawn a new thread on the listening port.

What OS are you using? How may concurrent connections are you expecting?


Author Comment

ID: 8208224
Thanks BobMc!

I am aware of the Connection manager option but want to explore other ways of achieving this.

I need further clarification on the second option you suggested. Do you mean to say that all new connections will be spawned as threads on the same port as that of the Listener (for eg: 1521)? Hence I do not need other ports to be opened for client connections?

We have NT as the OS. I am sorry I did not mention it earlier. Also, we expect about 100 concurrent connections.



Accepted Solution

BobMc earned 1500 total points
ID: 8219610

All connections would be on the same port - 1521 in this case. So you wouldn't need to open up additional ports for the clients.

To be honest, Im not sure how far this solution would scale, but if 100 concurrent users was a problem, you could always add multiple listener ports (1521, 1522, etc) and spread the addresses about your clients.

I have also heard of Sqlnet proxies (I think its built into the firewall) but I have no information at hand about this and everyone else has gone home!



Author Comment

ID: 8274821
Thanks once again Bob!

I think the USE_SHARE_SOCKET parameter is the solution for our requirements.


Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question