1 Reply Latest reply on Aug 3, 2011 11:22 AM by Peter Johnson

    ORA-12519, TNS:no appropriate service handler found

    tamizharasi periyasamy Newbie

      Hi,

       

      I am trying to connect a oracle 10g server. Following is my

       

      Oracle ds entry

       

      <local-tx-datasource>

          <jndi-name>dnbame</jndi-name>

      <use-java-context>false</use-java-context>

       

          <connection-url>jdbc:oracle:thin:@...................:XE</connection-url>

          <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>

          <user-name>....</user-name>

          <password>...</password>

       

              <min-pool-size>5</min-pool-size>

              <max-pool-size>50</max-pool-size>

              <idle-timeout-minutes>5</idle-timeout-minutes>

               <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>

              <metadata>

                  <type-mapping>OracleXE</type-mapping>

              </metadata>

        </local-tx-datasource>

       

      I am able to make connection and fetch the data. But it throws the warning like

       

      10:15:14,523 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 following error:

      ORA-12519, TNS:no appropriate service handler found

      The Connection descriptor used by the client was:

      ...................:XE

      )

          at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:190)

          at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:584)

          at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.fillToMin(InternalManagedConnectionPool.java:531)

          at org.jboss.resource.connectionmanager.PoolFiller.run(PoolFiller.java:74)

          at java.lang.Thread.run(Unknown Source)

       

      Could any one tell me why I am getting this error and how to solve this issue?