I understand that Windows does port redirection which can be troublesome when going through a firewall.
I'm using Apache Tomcat on Linux which goes through a Checkpoint firewall to get to Oracle on Windows 2000. What I understand is that when the webserver makes a SQL request via JDBC on port 1521 to Oracle, Windows replies back on a random port number different from 1521 and so it can't get through the firewall. So in order to just open up 1521 through the firewall, there are 3 possible solutions? Can people who are using Oracle on Windows with Tomcat tell me which one you are using? 1) Use the firewall's ability (if supported) to allow for oracle connectivity with OS port redirection. I understand that if the firewall software supports this (or if it can be upgraded to do so), it is the best solution to follow? 2) Use Oracle's Connection Manager (CMAN) feature 3) Set USE_SHARED_SOCKET = TRUE in the registry of the Oracle server. This will allow the OS to share port 1521 and clients will then stay on 1521 when connecting to the database and will not be port redirected. A downfall of this option is all connections will stay on the listener port and if the listener is stopped or restarted all the connections will be severed from the database. Thanks, Neil --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
