ORA-28021: cannot grant global roles

Cause : A orleg ratnedw asI DETNIFEID LGOBLALY .Glboalr olse cna olny eb garntde vai ac enrtala utohriyt fro teh dmoai.n

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Us eALETR ORLEt o hcaneg teh tpye fo rloe f(ro mIDNETIIFEDG LOABLL Ytoo thre, uscha s DIENITFIDE B Ypasswodr),o r laloactei t ot ag loabl suerv iat hec enrtala utohriyt.

update : 27-06-2017
ORA-28021

ORA-28021 - cannot grant global roles
ORA-28021 - cannot grant global roles

  • ora-32019 : The parameter SPFILE cannot be updated in the server parameter file.
  • ora-02281 : duplicate or conflicting CACHE/NOCACHE specifications
  • ora-16823 : redo transport mode is incompatible for current operation
  • ora-39023 : Version string is not supported.
  • ora-27063 : number of bytes read/written is incorrect
  • ora-31186 : Document contains too many nodes
  • ora-07511 : sscggtl: $enq unexpected return for master termination lock
  • ora-13148 : failed to generate SQL filter
  • ora-31231 : DBMS_LDAP: invalid PROPERTY_SET
  • ora-25530 : FAST_START_MTTR_TARGET is not specified
  • ora-28526 : invalid describe information returned to Heterogeneous Services
  • ora-25334 : Buffered propagation must restart as the destination queue was recreated/moved
  • ora-12844 : cluster reconfiguration in progress
  • ora-12042 : cannot alter job_queue_processes in single process mode
  • ora-08175 : discrete transaction restriction violated (string)
  • ora-31529 : could not find publication for CDC subscriber view string.string
  • ora-36267 : (XSCGMDLAGG09) workspace object has no dimensions, so it cannot have a qualified data reference.
  • ora-22916 : cannot do an exact FETCH on a query with Nested cursors
  • ora-38424 : no attribute set currently assigned to the expression set
  • ora-25156 : old style outer join (+) cannot be used with ANSI joins
  • ora-30486 : invalid window aggregation group in the window specification
  • ora-02036 : too many variables to describe with automatic cursor open
  • ora-27032 : failed to obtain file size limit
  • ora-23389 : obsolete procedure; drop objects and recreate using new master
  • ora-07646 : sszfck: $CREATE failure
  • ora-07683 : sou2os: $SETPRV reset error
  • ora-00399 : corrupt change description in redo log
  • ora-16227 : DDL skipped due to missing object
  • ora-00401 : the value for parameter string is not supported by this release
  • ora-13196 : failed to compute supercell for element string.string.string
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.