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/05/29 00:25:05 UTC
[OT] Oracle Connection Problem Due To Dynamic Port Numbers
Here's a bit from our listener.ora. It appears that the jdbc driver may be
sending a sequential request number as the port, or something like that. Why
isn't it just 1521?
listener.log:04-FEB-2002 16:49:30 *
(CONNECT_DATA=(SID=smoke)(CID=(PROGRAM=)(HOS
T=__jdbc__)(USER=oracle))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.200.11)(PORT=1
506)) * establish * smoke * 0
listener.log:04-FEB-2002 16:49:30 *
(CONNECT_DATA=(SID=smoke)(CID=(PROGRAM=)(HOS
T=__jdbc__)(USER=oracle))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.200.11)(PORT=1
507)) * establish * smoke * 0
The different port numbers seem to be causing a problem with the firewall at
one client site. Any suggestions?
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
Re:Anyone knows how to get the stack trace displayed on Tomcat 4.1.24
Posted by Hassan <hs...@ntlworld.com>.
it is turned on by default on older versions, but since i've started using
this, it only prints RESET on all exceptions.
A stack trace would be helpful for debugging!
Hassan
----- Original Message -----
From: "Tim Funk" <fu...@joedog.org>
To: "Tomcat Users List" <to...@jakarta.apache.org>
Sent: Thursday, May 29, 2003 9:03 PM
Subject: Re: [OT] Oracle Connection Problem Due To Dynamic Port Numbers
> Nope:
> url = jdbc:oracle:thin:@aserver:1521:instance
> ^^^^
> -Tim
>
> Brad Rhoads wrote:
> >>If you use the type 4 driver, then the listener.ora is ignored.
> >
> >
> > Does that mean the requesting port would alway be 1521?
> >
> > Brad Rhoads wrote:
> >
> >>Here's a bit from our listener.ora. It appears that the jdbc driver may
be
> >>sending a sequential request number as the port, or something like that.
> >
> > Why
> >
> >>isn't it just 1521?
> >>
> >>
> >>listener.log:04-FEB-2002 16:49:30 *
> >>(CONNECT_DATA=(SID=smoke)(CID=(PROGRAM=)(HOS
> >>T=__jdbc__)(USER=oracle))) *
> >>(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.200.11)(PORT=1
> >>506)) * establish * smoke * 0
> >>listener.log:04-FEB-2002 16:49:30 *
> >>(CONNECT_DATA=(SID=smoke)(CID=(PROGRAM=)(HOS
> >>T=__jdbc__)(USER=oracle))) *
> >>(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.200.11)(PORT=1
> >>507)) * establish * smoke * 0
> >>
> >>The different port numbers seem to be causing a problem with the
firewall
> >
> > at
> >
> >>one client site. Any suggestions?
> >>
> >>
> >
> >
> >
> > ---------------------------------------------------------------------
> > 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: [OT] Oracle Connection Problem Due To Dynamic Port Numbers
Posted by Tim Funk <fu...@joedog.org>.
Nope:
url = jdbc:oracle:thin:@aserver:1521:instance
^^^^
-Tim
Brad Rhoads wrote:
>>If you use the type 4 driver, then the listener.ora is ignored.
>
>
> Does that mean the requesting port would alway be 1521?
>
> Brad Rhoads wrote:
>
>>Here's a bit from our listener.ora. It appears that the jdbc driver may be
>>sending a sequential request number as the port, or something like that.
>
> Why
>
>>isn't it just 1521?
>>
>>
>>listener.log:04-FEB-2002 16:49:30 *
>>(CONNECT_DATA=(SID=smoke)(CID=(PROGRAM=)(HOS
>>T=__jdbc__)(USER=oracle))) *
>>(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.200.11)(PORT=1
>>506)) * establish * smoke * 0
>>listener.log:04-FEB-2002 16:49:30 *
>>(CONNECT_DATA=(SID=smoke)(CID=(PROGRAM=)(HOS
>>T=__jdbc__)(USER=oracle))) *
>>(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.200.11)(PORT=1
>>507)) * establish * smoke * 0
>>
>>The different port numbers seem to be causing a problem with the firewall
>
> at
>
>>one client site. Any suggestions?
>>
>>
>
>
>
> ---------------------------------------------------------------------
> 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: [OT] Oracle Connection Problem Due To Dynamic Port Numbers
Posted by mike jackson <mj...@cdi-hq.com>.
Not always, but generally. Some DBAs may change the port to something
else, but 1521 is the default.
--mikej
-=------
mike jackson
mjackson@cdi-hq.com
> -----Original Message-----
> From: Brad Rhoads [mailto:brad@zethcon.com]
> Sent: Thursday, May 29, 2003 12:01 PM
> To: Tomcat Users List
> Subject: RE: [OT] Oracle Connection Problem Due To Dynamic Port
Numbers
>
>
> >If you use the type 4 driver, then the listener.ora is ignored.
>
> Does that mean the requesting port would alway be 1521?
>
> Brad Rhoads wrote:
> > Here's a bit from our listener.ora. It appears that the jdbc driver
may
> be
> > sending a sequential request number as the port, or something like
that.
> Why
> > isn't it just 1521?
> >
> >
> > listener.log:04-FEB-2002 16:49:30 *
> > (CONNECT_DATA=(SID=smoke)(CID=(PROGRAM=)(HOS
> > T=__jdbc__)(USER=oracle))) *
> > (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.200.11)(PORT=1
> > 506)) * establish * smoke * 0
> > listener.log:04-FEB-2002 16:49:30 *
> > (CONNECT_DATA=(SID=smoke)(CID=(PROGRAM=)(HOS
> > T=__jdbc__)(USER=oracle))) *
> > (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.200.11)(PORT=1
> > 507)) * establish * smoke * 0
> >
> > The different port numbers seem to be causing a problem with the
> firewall
> at
> > one client site. Any suggestions?
> >
> >
>
>
> ---------------------------------------------------------------------
> 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: [OT] Oracle Connection Problem Due To Dynamic Port Numbers
Posted by Brad Rhoads <br...@zethcon.com>.
>If you use the type 4 driver, then the listener.ora is ignored.
Does that mean the requesting port would alway be 1521?
Brad Rhoads wrote:
> Here's a bit from our listener.ora. It appears that the jdbc driver may be
> sending a sequential request number as the port, or something like that.
Why
> isn't it just 1521?
>
>
> listener.log:04-FEB-2002 16:49:30 *
> (CONNECT_DATA=(SID=smoke)(CID=(PROGRAM=)(HOS
> T=__jdbc__)(USER=oracle))) *
> (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.200.11)(PORT=1
> 506)) * establish * smoke * 0
> listener.log:04-FEB-2002 16:49:30 *
> (CONNECT_DATA=(SID=smoke)(CID=(PROGRAM=)(HOS
> T=__jdbc__)(USER=oracle))) *
> (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.200.11)(PORT=1
> 507)) * establish * smoke * 0
>
> The different port numbers seem to be causing a problem with the firewall
at
> one client site. Any suggestions?
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
Re: [OT] Oracle Connection Problem Due To Dynamic Port Numbers
Posted by Tim Funk <fu...@joedog.org>.
If you use the type 4 driver, then the listener.ora is ignored.
-Tim
Brad Rhoads wrote:
> Here's a bit from our listener.ora. It appears that the jdbc driver may be
> sending a sequential request number as the port, or something like that. Why
> isn't it just 1521?
>
>
> listener.log:04-FEB-2002 16:49:30 *
> (CONNECT_DATA=(SID=smoke)(CID=(PROGRAM=)(HOS
> T=__jdbc__)(USER=oracle))) *
> (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.200.11)(PORT=1
> 506)) * establish * smoke * 0
> listener.log:04-FEB-2002 16:49:30 *
> (CONNECT_DATA=(SID=smoke)(CID=(PROGRAM=)(HOS
> T=__jdbc__)(USER=oracle))) *
> (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.200.11)(PORT=1
> 507)) * establish * smoke * 0
>
> The different port numbers seem to be causing a problem with the firewall at
> one client site. Any suggestions?
>
>
> ---------------------------------------------------------------------
> 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: [OT] Oracle Connection Problem Due To Dynamic Port Numbers
Posted by mike jackson <mj...@cdi-hq.com>.
Oracle listens on one port. It then tells you to connect to another and
that's where it actually does the work from. Also, if you're running
through a NAT or a proxy you're not going to be able to talk to Oracle
through it unless you have a SQL*Net proxy built into the NAT box or
proxy (and even then I'm not sure that proxies work anyway). I'd see if
you can connect using the standard Oracle tools, if you can't get that
setup then you're not going to get JDBC to work.
--mikej
-=------
mike jackson
mjackson@cdi-hq.com
> -----Original Message-----
> From: Brad Rhoads [mailto:brad@zethcon.com]
> Sent: Wednesday, May 28, 2003 2:25 PM
> To: tomcat-user@jakarta.apache.org
> Subject: [OT] Oracle Connection Problem Due To Dynamic Port Numbers
>
> Here's a bit from our listener.ora. It appears that the jdbc driver
may be
> sending a sequential request number as the port, or something like
that.
> Why
> isn't it just 1521?
>
>
> listener.log:04-FEB-2002 16:49:30 *
> (CONNECT_DATA=(SID=smoke)(CID=(PROGRAM=)(HOS
> T=__jdbc__)(USER=oracle))) *
> (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.200.11)(PORT=1
> 506)) * establish * smoke * 0
> listener.log:04-FEB-2002 16:49:30 *
> (CONNECT_DATA=(SID=smoke)(CID=(PROGRAM=)(HOS
> T=__jdbc__)(USER=oracle))) *
> (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.200.11)(PORT=1
> 507)) * establish * smoke * 0
>
> The different port numbers seem to be causing a problem with the
firewall
> at
> one client site. Any suggestions?
>
>
> ---------------------------------------------------------------------
> 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