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.
SAP Knowledge Base Article - Preview