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

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.

• as of Oracle RDBMS 12c
• SAP Netweaver 
• Linux/UNIX

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