- 12c RAC DATABASE
- 12c WEBLOGIC SERVER
- SCAN LISTENER SHOLD BE CONFIGURE AND RESLOVING IP
- FAN HOST NAME AND PORT
- GO TO DATA SOURCE AND CLICK ON NEW
2. CLICK NEW AND THEN PICK GRIDLINK DATA SOURCE FROM DROP DOWN LIST
3. GIVE NAME, JNDI NAME AND PICK *ORACLE’S Driver(ThinXA) for GridLink Connection Versions:Any
4. CLICK NEXT ON TRNSACTION OPTION SCREEN
5. I WILL CHOOSE Enter Complete JDBC URL SINCE I WILL BE USING SCAN IP
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
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
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
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.
10. CLICK NEXT ONE DONE TESTING BOTH CONNECTION AND DEPLOY THE CONNECTION ON THE SERVER OR CLUSTER YOU WOULD LIKE IT TO