ORA-28031: maximum of string enabled roles exceeded

Cause : hT esurea ttmetpdet onebaelt oom na yorel.s

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

nEbaelf werer lose.

update : 21-09-2017
ORA-28031

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

  • ora-31228 : DBMS_LDAP: invalid MOD_ARRAY
  • ora-32058 : operation restricted to SYSDBA users
  • ora-07476 : slsget: cannot get mapped memory statistics.
  • ora-31402 : unrecognized parameter string
  • ora-33003 : (XSAGDIMDROP) workspace object, to be transformed during data load, must be a base dimension and not otherwise referenced in the AGGMAP.
  • ora-10691 : Set background process core file type (Unix only)
  • ora-06127 : NETTCP: unable to change username
  • ora-19650 : Offline-range record recid string stamp string in file string has SCN string
  • ora-12322 : unable to mount database (link name string)
  • ora-10656 : Table is in unusable state due to incomplete operation
  • ora-12336 : cannot login to database (link name string)
  • ora-16065 : remote archival disabled at standby destination
  • ora-02399 : exceeded maximum connect time, you are being logged off
  • ora-39776 : fatal Direct Path API error loading table string
  • ora-38477 : attribute set cannot be derived from an evolved type or a subtype.
  • ora-12447 : policy role already exists for policy string
  • ora-26663 : error queue for apply process string must be empty
  • ora-24185 : transformation string.string does not exist
  • ora-31657 : data filter name can not be defaulted
  • ora-30177 : invalid flag used in a format specification
  • ora-12723 : regular expression too complex
  • ora-00259 : log string of open instance string (thread string) is the current log, cannot archive
  • ora-08197 : Flashback Table operation is not supported on clustered tables
  • ora-07221 : slspool: exec error, unable to start spooler program.
  • ora-32584 : missing LOG keyword
  • ora-37158 : Bad clob or varray IN-args: (case string)
  • ora-39139 : Data Pump does not support XMLSchema objects. string will be skipped.
  • ora-06910 : CMX: Cannot start oracle process on remote machine
  • ora-31000 : Resource 'string' is not an XDB schema document
  • ora-22611 : TDS version is not recognized
  • 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.