Symptom
While executing catsbp as part of Oracle Database Patching below error is seen in the command line:
Executing Datapatch...failed.
Reason: Failure during patch post-installation
Loading style sheets...
Loading style sheets...skipped.
Reason: Style sheets already loaded
Recompiling objects with utlrp...
Recompiling objects with utlrp...done.
Post-processing Datapatch execution...
Post-processing Datapatch execution...done.
Post-installation of this SAP Bundle Patch is incomplete:
Cause: Datapatch has encountered an error during patch post-installation.
Action: Refer to the log file for more information and resolve the error
cause.
catsbp completed but post-installation of this SAP Bundle Patch is
INCOMPLETE. Refer to the log file
$ORACLE_BASE/cfgtoollogs/sqlpatch/SAP202008_APPLY_<DBSID>_2020_10_29-14-10-13.log
for more information.
Overall Status: INCOMPLETE
Additionally, the Logfile referenced above contains below errors:
Validating logfiles...done
Patch 31281355 apply: WITH ERRORS
logfile: /oracle/OL2/cfgtoollogs/sqlpatch/31281355/23688465/31281355_apply_OL2_2020Oct29_14_11_43.log (errors)
-> Error at line 2501: script rdbms/admin/prvtrlsa.plb
- ORA-47401: Realm violation for CREATE PACKAGE BODY on SYS.DBMS_RLS
-> Error at line 22755: script rdbms/admin/catsnmp.sql
- ORA-47410: Realm violation for CREATE ROLE on OEM_ADVISOR
-> Error at line 22782: script rdbms/admin/catsnmp.sql
- ORA-47410: Realm violation for CREATE ROLE on OEM_MONITOR
-> Error at line 22870: script rdbms/admin/catsnmp.sql
- ORA-01031: insufficient privileges
...
Post-installation of this SAP Bundle Patch is incomplete:
Cause: Datapatch has encountered an error during patch post-installation.
Action: Refer to the log file for more information and resolve the error
cause.
Read more...
Environment
- as of Oracle RDBMS 12c
- SAP Netweaver
- Linux/UNIX
Keywords
catsbp,database vault, ORA-47401, ORA-47410, ORA-01031, opatch, mopatch, realm violation, patching, enable, disable, security , KBA , BC-DB-ORA , Oracle , BC-DB-ORA-SEC , Security Messages , 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.