220.127.116.11 UCP Makes Unnecessary Call to DBMS_SERVICE_PRVT.GET_TOPOLOGY When Connecting to a 12.1 Database
(Doc ID 2426775.1)
Last updated on OCTOBER 12, 2020
Applies to:Universal Connection Pool - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Using 22.214.171.124 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 126.96.36.199. 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.
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