ORA-12411: invalid label value

Cause : The specified label value does not exist.

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

Check the data dictionary views for the policy to identify valid labels.

update : 21-07-2017
ORA-12411

ORA-12411 - invalid label value
ORA-12411 - invalid label value

  • ora-28139 : Maximum allowed Fine Grain Audit Policies Exceeded
  • ora-22863 : synonym for datatype string.string not allowed
  • ora-01264 : Unable to create string file name
  • ora-30160 : Unable to access the file
  • ora-14512 : cannot perform operation on a clustered object
  • ora-30061 : Internal Event for Savepoint Tracing
  • ora-36841 : (XSLMGEN11) Dimension string.string!string was not found
  • ora-25221 : enqueue failed, signature specified queue not supporting non-repudiation
  • ora-02464 : Cluster definition can not be both HASH and INDEX
  • ora-06044 : NETDNT: connect failed, byte count quota exceeded
  • ora-29277 : invalid SMTP operation
  • ora-07624 : smsdes: $DGBLSC failure
  • ora-31038 : Invalid string value: "string"
  • ora-40285 : label not in the model
  • ora-34350 : (MXDSS06) string is an open analytic workspace.
  • ora-36706 : (XSRELTBL07) workspace object should be dimensioned by workspace object and one level dimension.
  • ora-14006 : invalid partition name
  • ora-00052 : maximum number of enqueue resources (string) exceeded
  • ora-27077 : too many files open
  • ora-16777 : unable to find the destination entry of a standby database in V$ARCHIVE_DEST
  • ora-38711 : Corrupt flashback log block header: block string
  • ora-19226 : XP0006 - XQuery dynamic type mismatch: expected string got string
  • ora-09879 : sstascre/sstasat: shmat error, unable to attach tas read page
  • ora-26696 : no streams data dictionary for object with number string and version number string from source database string
  • ora-00345 : redo log write error block string count string
  • ora-31198 : Mismatch in number of bytes transferred due to non-binary mode
  • ora-01491 : CASCADE option not valid
  • ora-02261 : such unique or primary key already exists in the table
  • ora-02348 : cannot create VARRAY column with embedded LOB
  • ora-28142 : error in accessing audit index file
  • 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.