Oracle UCP FAQ

Updated Aug 13, 2014

 
This document contains answers to the most frequently asked questions about Oracle's Universal Connection Pool(UCP). Note that these address specific technical questions only and are used to document solutions to frequent customer questions as well as any known problems. The server docs (including JDBC doc) are also available online

Back to Top

Whats New?

UCP FAQ page is totally a new page aimed at answering all the questions related to UCP.  The purpose is to make using UCP easier and describe its strong capabilities.

Back to Top

UCP in General


What is UCP?

UCP is the Universal Connection Pool. It is a single connection pool that handles all kinds of connections, JDBC, JCA, LDAP, and others. It supports non-Oracle JDBC drivers and JDBC connections to non-Oracle databases. When used for Oracle JDBC connections to Oracle databases it provides all the features of the old JDBC Implicit Connection Cache, and more. UCP is widely used in Oracle products. We recommend using UCP for its capabilities to handle fail-over gracefully, managing connections, resources and many other reasons.

Back to Top

How do I use UCP?

UCP is a standalone jar file.  It is named as ucp.jar.  It is not included in the JDBC jar file. 

Back to Top


Where can I get the UCP jar files?

Please download the required version of UCP jar files from the Oracle Technology Network JDBC, UCP & SQLJ Download Page.

Back to Top
Where can I learn more about UCP?

Please refer to the UCP Reference Guide for more details.

Back to Top

Release Specific Questions


What are the supported versions of UCP?

Current supported versions of ucp.jar file are 11.1, 11.2 and 12.1

Back to Top
Can ucp.jar version differ from JDBC driver version?

Prior to 12c (i.e., 12.1.0.1.0), UCP could work with any version of Oracle JDBC driver. With the new pool, UCP 12.1.0.2, it is dependent on Oracle JDBC driver 12.1.0.2. Example: 12.1.0.2 ucp.jar requires ojdbc7.jar or ojdbc6.jar from 12.1.0.2.  Our recommendation is to keep both ucp.jar and JDBC drivers from the same version. 

Back to Top
Does ucp.jar version dependent on any database version?

Database version compatibility comes from the JDBC driver version, but not UCP version. UCP jar file should be compatible with the JDBC driver version.

Back to Top

Oracle Notification Service(ONS)


What is ONS ?

Oracle Notification Server (ONS) uses a simple publish/subscribe method to produce and deliver event messages for both local and remote consumption. ONS daemons run locally sending messages to and receiving messages from a configured list of nodes (where other ONS daemons are active).

Back to Top

How to configure ONS?

ONS configuration is controlled by a configuration file (ons.config) located at ORACLE_HOME/opmn/conf/ons.config. Configuration information within ons.config is defined through name/value pairs. It should contain
localport: the port that ONS binds to on the localhost interface to talk to local clients.
remoteport:the port that ONS binds to on all interfaces for talking to other ONS daemons
nodes:a list of other ONS daemons to talk to specified as either hostnames or IP addresses plus ports

Back to Top

Oracle Open World 2014 Banner

In-Memory Replay Banner