How To Configure and Test a WebLogic Gridlink Datasource Connecting To An Oracle RAC SCAN Address (Doc ID 1382656.1)

Last updated on JUNE 14, 2017

Applies to:

Oracle WebLogic Server - Version 10.3.4 and later
Information 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms