Stack Overflow
Stack Overflow

Questions tagged [ora-12519]

ORA-12519: TNS:no appropriate service handler found

Cause: The listener could not find any available service handlers that are appropriate for the client connection.

Action: Run "lsnrctl services" to ensure that the instance(s) have registered with the listener, and are accepting connections.

11 questions
47
votes
5 answers

What can cause intermittent ORA-12519 (TNS: no appropriate handler found) errors

We are running our Junit 4 test suite against Weblogic 9 in front of an Oracle 10 database (using Hudson as a continuous integration server) and occasionally we will get an ORA-12519 crash during script teardown. However, the error is very…
cynicalman
  • 5,861
  • 3
  • 30
  • 30
7
votes
2 answers

ORA-12519, TNS:no appropriate service handler found while inserting into Oracle Database with X threads

I am trying to insert into Oracle database which has two columns- ID Primary Key varchar2 (4000) ACCOUNT varchar2 (4000) I wrote a Multithreaded program for that. And each thread is using unique id every time to…
AKIWEB
  • 19,008
  • 67
  • 180
  • 294
5
votes
3 answers

Spring connection pooling issue

I'm not experienced in Java and Spring. I try to write a program that uses JdbcTemplate for Data access. I use DBCP pooling, here it is:
xyzt
  • 1,201
  • 4
  • 18
  • 44
4
votes
1 answer

Oracle listener state blocked

I have a webpp which works fine when under a light load. However, when we run a lot of threads each with their own database connection, then we start getting the error ORA-12519: TNS:no appropriate service handler found After looking online I…
Eli Courtwright
  • 186,300
  • 67
  • 213
  • 256
2
votes
1 answer

Why do I get this Oracle connections error? ORA-12519, TNS:no appropriate service handler found

I'm building a JSF2 app with GlassFish, Hibernate, Spring (for transaction mgmt), and Oracle 11g. After the application has been running for a while, the app fails to query the db and I get the following error in the GlassFish log: Caused by:…
user550738
1
vote
1 answer

getting java.sql.SQLException: Closed Connection when accessing large resultset

Hello i have big data in my oracle 10g database and have to perform some calculations on every row of resultset. So i call a separate calculation class after fetching value of single row in the while(rs.next) loop. But this actually gives me…
Dhruv
  • 1,668
  • 9
  • 29
  • 40
0
votes
1 answer

What causes an ORA-12519 to be thrown even though the Oracle trace file for the event shows an ORA-00020?

When we are connecting to Oracle via the listener and we reach our process limit, we're getting an ORA-12519: TNS:no appropriate service handler found. Looking at the the trace file for the event, it's showing an ORA-00020: maximum number of…
Mr. Muskrat
  • 22,772
  • 3
  • 20
  • 21
0
votes
1 answer

ORA-12519 TNS: No appropriate service handler found in JBoss 7.2

I'm migrating some projects from JBoss 6.4 to JBoss 7.2, these projects needs different datasources to configurate DB connections. I added the datasources to the JBoss server config file (standalone.xml):
TimeToCode
  • 901
  • 2
  • 16
  • 34
0
votes
0 answers

Could not open Hibernate Session for transaction due to ora 12519

org.springframework.transaction.CannotCreateTransactionException: Could not open Hibernate Session for transaction; nested exception is org.hibernate.exception.GenericJDBCException: Could not open connection due to TNS:no appropriate service handler…
Gaurav Gupta
  • 1
  • 1
0
votes
2 answers

Refresh Jtable when change in database. Error :ORA-12519

I'm a beginner in Java projects and I want to know the best way to do something. I have developed a desktop application which show data from a table in database in a JTable, and when that table has a change, it has to show previous data + new…
Sophie_
  • 36
  • 3
0
votes
1 answer

Oracle 12519 : Issues while running integration test suite

I have a test suite which contains about 4000 tests in it. We use Oracle as our database . When i run the test suite , some tests run fine and after some time i get ORA-12519 TNS:no appropriate service handler found When i run the tester in…
Barry
  • 1,585
  • 3
  • 22
  • 35