Originally posted by jmodic
If multithreaded configuration of the database is acceptable for your application, then you can "fix" the port number through which connection will be established. In other words, database will establish the connection with the client through the same port through which the client contacted the listener. So you don't realy need a CMAN nor the use_shared_socket =TRUE.

An example of MTS_DISPATCHERS parameter with "fixed" port 1521 in your init.ora would be something like:

mts_dispatchers="(address=(protocol=tcp)(host=hostname)(port=1521))(dispatchers=1)"
I'm not firewall-tastic but won't this open up a whole in the firewall for that port regardless of who the client is? This is no more secure than accepting any TCP request through that port.

Assuming I'm correct, this doesn't affect the need for a static client IP address or password authentication on the firewall.

I'm way out of my depth now