How to create a Gridlink Datasource on Weblogic 12c

 

  •  12c RAC DATABASE
  • 12c WEBLOGIC SERVER
  • SCAN LISTENER  SHOLD BE CONFIGURE AND RESLOVING IP
  • FAN HOST NAME AND PORT
  1. GO TO DATA SOURCE AND CLICK ON NEW

1

2. CLICK NEW AND THEN PICK GRIDLINK DATA SOURCE FROM DROP DOWN LIST

2

3. GIVE NAME, JNDI NAME AND PICK *ORACLE’S Driver(ThinXA) for GridLink Connection Versions:Any

3

 

4. CLICK NEXT ON TRNSACTION OPTION SCREEN

4

5.  I  WILL CHOOSE Enter Complete JDBC URL  SINCE I  WILL BE USING SCAN IP

5

6. PROVIDE  COMPLETE JDBC URC: (jdbc:oracle:thin:@rac.scan.india.com:1521/service_id), PROVIDE DATBASE USER NAME & PASSWORD. Make sure user have connect resource in database

and CLICK NEXT

6

7. ON THIS SCREEN  LETS TEST THE CONNECTION  AND IF YOU CONFIGURATION IS RIGHT THEN AND THERE IS NOT ISSUE ON DATABASE SIDE THEN YOU SHOULD GET “Connection test for jdbc:orcle:thin:@@@@@@@@:1521/service_name  succeeded   ON THE TOP OF THE PAGE.  ONCE DONE TESTING CLICK NEXT

7

8. As next step, you have to enter the ONS client configuration. This step allows the data source to subscribe to and process Oracle FAN events; this is essential to distribute connection requests across RAC instances.   ONCE ENTER CLICK NEXT HERE

8

9. NOW LET’S TEST FAN CONFIGUATION  BY CLICKING EACH  Test ONS Node  CIRCLE IN GREEN AND IF IT YOU GET ” Connection test hostname:6200  succeed for each instance then you have configure it correctly. 9

10. CLICK NEXT ONE DONE TESTING BOTH CONNECTION AND DEPLOY  THE CONNECTION ON THE SERVER OR CLUSTER YOU WOULD LIKE IT TO