Search code examples
weblogicweblogic11g

Oracle ADF DataSource for RAC environment


I have environment of Oracle database 11gR2 Single Instance on linux, Weblogic 10.3.5 on Windows. I have running ADF Application with single instance database. The Connection between Database and Application is configured by using Generic DataSource "MyAppDS". On Other side i Have Configured new RAC Database environment with same Application. the Connection between RAC database and Application is configured by using GridLink DataSource. the Confusion is about the JDBC/MyAppDS. Is this should be same or different for RAC. Should the Developer have to create new connection string for RAC database.? kindly help


Solution

  • We recommend using JDBC Thin driver with Oracle RAC. Most of our customers are using JDBC Thin driver. Active Grid Link is the correct datasource to use with WLS. Sample RAC URL is as shown below. Always use SCAN for better manageability purposes.

    jdbc:oracle:thin:@(DESCRIPTION =
    (CONNECT_TIMEOUT= 90)  (RETRY_COUNT=20)(RETRY_DELAY=3)
    (ADDRESS_LIST =
      (LOAD_BALANCE=on)
      (ADDRESS = (PROTOCOL = TCP)(HOST=primary-scan)(PORT=1521)))
      (ADDRESS_LIST =
      (LOAD_BALANCE=on)
      ( ADDRESS = (PROTOCOL = TCP)(HOST=secondary-scan)(PORT=1521)))       
      (CONNECT_DATA=(SERVICE_NAME = gold-cloud)))