Dear Gurus,
We are getting the following error if we try to create more than 256 connections from
the same client. The problem is easily reproducible bt writing simple java program and
keep creating connections(do not close it).
Did anyone encounter this kind of issue and how did you solve it?
What is the setting for processes in the database? What is your per-process-file
descriptor limit?
If you are on Solaris following may apply to you ...
Solaris only
Problem Description
---
You have a JDBC program connecting to the database. This program may run standalone
or
Anytime you see a number like 256 it is likely you are hitting some limit.
My guess is you are running out of memory in your application on that
client.
If you are trying to open that many connections from a single client you
should start to look at connection manager to pool these connections
Hmm...my first thought is that this could be an OS/network configuration limitation on
the client side? Though it does seem odd to raise an ORA-12154, after many successful
connections
What OS is the client?
-Original Message-
Sent: Tuesday, December 16, 2003 2:39 PM
To: Multiple
My first thought is that JDBC has an array of connections indexed by
a byte-sized index. Let me paraphrase Marie Antoinette, lady famous
for her shrewd dietary advice.
Let them use DBI.
Marie Antoinette's dietary advice came back to haunt her and gave
her a huge albeit very short pain in the
Jay - You have received some great suggestions on this and no doubt you are
researching them. I'll offer a slightly dumber long shot, but easy to check.
What is your PROCESSES set for this instance?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday,
Raj, Thanks for the info..
Process limit is set to 7000
Yes our OS is Sun Solaris
-Original Message-
Jamadagni, Rajendra
Sent: Tuesday, December 16, 2003 2:54 PM
To: Multiple recipients of list ORACLE-L
What is the setting for processes in the database? What is your
per-process-file
Brad, Thanks for your response.
If you are trying to open that many connections from a single client you
should start to look at connection manager to pool these connections of at
least recode your app to share connections.
We are getting this error when the application is trying initialize the