12.2.0.1 UCP Calls to DBMS_SERVICE_PRVT.GET_TOPOLOGY Fail With ORA-904 Errors in the Alert Log (Doc ID 2489973.1)

Last updated on DECEMBER 21, 2022

Applies to:

Symptoms

When using version 12.2.0.1 of the Universal Connection Pool (UCP) to connect to a 12.2 multitenant database, the following parse errors are recorded in the database alert log:

PARSE ERROR: ospid=<xxxx>, error=904 for statement:

The problem arises due to the execution of the following SQL statement from an application:

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

A similar problem is seen when 12.2 UCP connects to a 12.1.x.x database, as described in the following article:

<Document:2426775.1> 12.2.0.1 UCP Makes Unnecessary Call to DBMS_SERVICE_PRVT.GET_TOPOLOGY When Connecting to a 12.1 Database.

However, in that case, the problem arose because the method call DBMS_SERVICE_PRVT.GET_TOPOLOGY is first introduced in version 12.2; in that case, UCP was unnecessarily calling this method when connecting to an older database version, such as 12.1.x.x.

In this case, the database version is 12.2.x.x (which supports the method call DBMS_SERVICE_PRVT.GET_TOPOLOGY), but the ORA-904 error still occurs in the alert log.

Changes

Cause

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