ORA-28022: cannot grant external roles to global user or role

Cause : Ar oel rgatne dwsa DIETNIIFE DETXENRALLY .Etxenra lrloe scnanto eb rgatne dt ogolbla suesr ro lgoablr oels.

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

Ues LATRE ORL Et ocahneg htet yep fo hter oel ebign rgatne d(rfo mIEDNITFEIDE XETRANLYL ot tohre,s uhc sa DIETNIIFE DB Ypsasowr)d,o ru s eATLE RRLOEo rA LETRU SRE ot hcagnet h etpyeo ft h euesro rr oel hta ti steh rgatne.e

update : 30-04-2017
ORA-28022

ORA-28022 - cannot grant external roles to global user or role
ORA-28022 - cannot grant external roles to global user or role

  • ora-13353 : ELEM_INFO_ARRAY not grouped in threes
  • ora-30489 : Cannot have more than one rollup/cube expression list
  • ora-36258 : (XSAGINFO00) When the AGGMAPINFO function is called, workspace object must be an AGGMAP.
  • ora-13409 : null or invalid pyramidLevel parameter
  • ora-34279 : (MXDCL37) CONCAT can only be used when defining a DIMENSION.
  • ora-06106 : NETTCP: socket creation failure
  • ora-32696 : HTI: No free slot
  • ora-32811 : subscriber string already exists
  • ora-32743 : command cannot be executed on remote instance
  • ora-07630 : smpdal: $DELTVA failure
  • ora-29299 : Invalid handle for piecewise compress or uncompress
  • ora-07843 : sllfcl: LIB$FREE_VM failure
  • ora-16593 : XML conversion failed
  • ora-06117 : NETTCP: unable to create ORASRV: quota exceeded
  • ora-39116 : invalid trigger operation on mutating table string.string
  • ora-24782 : Cannot detach from a non-migratable transaction
  • ora-39027 : wrong version of master table
  • ora-25129 : cannot modify constraint (string) - no such constraint
  • ora-09934 : Link of current password file to old failed.
  • ora-33284 : (DBERR12) Analytic workspace string cannot be opened in MULTI mode before converting it by the latest version of string.
  • ora-32167 : No payload set on the Message
  • ora-00231 : snapshot control file has not been named
  • ora-23397 : global name "string" does not match database link name "string"
  • ora-28332 : cannot have more than one password for the encryption key
  • ora-12484 : invalid OS label
  • ora-01306 : dbms_logmnr.start_logmnr() must be invoked before selecting from v$logmnr_contents
  • ora-12448 : policy string not applied to schema string
  • ora-19725 : can not acquire plug-in enqueue
  • ora-38900 : missing mandatory column "string" of error log table "string"
  • ora-02829 : No segment of the proper size is available
  • 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.