My Oracle Support Banner

JRuby Script to Verify Your 11g R2 RAC Setup using SCAN (Doc ID 1291120.1)

Last updated on AUGUST 15, 2019

Applies to:

JDBC - Version 11.2.0.1.0 to 11.2.0.2.0 [Release 11.2]
Universal Connection Pool - Version 11.2.0.1.0 to 11.2.0.1.0 [Release 11.2]
Information in this document applies to any platform.

Goal

The Oracle Universal Connection Pool (UCP) for JDBC is a full-featured connection pool for managing database connections not only for Oracle but also for other non Oracle databases. The advantage with using UCP with Oracle is that UCP JDBC connection pools provide a tight integration with various Oracle Real Application Clusters (RAC) Database features . The features include Fast Connection Failover (FCF), Run-Time Connection Load Balancing, and Connection Affinity.

The following how to shows how to verify your 11g R2 RAC Cluster setup using SCAN from a JRuby script using Oracle's Universal Connection Pool (UCP) with Fast Connection Failover (FCF).

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
 Steps
 More Information
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.