You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Brad Rhoads <br...@zethcon.com> on 2003/06/09 16:57:31 UTC
Why does Oracle in JSP uses multiple ports.
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: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
Re: Why does Oracle in JSP uses multiple ports.
Posted by Jason Bainbridge <ja...@jblinux.org>.
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:funkman@joedog.org]
> 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: tomcat-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
RE: Why does Oracle in JSP uses multiple ports.
Posted by Brad Rhoads <br...@zethcon.com>.
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:funkman@joedog.org]
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: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
Re: Why does Oracle in JSP uses multiple ports.
Posted by Tim Funk <fu...@joedog.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: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org