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 : 24-05-2017
ORA-28021

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

  • ora-03278 : duplicate ALLOCATE EXTENT option specification
  • ora-16203 : Unable to interpret skip procedure return values
  • ora-32775 : cannot change size attributes of read only tablespace string
  • ora-30068 : Internal Event to turn on nested
  • ora-00104 : deadlock detected; all public servers blocked waiting for resources
  • ora-16661 : the standby database needs to be reinstated
  • ora-28575 : unable to open RPC connection to external procedure agent
  • ora-06567 : invalid number of values specified
  • ora-12555 : TNS:permission denied
  • ora-03129 : the next piece to be inserted is required
  • ora-14317 : cannot drop the last value of partition
  • ora-00371 : not enough shared pool memory, should be atleast string bytes
  • ora-14609 : Tablespace was not specified for the previous lob segments of column string in template but is specified for string
  • ora-31201 : DBMS_LDAP: generic error: string
  • ora-28101 : policy already exists
  • ora-38716 : Must supply an integer for the TYPE option.
  • ora-07549 : sftopn: $OPEN failure
  • ora-01370 : Specified restart SCN is too old
  • ora-33452 : (ESDREAD06) Discarding compiled code for workspace object because number is now dimensioned by workspace object. It was dimensioned by workspace object when the code was compiled.
  • ora-24407 : connection pool already exists
  • ora-01155 : the database is being opened, closed, mounted or dismounted
  • ora-07248 : sfwfb: write error, unable to write database block.
  • ora-16096 : ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY
  • ora-06128 : NETTCP: unable to create mailbox
  • ora-08462 : raw buffer contains invalid decimal data
  • ora-25508 : database is not mounted
  • ora-40251 : no support vectors were found
  • ora-27067 : size of I/O buffer is invalid
  • ora-07432 : unable to perform nested sleep
  • ora-39004 : invalid state
  • 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.