My Oracle Support Banner

12.2.0.1 UCP Makes Unnecessary Call to DBMS_SERVICE_PRVT.GET_TOPOLOGY When Connecting to a 12.1 Database (Doc ID 2426775.1)

Last updated on JULY 27, 2018

Applies to:

Universal Connection Pool - Version 12.1.0.2.0 and later
Information in this document applies to any platform.

Symptoms

Using 12.2.0.1 UCP and JDBC to connect to a 12.1.X.X database results in a high amount of library cache lock.


The problems appear as the following query is executed from an application:

SELECT DBMS_SERVICE_PRVT.GET_TOPOLOGY('xxxxxxxxxxx') FROM DUAL;


This generates parse errors :

PARSE ERROR: ospid=62800, error=904 for statement:



The method call DBMS_SERVICE_PRVT.GET_TOPOLOGY is only available beginning in version 12.2.0.1.  When the database is a lower version, such as 12.1.x.x, it is therefore normal to receive a parse error.

The GET_TOPOLOGY call should not be invoked if it isn't available in the target database.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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