Symptom
Catsbp apply log shows complete with warning:
Example:
SAP202502_APPLY_<SID>_<DATE>_<TIME>.log
Warning:
Cause: Some objects from users not maintained by Oracle cannot be
recompiled with utlrp.sql.
Action: Inspect the remaining invalid objects using the information from
table DBA_OBJECTS, follow up the errors causing the objects to be
invalid, and resolve the errors. Run utlrp.sql manually to
recompile the objects.
catsbp completed with warnings. Refer to the log file
$ORACLE_BASE/cfgtoollogs/sqlpatch/SAP202502_APPLY_<SID>_<DATE>_<TIME>.log
for more information.
Overall Status: COMPLETE, WARNINGS
Name: Output of SELECT object_name, object_type, status FROM dba_objects WHERE status = 'INVALID';
output shows INVALID objects.
Run utlrp.sql couple of times:
###> sqlplus / as sysdba
SQL> @?/rdbms/admin/utlrp.sql
Still same number of INVALID objects are present
Read more...
Environment
Source: portal
Type: Test System
DB: Oracle 19c
Product
Keywords
KBA , BC-DB-ORA , Oracle , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.