Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Received-SPF: pass (athena.apache.org: local policy)
Content-Class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/mixed;
	boundary="----_=_NextPart_001_01CA3807.2EC746FE"
Subject: Maximum Number of processes Exceeded
Date: Thu, 17 Sep 2009 19:22:13 -0700
Message-ID: <4D877437D7822D4D8285CFA3022E87310273E5D3@VAISHNAV.solix.com>
Thread-Topic: Maximum Number of processes Exceeded
thread-index: Aco24YYo6O3SRXpySF6lJQ+eJT6gbwBJU93B
References: 
 <4D877437D7822D4D8285CFA3022E87310273E5CE@VAISHNAV.solix.com><610099.94183.qm@web28607.mail.ukl.yahoo.com>
 <f0b225240909160821j11b3de51yb59011abb5930a01@mail.gmail.com>
From: "Sharath Babu S S S" <Sharath.Babu@solix.com>
To: "Tomcat Users List" <users@tomcat.apache.org>

------_=_NextPart_001_01CA3807.2EC746FE
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

=20
Hi,
=20
   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.
=20
Debug: makeConnection(Database)

java.sql.SQLException: ORA-00020: maximum number of processes (300) =
exceeded

=20

        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(T4CTTIoauthenticat=
e.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.ja=
va:35)

        at =
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)

        at =
org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(Driv=
erConnectionFactory.java:38)

        at =
org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(Poolable=
ConnectionFactory.java:294)

        at =
org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(GenericOb=
jectPool.java:974)

        at =
org.apache.tomcat.dbcp.dbcp.AbandonedObjectPool.borrowObject(AbandonedObj=
ectPool.java:84)

        at =
org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSo=
urce.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)


=20
=20
With Regards............
Sharat Babu Shravanam

=20

--------------------------------------------------------------------
Byte and Switch Names Solix Technologies=20
One of the Top 10 Startups to Watch
=20
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 **********************************


------_=_NextPart_001_01CA3807.2EC746FE
Content-Type: text/plain; charset=us-ascii


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
------_=_NextPart_001_01CA3807.2EC746FE--