Check out this newsgroup post, seems to explain it pretty well: http://tinyurl.com/dujx
Regards, -- Jason Bainbridge http://jblinux.org On Mon, 9 Jun 2003 23:17, Brad Rhoads wrote: > 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. >-- Jason Bainbridge http://jblinux.org > > 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]