ORA-28201: Not enough privileges to enable application role 'string'

Cause : Ana ttmeptt o neabel appliactino rloe uotsdie hte csop eoft hed esginaetd apckgae

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

Enbalet her ol edierctyl o rinidretclyu sign teh dseigante dpakcage

update : 21-07-2017
ORA-28201

ORA-28201 - Not enough privileges to enable application role 'string'
ORA-28201 - Not enough privileges to enable application role 'string'

  • ora-31158 : schema "string" currently being referenced
  • ora-15058 : disk 'string' belongs to an incompatible diskgroup
  • ora-02201 : sequence not allowed here
  • ora-22369 : invalid parameter encountered in method string
  • ora-14632 : cannot specify PARALLEL clause when adding a List subpartition
  • ora-13852 : Tracing for service(module/action) string is not enabled
  • ora-40219 : apply result table string is incompatible with current operation
  • ora-14021 : MAXVALUE must be specified for all columns
  • ora-01562 : failed to extend rollback segment number string
  • ora-02330 : datatype specification not allowed
  • ora-16097 : ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
  • ora-39216 : object type "string"."string" hashcode mismatch
  • ora-37173 : null dimension source data
  • ora-28343 : fails to encrypt data
  • ora-02299 : cannot validate (string.string) - duplicate keys found
  • ora-16723 : setting AlternateLocation property conflicts with the redo transport setting
  • ora-02231 : missing or invalid option to ALTER DATABASE
  • ora-09979 : skxfqhsnd: Error Sending a message to another endpoint
  • ora-36686 : (XSDPART24) Value number is not in partition number.
  • ora-33052 : (XSAGDNGL25) AGGMAP workspace object is a dimensioned AGGMAP; it can only be used to aggregate like-dimensioned variables.
  • ora-14515 : only one aubpartition name can be specified
  • ora-30049 : Internal event for TA enq tracing
  • ora-19123 : fn:zero-or-one() called with a sequence containing more than one item
  • ora-38788 : More standby database recovery is needed
  • ora-07641 : smscre: Unable to use the system pagefile for the SGA
  • ora-25280 : complete sender information not provided to non-repudiate sender
  • ora-16518 : unable to allocate virtual instance id
  • ora-24090 : at least one protocol must be enabled
  • ora-01039 : insufficient privileges on underlying objects of the view
  • ora-14186 : number of sub-partitions of LOCAL index must equal that of the underlying table
  • 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.