My Oracle Support Banner

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 JANUARY 03, 2024

Applies to:

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

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

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
Changes
Cause
Solution
References


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