You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Greg Demieville <gr...@pdccorp.com> on 2007/09/12 21:47:53 UTC
Oracle Invalid Login Credentials
We occasionally get 'Access Denied Invalid Login Credentials' when accessing
our application. Stopping and Re-starting Tomcat fixes the issue. We are
using Apache Tomcat 5.0.28/Java JDK 1.5.0.11/Oracle 9.2/JSP pages. Is there
a known issue with Tomcat and Oracle, or do we need to require the Tomcat
service restart as part of a maintenance schedule?
Thank you,
Greg Demieville
Senior Developer
PDC Corp.
Re: Oracle Invalid Login Credentials
Posted by Peter Lombardo <pg...@gmail.com>.
It's possible too that Oracle has hit a limit either on total connections or
the connections for that schema.
To check how many connections exist in oracle via sqlplus: select count(*)
from v$session; Default on 10g is 170 I believe but that is from memory.
A specific ORA code would give more info.
The other option is to get debug output for Oracle login attempts in
Tomcat. Log username/password for every Oracle jdbc login attempt?
Peter Lombardo
On 9/13/07, Greg Demieville <gr...@pdccorp.com> wrote:
>
> >Is it possible that your db connection is being terminated (probably due
> >to inactivity) and that the "invalid login" is a spurious error?
>
> Once the 'Invalid login ' error happens, then everyone else gets the same
> error upon login until Tomcat is re-started.
>
> Which log files would help me determine a JDBC error?
>
> Thank you,
>
> Greg Demieville
>
> -----Original Message-----
> From: Christopher Schultz [mailto:chris@christopherschultz.net]
> Sent: Wednesday, September 12, 2007 3:18 PM
> To: Tomcat Users List
> Subject: Re: Oracle Invalid Login Credentials
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Greg,
>
> Greg Demieville wrote:
> > We occasionally get 'Access Denied Invalid Login Credentials' when
> accessing
> > our application. Stopping and Re-starting Tomcat fixes the issue. We are
> > using Apache Tomcat 5.0.28/Java JDK 1.5.0.11/Oracle 9.2/JSP pages. Is
> there
> > a known issue with Tomcat and Oracle, or do we need to require the
> Tomcat
> > service restart as part of a maintenance schedule?
>
> Is it possible that your db connection is being terminated (probably due
> to inactivity) and that the "invalid login" is a spurious error?
>
> If you are using a Tomcat connection pool (which I highly recommend),
> consider using testOnBorrow and friends to make sure that your DB
> connection is good before you try to use it for things like
> authentication.
>
> (Or, are you getting this error from the Oracle JDBC driver?)
>
> - -chris
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.7 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQFG6EmT9CaO5/Lv0PARAh1AAJ96NOesCJF67tl1cYs5xJoCJSXT5wCghrLt
> 0r5BbE6fjDRX36eYqkdrr30=
> =DfO/
> -----END PGP SIGNATURE-----
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
--
Peter Lombardo
pglombardo@gmail.com
RE: Oracle Invalid Login Credentials
Posted by Greg Demieville <gr...@pdccorp.com>.
>Is it possible that your db connection is being terminated (probably due
>to inactivity) and that the "invalid login" is a spurious error?
Once the 'Invalid login ' error happens, then everyone else gets the same
error upon login until Tomcat is re-started.
Which log files would help me determine a JDBC error?
Thank you,
Greg Demieville
-----Original Message-----
From: Christopher Schultz [mailto:chris@christopherschultz.net]
Sent: Wednesday, September 12, 2007 3:18 PM
To: Tomcat Users List
Subject: Re: Oracle Invalid Login Credentials
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Greg,
Greg Demieville wrote:
> We occasionally get 'Access Denied Invalid Login Credentials' when
accessing
> our application. Stopping and Re-starting Tomcat fixes the issue. We are
> using Apache Tomcat 5.0.28/Java JDK 1.5.0.11/Oracle 9.2/JSP pages. Is
there
> a known issue with Tomcat and Oracle, or do we need to require the Tomcat
> service restart as part of a maintenance schedule?
Is it possible that your db connection is being terminated (probably due
to inactivity) and that the "invalid login" is a spurious error?
If you are using a Tomcat connection pool (which I highly recommend),
consider using testOnBorrow and friends to make sure that your DB
connection is good before you try to use it for things like authentication.
(Or, are you getting this error from the Oracle JDBC driver?)
- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFG6EmT9CaO5/Lv0PARAh1AAJ96NOesCJF67tl1cYs5xJoCJSXT5wCghrLt
0r5BbE6fjDRX36eYqkdrr30=
=DfO/
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Oracle Invalid Login Credentials
Posted by Christopher Schultz <ch...@christopherschultz.net>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Greg,
Greg Demieville wrote:
> We occasionally get 'Access Denied Invalid Login Credentials' when accessing
> our application. Stopping and Re-starting Tomcat fixes the issue. We are
> using Apache Tomcat 5.0.28/Java JDK 1.5.0.11/Oracle 9.2/JSP pages. Is there
> a known issue with Tomcat and Oracle, or do we need to require the Tomcat
> service restart as part of a maintenance schedule?
Is it possible that your db connection is being terminated (probably due
to inactivity) and that the "invalid login" is a spurious error?
If you are using a Tomcat connection pool (which I highly recommend),
consider using testOnBorrow and friends to make sure that your DB
connection is good before you try to use it for things like authentication.
(Or, are you getting this error from the Oracle JDBC driver?)
- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFG6EmT9CaO5/Lv0PARAh1AAJ96NOesCJF67tl1cYs5xJoCJSXT5wCghrLt
0r5BbE6fjDRX36eYqkdrr30=
=DfO/
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org