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 DECEMBER 12, 2022
Applies to:
Universal Connection Pool - Version 12.1.0.2.0 and laterInformation 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.
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 |
Cause |
Solution |
References |