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:

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

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