3116598 - Object DBMS_GSM_DBADMIN getting invalidated during SBP installation

Symptom

The SBP installation with mopatch/opatch is failing as visible below error:

...

Warning: Package Body created with compilation errors.
Errors for PACKAGE BODY DBMS_GSM_DBADMIN:
LINE/COL ERROR
-------- -----------------------------------------------------------------
4342/3 PL/SQL: Statement ignored
4342/22 PLS-00302: component 'SETCATALOGSYSLINK' must be declared
Grant succeeded.
Grant succeeded.
Errors for PACKAGE BODY DBMS_GSM_DBADMIN:
LINE/COL ERROR
-------- -----------------------------------------------------------------
4342/3 PL/SQL: Statement ignored
4342/22 PLS-00302: component 'SETCATALOGSYSLINK' must be declared

...

The DB components remained VALID:

SQL> select substr(comp_name,1,30) comp_name, substr(comp_id,1,10) comp_id,substr(version,1,12) version,status from dba_registry;

COMP_NAME COMP_ID VERSION STATUS
------------------------------------------------------------------------------------------ ------------------------------ ------------------------------------ ---------------------------------
Oracle Database Catalog Views CATALOG 19.0.0.0.0 VALID
Oracle Database Packages and T CATPROC 19.0.0.0.0 VALID
Oracle Real Application Cluste RAC 19.0.0.0.0 OPTION OFF
Oracle XML Database XDB 19.0.0.0.0 VALID

Environment

SAP Netweaver
OS Independent
Oracle RDBMS

Product

SAP NetWeaver all versions ; SAP Solution Manager all versions

Keywords

DBMS_GSM_DBADMIN, invalidated, SBP installation, object invalid, object invalidation, database security, GSMS, SAP Business Planning, SAP Business Warehouse, SYSDBA, object management, database object, object status, object invalid error, SAP SAPHANA , 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.