Intermittend ORA-12519, TNS:no appropriate service handler found
- From: "Robert Klemme" <bob.news@xxxxxxx>
- Date: Fri, 24 Feb 2006 18:40:51 +0100
Hi all,
we have an Oracle 10 (version details below) on Linux (RHEL 4). When
connecting via JDBC we get intermittend ORA-12519 (reflected as TNS-12519
in listener.log). sqlldr also has a problem, although at the moment I
can't exactly determine whether it's the same (I'm guessing it is because
the happen about the same time).
Research on the web revealed that a too low value for "processes" might be
the reason. (The other possible cause I found was non matching versions of
DB and client but this is not the case here.) So we increased DB param
"parallel_max_servers" to 200. Since the error still showed up we went up
to 400. It's been quiet since the last change of this parameter on
Tuesday but some minutes ago I got an email notification that the error
occurred again.
I rather not want to increase the value by trial and error since we have
only 36 sessions on the database right now and there seems to be a
discrepancy between parameter "processes" (at 150 now, the value is
derived from "parallel_max_servers") and the actual # of processes. Also
the system is not much utilized and there's enough free resources (CPU
wise and memory wise). So I'd like to first find out what is causing this
error before I take further measures.
I checked the alert log but there were no significant entries. I checked
job scheduling to check whether there might be a job that eats up
connections, but no. I guess switching on some trace might be helpful but
at the moment I don't have an idea which one would be appropriate. Any
ideas? Thanks for any insights!
Kind regards
robert
PRODUCT
----------------------------------------------------------------
VERSION
----------------------------------------------------------------
NLSRTL
10.2.0.1.0
Oracle Database 10g Enterprise Edition
10.2.0.1.0
PL/SQL
10.2.0.1.0
TNS for Linux:
10.2.0.1.0
[root] r1:/usr/local/oracle/product/10.2.0: uname -a
Linux r1.webwasher.com 2.6.9-22.0.1.ELsmp #1 SMP Tue Oct 18 18:39:27 EDT
2005 i686 i686 i386 GNU/Linux
.
- Follow-Ups:
- Re: Intermittend ORA-12519, TNS:no appropriate service handler found
- From: ianal Vista
- Re: Intermittend ORA-12519, TNS:no appropriate service handler found
- From: bdbafh
- Re: Intermittend ORA-12519, TNS:no appropriate service handler found
- From: Frank van Bortel
- Re: Intermittend ORA-12519, TNS:no appropriate service handler found
- Prev by Date: lots of waiting on 'db file parallel write'
- Next by Date: Re: Ora10g connect as sysdba isqlplus
- Previous by thread: lots of waiting on 'db file parallel write'
- Next by thread: Re: Intermittend ORA-12519, TNS:no appropriate service handler found
- Index(es):
Relevant Pages
|
