Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle & jdbc application

Re: Oracle & jdbc application

From: Peter Sylvester <peters_no_spam_please_at_mitre.org>
Date: Mon, 24 May 2004 17:47:32 -0400
Message-ID: <c8tqhk$5mj$1@newslocal.mitre.org>


Fra wrote:
> Hi, I have a problem with my Java application (and with my English!). I use
> a third-part set of clesses that offers a pool of connection (created with
> DriverManager.getConnection method and using jdbc oracle driver -
> oracle.jar). I use this application in a remote host connected with a Oracle
> DB on a Linux server. The problem is that if I run multiple client, the
> available connection to DB ends, and all other program can't access to DB
> from any host in my network, generating deadlock for all application that
> try to connect to DB, not only my application!!). The number of connection
> is 20-30, not much for my system!! How I can increase this parameter? The
> problem is in the "init.ora" file? (session or processes property) ...or I
> have to configure something in S.O.? Thanks to all!
>
>

Try cranking up your "processes" parameter in initSID.ora. You'll need to restart the listener and/or the database server.

--Peter Received on Mon May 24 2004 - 16:47:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US