1 Reply Latest reply on Jul 14, 2009 6:12 AM by Sheeraz Junejo

    ORA-12519 on jboss-4.2.3.GA cluster

    Ramneek Handa Newbie

      Hi All,s
      I am running jboss-4.2.3.GA cluster. single node comes up fine but when I start the second node. I start getting "ORA-12519, TNS:no appropriate service handler found" on both the nodes.

      Please help.




      18:39:00,949 WARN [JBossManagedConnectionPool] Unable to fill pool
      org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Listener refused the connection with the fol lowing error:
      ORA-12519, TNS:no appropriate service handler found
      The Connection descriptor used by the client was:
      10.107.7.243:1521:cmtedb
      )
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.c reateManagedConnection(LocalManagedConnectionFactory.java:190)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.cr eateConnectionEventListener(InternalManagedConnectionPool.java:619)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.fi llToMin(InternalManagedConnectionPool.java:534)
      at org.jboss.resource.connectionmanager.PoolFiller.run(PoolFiller.java:7 4)
      at java.lang.Thread.run(Thread.java:595)
      Caused by: java.sql.SQLException: Listener refused the connection with the follo wing error:
      ORA-12519, TNS:no appropriate service handler found
      The Connection descriptor used by the client was:
      10.107.7.243:1521:cmtedb

      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java :112)
      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java :261)
      at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
      at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java: 439)
      at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
      at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtensio n.java:35)
      at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.c reateManagedConnection(LocalManagedConnectionFactory.java:172)
      ... 4 more