You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Sharath Babu S S S <Sh...@solix.com> on 2009/09/18 04:22:13 UTC
Maximum Number of processes Exceeded
Hi,
We are using Tomcat Server and oracle database. After running for a while we are getting this error in the log files.
Its taking both inactive and active processess. how to remove the inactive processess so that we dont have this error.
Debug: makeConnection(Database)
java.sql.SQLException: ORA-00020: maximum number of processes (300) exceeded
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)
at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOsesskey(T4CTTIoauthenticate.java:294)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:357)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:439)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
at org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:974)
at org.apache.tomcat.dbcp.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:84)
at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at utils.ConnectionBroker.makeConnection(ConnectionBroker.java:256)
at utils.ConnectionBroker.makeConnection(ConnectionBroker.java:76)
at beans.PurgeProcess_T.run(PurgeProcess_T.java:166)
With Regards............
Sharat Babu Shravanam
--------------------------------------------------------------------
Byte and Switch Names Solix Technologies
One of the Top 10 Startups to Watch
Read More at http://www.solix.com/top10startups
---------------------------------------------------------------------
**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
solely for the use of the addressee(s). If you are not the intended
recipient, please notify the sender by e-mail and delete the original
message. Further, you are not to copy, disclose, or distribute this
e-mail or its contents to any other person and any such actions are
unlawful. This e-mail may contain viruses. Solix has taken every
reasonable precaution to minimize this risk, but is not liable for any
damage you may sustain as a result of any virus in this e-mail. You
should carry out your own virus checks before opening the e-mail or
attachment. Solix reserves the right to monitor and review the content
of all messages sent to or from this e-mail address. Messages sent to or
from this e-mail address may be stored on the Solix e-mail system.
****End of Disclaimer **********************************
Re: Maximum Number of processes Exceeded
Posted by Jason Brittain <ja...@gmail.com>.
Hi Sharath.
Can you tell us more about your environment? For example:
- Your operating system brand and version.
- Your Tomcat version, where you initially got it, how you installed it.
- Your Java VM brand and version, and whether it is a JRE or JDK.
- Your Oracle version.
- Your Oracle JDBC driver version, where you got it, how you installed it.
Please give us as much of the above information as you can.
Thanks.
--
Jason Brittain
On Thu, Sep 17, 2009 at 7:22 PM, Sharath Babu S S S
<Sh...@solix.com>wrote:
>
> Hi,
>
> We are using Tomcat Server and oracle database. After running for a while
> we are getting this error in the log files.
> Its taking both inactive and active processess. how to remove the
> inactive processess so that we dont have this error.
>
> Debug: makeConnection(Database)
>
> java.sql.SQLException: ORA-00020: maximum number of processes (300)
> exceeded
>
>
>
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
>
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)
>
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)
>
> at
> oracle.jdbc.driver.T4CTTIoauthenticate.receiveOsesskey(T4CTTIoauthenticate.java:294)
>
> at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:357)
>
> at
> oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:439)
>
> at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
>
> at
> oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
>
> at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
>
> at
> org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
>
> at
> org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
>
> at
> org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:974)
>
> at
> org.apache.tomcat.dbcp.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:84)
>
> at
> org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:96)
>
> at
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
>
> at utils.ConnectionBroker.makeConnection(ConnectionBroker.java:256)
>
> at utils.ConnectionBroker.makeConnection(ConnectionBroker.java:76)
>
> at beans.PurgeProcess_T.run(PurgeProcess_T.java:166)
>
>
> With Regards............
> Sharat Babu Shravanam
>
>
RE: Maximum Number of processes Exceeded
Posted by George Sexton <ge...@mhsoftware.com>.
Most likely, you're leaking connection handles or result sets.
A common error is storing them on the session. When the session times out
they are not necessarily garbage collected.
George Sexton
MH Software, Inc.
http://www.mhsoftware.com/
Voice: 303 438 9585
> -----Original Message-----
> From: Sharath Babu S S S [mailto:Sharath.Babu@solix.com]
> Sent: Thursday, September 17, 2009 8:22 PM
> To: Tomcat Users List
> Subject: Maximum Number of processes Exceeded
>
>
> Hi,
>
> We are using Tomcat Server and oracle database. After running for a
> while we are getting this error in the log files.
> Its taking both inactive and active processess. how to remove the
> inactive processess so that we dont have this error.
>
> Debug: makeConnection(Database)
>
> java.sql.SQLException: ORA-00020: maximum number of processes (300)
> exceeded
>
>
>
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:1
> 12)
>
> at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
>
> at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)
>
> at
> oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)
>
> at
> oracle.jdbc.driver.T4CTTIoauthenticate.receiveOsesskey(T4CTTIoauthentic
> ate.java:294)
>
> at
> oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:357)
>
> at
> oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:43
> 9)
>
> at
> oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
>
> at
> oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.
> java:35)
>
> at
> oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
>
> at
> org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(Dr
> iverConnectionFactory.java:38)
>
> at
> org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(Poolab
> leConnectionFactory.java:294)
>
> at
> org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(Generic
> ObjectPool.java:974)
>
> at
> org.apache.tomcat.dbcp.dbcp.AbandonedObjectPool.borrowObject(AbandonedO
> bjectPool.java:84)
>
> at
> org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingData
> Source.java:96)
>
> at
> org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSour
> ce.java:880)
>
> at
> utils.ConnectionBroker.makeConnection(ConnectionBroker.java:256)
>
> at
> utils.ConnectionBroker.makeConnection(ConnectionBroker.java:76)
>
> at beans.PurgeProcess_T.run(PurgeProcess_T.java:166)
>
>
>
>
>
>
> With Regards............
> Sharat Babu Shravanam
>
>
>
> --------------------------------------------------------------------
> Byte and Switch Names Solix Technologies
> One of the Top 10 Startups to Watch
>
> Read More at http://www.solix.com/top10startups
> ---------------------------------------------------------------------
>
>
>
>
>
>
>
> **************** CAUTION - Disclaimer *****************
>
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
> solely for the use of the addressee(s). If you are not the intended
> recipient, please notify the sender by e-mail and delete the original
> message. Further, you are not to copy, disclose, or distribute this
> e-mail or its contents to any other person and any such actions are
> unlawful. This e-mail may contain viruses. Solix has taken every
> reasonable precaution to minimize this risk, but is not liable for any
> damage you may sustain as a result of any virus in this e-mail. You
> should carry out your own virus checks before opening the e-mail or
> attachment. Solix reserves the right to monitor and review the content
> of all messages sent to or from this e-mail address. Messages sent to
> or
> from this e-mail address may be stored on the Solix e-mail system.
>
>
> ****End of Disclaimer **********************************
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org