Re: Why does Oracle in JSP uses multiple ports.

[Tim Funk]

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]