There was a config option to stop this and make oracle just use 1521 that I used a couple years back for this very purpose...
Here's a discussion about how the problem and how to get oracle to just use a single port: http://www.stunnel.org/examples/oracle.html -gabe -----Original Message----- From: Tim Funk [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 8:01 AM To: Tomcat Users List Subject: Re: Why does Oracle in JSP uses multiple ports. I have just learned that the thin driver uses 1521 to begin the conversation. But that is just a handshake. The handshake then says - "Let's finish the rest of our work on another higher port" where the higher port is a range of ports. So you need a whole range of ports open. :( -Tim Brad Rhoads wrote: > My client had to open port 1521 between the webserver and Oracle DB server. > This makes sense. But he also had to open port 33047 for our application > pointing to the test SID and 40147 for the copy of the app pointing to the > prod SID. Both ProdApp and TestApp are exactly the same except for the > Oracle SID. > > Here's part of the log from their Check Point firewall (before they opened > up these other ports): > > service sqlnet2-1521 is port 1521 > service WebServer is port 40147 > > > Number Date Time Action Service Source Destination Protocol > 45488 5Jun2003 8:30:17 Accept sqlnet2-1521 WebServer synapse.berlinind tcp > 45489 5Jun2003 8:30:17 Drop SynapseWeb WebServer synapse.berlinind tcp > 45708 5Jun2003 8:31:50 Drop SynapseWeb WebServer synapse.berlinind tcp > > > Every SQL request sent through one 1521 which was accepted, and 2 40147s > which were dropped. > > Can anyone explain this? > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
