I originally thought that was the exact issue. If you look at the listener.log, the "new" port# is random. In fact even the rang of numbers appears to be different on our different servers.
In spite of this, we're getting ports 33047 & 40147 consistantly; it appears to be somehow be a function of the sid. We have restarted Tomcat many times now and everything is working OK. I guess we should restart the box and see if it still works. Any other ideas or explanations? -----Original Message----- From: Tim Funk [mailto:[EMAIL PROTECTED] Sent: Monday, June 09, 2003 10: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]