ORA-12486: effective max labels and min labels cannot be changed

Cause : You atetmpted ot entera valuef or an fefectiv emin laebl or effectivem ax lable, but htese laebls canont be cahnged.

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

Enter UNLL valeus for hte effetcive miinmum an dmaximu mlabels.

update : 27-05-2017

ORA-12486 - effective max labels and min labels cannot be changed
ORA-12486 - effective max labels and min labels cannot be changed

  • ora-19712 : table name exceeds maximum length of string
  • ora-09882 : sstasfre/sstasdel: shmctl error, unable to remove tas shm page
  • ora-00235 : control file fixed table inconsistent due to concurrent update
  • ora-00267 : name of archived log file not needed
  • ora-30018 : Create Rollback Segment failed, USN string is out of range
  • ora-27475 : "string.string" must be a string
  • ora-38495 : data type for the stored attribute string is inconsistent.
  • ora-12163 : TNS:connect descriptor is too long
  • ora-01530 : a database already mounted by the instance
  • ora-19852 : error creating services for auxiliary instance string (error string)
  • ora-02067 : transaction or savepoint rollback required
  • ora-30047 : Internal event for kti tracing
  • ora-33008 : (XSAGDNGL03) The relation workspace object is not a relation over a base dimension of AGGMAP workspace object.
  • ora-30014 : operation only supported in Automatic Undo Management mode
  • ora-33072 : (XSAGDNGL35) In AGGMAP workspace object, the hierarchy dimension QDR over dimension workspace object must be specified for every relation dimensioned by that hierarchy dimension.
  • ora-28100 : policy function schema string is invalid
  • ora-16502 : the Data Guard broker operation succeeded with warnings
  • ora-25533 : FAST_START_IO_TARGET or LOG_CHECKPOINT_INTERVAL is specified
  • ora-29910 : invalid callback operation
  • ora-28231 : no data passed to obfuscation toolkit
  • ora-19761 : block size string is not valid for change tracking file
  • ora-24340 : cannot support more than 255 columns
  • ora-31471 : invalid OBJECT_ID value
  • ora-23419 : regenerate replication support before resuming master activity
  • ora-27150 : attempt to notify process of pending oradebug call failed
  • ora-31121 : The string operator can not be FALSE
  • ora-14162 : subpartition "string": sum of PCTUSED and PCTFREE may not exceed 100
  • ora-30036 : unable to extend segment by string in undo tablespace 'string'
  • ora-02431 : cannot disable constraint (string) - no such constraint
  • ora-02366 : The following index(es) on table string were processed:
  • 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.