1 Reply Latest reply on Sep 10, 2008 12:48 PM by vickyk

    problem of connectivity Jboss - Oracle RAC

    ersuarez

      Hello,
      I have a problem to connect from the instance of JBoss into a database in Oracle RAC, the problem is presented in intermittently to deploy with message:

      2008-09-08 12:07:19,090 WARN [org.jboss.system.ServiceController] Problem starting service jboss.j2ee:service=EjbModule,module=_adm-ejb-3.0.jar
      org.jboss.deployment.DeploymentException: Error while fixing table name; - nested throwable: (org.jboss.util.NestedSQLException: Could not create connection; -
      nested throwable: (java.sql.SQLException: Io exception: The Network Adapter could not establish the connection); - nested throwable: (org.jboss.resource.JBossRe
      sourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Io exception: The Network Adapter could not establish the connection))
      )

      .
      .
      .

      - the string of connection in the datasources :

      <connection-url>
      jdbc:oracle:thin:@(description=(address_list=(load_balance=off)(failover=off)
      (address=(protocol=tcp)(host=nodo1)(port=1521))
      (address=(protocol=tcp)(host=nodo2)(port=1521)))
      (connect_data=(server=dedicated)(service_name=SID_RAC)
      ))
      </connection-url>


      - test connected to each node on an individual basis and I have no problems

      - test changing the name of the node by the IP address, but the mistake remains

      Someone has an idea that is what may be happening and as we could solve.

      thanks for your help

        • 1. Re: problem of connectivity Jboss - Oracle RAC
          vickyk

           

          "ersuarez" wrote:

          <connection-url>
          jdbc:oracle:thin:@(description=(address_list=(load_balance=off)(failover=off)
          (address=(protocol=tcp)(host=nodo1)(port=1521))
          (address=(protocol=tcp)(host=nodo2)(port=1521)))
          (connect_data=(server=dedicated)(service_name=SID_RAC)
          ))
          </connection-url>


          Looks to me the host name as nodo1/nodo2 are not resolved, you can ping these names.
          Also you can write the simple java standalone program to verify if that gets connected to the oracle RAC.
          http://wiki.jboss.org/wiki/SetUpAOracleDatasource