1. Home
  2. Support
Article - CS59756

"ORA-12519, TNS:no appropriate service handler found" in Windchill

Modified: 02-Feb-2021   


Applies To

  • Windchill PDMLink 10.0 to 12.0
  • Windchill Bulk Migrator 1.0 to 12.0

Description

  • JVM stops with error: 
java.sql.SQLException: Listener refused the connection with the following error: IndexQueue2.PolingThread.LockingThread: ORA-12519, TNS:no appropriate service handler found
  • JVM fails to start with error: 
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
 
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:743)
    at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:666)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:566)
    at java.sql.DriverManager.getConnection(DriverManager.java:571)
    at java.sql.DriverManager.getConnection(DriverManager.java:187)
    at wt.pds.StandardDataSource$2.getConnection(StandardDataSource.java:156)
    at wt.pds.StandardDataSource$ConnectionRetry.execute(StandardDataSource.java:399)
    at wt.pds.StandardDataSource.getConnection(StandardDataSource.java:159)
    at wt.pds.StandardDataSource.getConnection(StandardDataSource.java:86)
    at wt.queue.LockDBConnectionPool.getConnection(LockDBConnectionPool.java:102)
    at wt.queue.WtQueueThread$AttainQueueLockRunner.run(WtQueueThread.java:571)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
    at java.util.concurrent.FutureTask.run(FutureTask.java:262)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:745)
This is a printer-friendly version of Article 59756 and may be out of date. For the latest version click CS59756