1 Reply Latest reply: May 16, 2013 2:47 PM by Alejandro Meza RSS

    bc4j.xcfg connection to oracle RAC 11g

    omari
      Hi guys,

      i have a RAC 11g database using the new scan feature i want to connect my j2ee (ADF) application to it when i try editing bc4j.xcfg it is not working with scan it is only working with one of the SID of either cluster nodes. what is the rigth sentax for RAC connection. beow you'll find my current bc4j.xcfg file

      <?xml version = '1.0' encoding = 'UTF-8'?>
      <BC4JConfig>
      <AppModuleConfigBag>
      <AppModuleConfig name="AppModuleLocal">
      <DeployPlatform>LOCAL</DeployPlatform>
      <JDBCName>test</JDBCName>
      <jbo.project>Model</jbo.project>
      <AppModuleJndiName>model.ApplicationModule.AppModule</AppModuleJndiName>
      <jbo.recyclethreshold>0</jbo.recyclethreshold>
      <jbo.ampool.maxinactiveage>300000</jbo.ampool.maxinactiveage>
      <ApplicationName>model.ApplicationModule.AppModule</ApplicationName>
      <jbo.ampool.maxpoolsize>500</jbo.ampool.maxpoolsize>
      </AppModuleConfig>
      </AppModuleConfigBag>
      <ConnectionDefinition name="test">
      <ENTRY name="JDBC_PORT" value="7172"/>
      <ENTRY name="ConnectionType" value="JDBC"/>
      <ENTRY name="HOSTNAME" value="scanip"/>
      <ENTRY name="DeployPassword" value="true"/>
      <ENTRY name="user" value="user"/>
      <ENTRY name="ConnectionName" value="test"/>
      <ENTRY name="SID" value="testdb"/>
      <ENTRY name="JdbcDriver" value="oracle.jdbc.OracleDriver"/>
      <ENTRY name="password" value="pass"/>
      <ENTRY name="ORACLE_JDBC_TYPE" value="thin"/>
      <ENTRY name="DeployPassword" value="true"/>
      </ConnectionDefinition>
      </BC4JConfig>

      regards,
      omari
        • 1. Re: bc4j.xcfg connection to oracle RAC 11g
          Alejandro Meza
          Hello

          You can change connection under JDeveloper to JDBC URL and the format should be something like this:

          jdbc:oracle:thin:user/password@(DESCRIPTION=(LOAD_BALANCE=on)(FAILOVER=on)(ADDRESS_LIST=(ADDRESS=(protocol=tcp)(host=node1.oracleoutsourcing.com)(port=11510))(ADDRESS=(protocol=tcp)(host=node2.oracleoutsourcing.com)(port=11510)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ORCL)))

          Hope this help

          P.S. This example is for a Two nodes RAC