Datapatch failed with the error ORA-47410: Realm violation for CREATE ROLE

(Doc ID 2306010.1)

Last updated on OCTOBER 03, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Datapatch failed with the below error

[oragpe6@hostname OPatch]$ ./datapatch -verbose
SQL Patching tool version 12.1.0.2.0 Production on Sun Sep 10 19:42:03 2017
Copyright (c) 2012, 2017, Oracle. All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_175757_2017_09_10_19_42_03/sqlpatch_invocation.log

Connecting to database...OK
Bootstrapping registry and package to current versions...done
Determining current state...done

Current state of SQL patches:
Patch 19282028 (Database PSU 12.1.0.2.1, Oracle JavaVM Component ():
 Not installed in the binary or the SQL registry
Patch 19877336 (Database PSU 12.1.0.2.2, Oracle JavaVM Component (Jan2015)):
 Not installed in the binary or the SQL registry
Patch 22139226 (Database PSU 12.1.0.2.160119, Oracle JavaVM Component (Jan2016)):
 Installed in the binary registry and the SQL registry
Patch 23321125 (DPLOAD DOESN'T CREATE THE SHARED OBJECTS ACROSS ALL PDBS):
 Installed in the binary registry and APPLY with errors in the SQL registry
Bundle series DBBP:
 ID 170814 in the binary registry and ID 170814 with errors in the SQL registry

Adding patches to installation queue and performing prereq checks...
Installation queue:
 Nothing to roll back
 The following patches will be applied:
  26609798 (DATABASE BUNDLE PATCH 12.1.0.2.170814)
  23321125 (DPLOAD DOESN'T CREATE THE SHARED OBJECTS ACROSS ALL PDBS)

Installing patches...
Patch installation complete. Total patches installed: 2

Validating logfiles...
Patch 26609798 apply: WITH ERRORS
 logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/26609798/21481992/26609798_apply_D_IN02_2017Sep10_19_42_36.log (errors)
  Error at line 14778: ORA-47410: Realm violation for CREATE ROLE on DV_SECANALYST
  Error at line 14795: ORA-47410: Realm violation for CREATE ROLE on DV_MONITOR
  Error at line 14812: ORA-47410: Realm violation for CREATE ROLE on DV_ADMIN
  Error at line 14828: ORA-47410: Realm violation for CREATE ROLE on DV_OWNER
  Error at line 14844: ORA-47410: Realm violation for CREATE ROLE on DV_ACCTMGR
  Error at line 14860: ORA-47410: Realm violation for CREATE ROLE on DV_PUBLIC

Changes

 Apply JULY 2017 BP 170718 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms