ORA-12497: maximum combined categories exceeds string

Cause : The maximum number of descriptive categories plus release categories supported by the MLS policy was exceeded.

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

Enter numbers that do not add up to more than the maximum.

update : 25-09-2017

ORA-12497 - maximum combined categories exceeds string
ORA-12497 - maximum combined categories exceeds string

  • ora-01166 : file number string is larger than string (string)
  • ora-16723 : setting AlternateLocation property conflicts with the redo transport setting
  • ora-33274 : (DBERR07) Timed out while trying to lock analytic workspace string for string.
  • ora-24309 : already connected to a server
  • ora-07702 : unrecognized device type in archive text
  • ora-22283 : filename contains characters that refer to parent directory
  • ora-07401 : sptrap: cannot restore user exception handlers.
  • ora-16526 : unable to allocate task element
  • ora-22289 : cannot perform string operation on an unopened file or LOB
  • ora-29860 : cannot truncate a table with domain indexes marked LOADING
  • ora-06434 : ssaio: read error, unable to read requested block from database file.
  • ora-25113 : GLOBAL may not be used with a bitmap index
  • ora-19012 : Cannot convert XML fragment to the required datatype
  • ora-02436 : date or system variable wrongly specified in CHECK constraint
  • ora-01478 : array bind may not include any LONG columns
  • ora-32409 : materialized view log on "string"."string" already excludes new values
  • ora-16621 : database name for ADD DATABASE must be unique
  • ora-02391 : exceeded simultaneous SESSIONS_PER_USER limit
  • ora-16552 : an error occurred when generating the CLIENT OPERATION table
  • ora-00368 : checksum error in redo log block
  • ora-01506 : missing or illegal database name
  • ora-16111 : log mining and apply setting up
  • ora-01953 : command no longer valid, see ALTER USER
  • ora-08104 : this index object string is being online built or rebuilt
  • ora-00051 : timeout occurred while waiting for a resource
  • ora-12546 : TNS:permission denied
  • ora-06750 : TLI Driver: sync failed
  • ora-16772 : error switching over between primary and standby databases
  • ora-31518 : change column string already exists in CDC change table string.string
  • ora-03007 : obsolete feature
  • 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.