220.127.116.11 UCP Calls to DBMS_SERVICE_PRVT.GET_TOPOLOGY Fail With ORA-904 Errors in the Alert Log
(Doc ID 2489973.1)
Last updated on OCTOBER 12, 2020
Applies to:Universal Connection Pool - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
When using version 22.214.171.124 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:
126.96.36.199 UCP Makes Unnecessary Call to DBMS_SERVICE_PRVT.GET_TOPOLOGY When Connecting to a 12.1 Database (Doc ID 2426775.1)
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