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

    problem of connectivity Jboss - Oracle RAC

    efren suarez Newbie

      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