How to Configure and Test a WebLogic Gridlink Datasource Connecting to an Oracle RAC SCAN Address
(Doc ID 1382656.1)
Last updated on OCTOBER 11, 2023
Applies to:
Oracle WebLogic Server - Version 10.3.4 and laterInformation in this document applies to any platform.
Goal
This document provides a detailed example on how to configure and test WebLogic Gridlink datasources connecting to an Oracle RAC SCAN address with console screenshots and testing results. The documentation can be a bit confusing or in some cases incorrect for certain use cases. For the Gridlink datasource configuration in this example we will use the SCAN address connecting to two Oracle DB instances in the cluster. The SCAN address can have any number of Oracle DB instances in the cluster at the backend.
NOTE: Single Client Access Name (SCAN) is s a new feature that provides a single name for clients to access Oracle Databases running in a cluster. The benefit is that the client's connect information does not need to change if you add or remove nodes in the cluster. Having a single name to access the cluster allows clients to use the EZConnect client and the simple JDBC thin URL to access any database running in the cluster, independently of which server(s) in the cluster the database is active. More information on SCAN feature can be found here.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |