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 <sharath.b...@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 > >