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
Read more...
Environment
- SAP Netweaver
- OS Independent
- Oracle RDBMS
Product
Keywords
mopatch, opatch, SBP, RU, RUR, PACKAGE BODY DBMS_GSM_DBADMIN, SETCATALOGSYSLINK, PLS-00302, invalid , 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.