3 Replies Latest reply on Aug 31, 2011 3:41 AM by wdfink

    Getting error in connecting with Oracle database

    pksinha

      Hi All

       

      I am working on ATG project and I need to connect with oracle database which is in remote server. I am able to ping and able to connect using sqldeveloper, but while running run.bat I am getting following error:

      I am using Jdk1.6 and jboss-eap 4.3.

       

      ORA-12519, TNS:no appropriate service handler found

      )

      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(Thread.java:662)

       

      The content of ds file that I am using is as follows:

       

      <datasources>

       

         <no-tx-datasource>

            <jndi-name>atgcore_ds</jndi-name>

            <connection-url>jdbc:oracle:thin:@10.6.16.127:1521:CWKDBS</connection-url>

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

            <user-name>chadwicks_core_sap</user-name>

            <password>admin</password>

            <min-pool-size>30</min-pool-size>

            <max-pool-size>250</max-pool-size>

         </no-tx-datasource>

       

         <no-tx-datasource>

            <jndi-name>atgcataloga_ds</jndi-name>

            <connection-url>jdbc:oracle:thin:@10.6.16.127:1521:CWKDBS</connection-url>

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

            <user-name>chadwicks_cata_sap</user-name>

            <password>admin</password>

            <min-pool-size>10</min-pool-size>

            <max-pool-size>100</max-pool-size>

         </no-tx-datasource>

        

         <no-tx-datasource>

            <jndi-name>atgcatalogb_ds</jndi-name>

            <connection-url>jdbc:oracle:thin:@10.6.16.127:1521:CWKDBS</connection-url>

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

            <user-name>chadwicks_catb_sap</user-name>

            <password>admin</password>

            <min-pool-size>10</min-pool-size>

            <max-pool-size>100</max-pool-size>

         </no-tx-datasource>

       

      </datasources>

       

       

      Please help me to resolve this issue.

       

       

      Thanks

      Prasanna

        • 1. Re: Getting error in connecting with Oracle database
          wdfink

          This might not related to JBoss, the Oracle documents say:

           

          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.

           

          Check your parameter, ask an admin

          or try a jdbc client like Squirrel to check the database first.

          • 2. Re: Getting error in connecting with Oracle database
            pksinha

            Hi

             

            I got lots of answer in different forum but most of them replied that Run "Isnrctl services", but I am sorry I dont know How to run Isnrctl services.

            Can you please tell me how to run it

             

            Thanks

            Prasanna

            • 3. Re: Getting error in connecting with Oracle database
              wdfink

              Sorry but I can't.

              Do you setup the Oracle by yourselve? Or do you have an admin for help?

               

              A simple way to locate the problem is to use a SQL tool like SQirreL, it is easy to install and it is a JDBC client like JBoss.

              Also check your connect data. Is the sqldeveloper connect the same?

              It might possible that you add a wrong ojdbc...jar to jboss/lib (or even two )