SAP Knowledge Base Article - Preview

2985964 - catsbp fails with ORA-47401 and ORA-47410

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.