asked on

prevent dynamic port allocation in dedicated server configuration

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!

Amal

BobMc

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?

HTH
Bob

amal_rakshit

ASKER

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.

regards
Amal

ASKER CERTIFIED SOLUTION

BobMc

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

amal_rakshit

ASKER

Thanks once again Bob!

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

regards,
Amal