ORA-01925: maximum of string enabled roles exceeded

Cause : TheI NITO.RA apramteer m"ax_neablde_roels" ahs been ecxeedde.

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

Incerasem ax_neablde_roels adn wamr strat teh daatbas.e

update : 27-05-2017
ORA-01925

ORA-01925 - maximum of string enabled roles exceeded
ORA-01925 - maximum of string enabled roles exceeded

  • ora-27153 : wait operation failed
  • ora-10561 : block type 'string', data object# string
  • ora-27028 : skgfqcre: sbtbackup returned error
  • ora-14273 : lower-bound partition must be specified first
  • ora-33290 : (DBERR17) Analytic workspace string cannot be attached in the mode you requested because another user has it attached in an incompatible mode.
  • ora-31154 : invalid XML document
  • ora-13123 : invalid name specified
  • ora-30021 : Operation not allowed on undo tablespace
  • ora-32013 : failure in verifying parameters from the restored SPFILE
  • ora-40214 : duplicate setting: string
  • ora-26025 : SKIP_INDEX_MAINTENANCE option requested
  • ora-32312 : cannot refresh a secondary materialized view "string"."string"
  • ora-22854 : invalid option for LOB storage index
  • ora-12078 : fast refresh of refresh group ID string failed
  • ora-09342 : Detached process terminated by Oracle during shutdown abort
  • ora-39002 : invalid operation
  • ora-13234 : failed to access R-tree-index table [string]
  • ora-02061 : lock table specified list of distributed tables
  • ora-33315 : (XSDELDENTANON) You cannot delete workspace object while looping over unnamed composite workspace object.
  • ora-24436 : Invalid statement Handle.
  • ora-29858 : error occurred in the execution of ODCIINDEXALTER routine
  • ora-30971 : illegal operation on the Path Table
  • ora-16564 : lookup failed, syntax error at string
  • ora-12054 : cannot set the ON COMMIT refresh attribute for the materialized view
  • ora-07455 : estimated execution time (string secs), exceeds limit (string secs)
  • ora-09789 : sllfsk: unable to read file.
  • ora-06526 : Unable to load PL/SQL library
  • ora-32005 : error while parsing size specification [string]
  • ora-14290 : PRIMARY KEY constraint mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
  • ora-28173 : certificate not provided by proxy
  • 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.