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

Last updated on JANUARY 03, 2024

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A and later
Universal Connection Pool - Version to 19.8 [Release 12.1 to 18c]
Information in this document applies to any platform.


When using version 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:



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> 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.





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

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