Thursday, October 15, 2020

UCP Error Even When Not Using Multi-Tenant Shared Pool Feature

Following errors were seen on CDB alert log where JDBC connections were made to a service associated with a PDB.
2020-10-15T12:18:50.823318+00:00
TESTPDB(3):WARNING: too many parse errors, count=100 SQL hash=0x6870fc2d
TESTPDB(3):PARSE ERROR: ospid=12456, error=904 for statement:
2020-10-15T12:18:50.823502+00:00
TESTPDB(3):select dbms_service_prvt.get_topology(:"SYS_B_0") from dual
TESTPDB(3):Additional information: hd=0x6fc6cb80 phd=0x7025df10 flg=0x100476 cisid=80 sid=80 ciuid=80 uid=80 sqlid=bwkv6d1n71z1d
TESTPDB(3):...Current username=ASANGA
TESTPDB(3):...Application: JDBC Thin Client Action:
As per 2489973.1 the reason for this issue is UCP making calls that are associated with Multi-Tenant Shared Pool feature even when the feature is not used.



One way to remedy is to grant the parsing user the execute privilege on dbms_service_prvt. But this means the un-necessary calls would still happen but error won't be raised.
However, there's patch to fix this on 12.2 28643583.
If patch 28643583 is already applied on UCP then use the merge patch 32004255.