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
  • 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

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Question has a verified solution.

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

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

579 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