SAP Knowledge Base Article - Preview

3619472 - catsbp after post-installation SBP: Some objects from users not maintained by Oracle cannot be recompiled with utlrp.sql

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

SAP ERP 6.0

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.