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 <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] > 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > To start a new topic, e-mail: users@tomcat.apache.org > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- Peter Lombardo [EMAIL PROTECTED]
