ORA-12401: invalid label string: string

Cause : The policy could not convert the label string to a valid internal label.

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

Correct the syntax of the label string.

update : 21-08-2017
ORA-12401

ORA-12401 - invalid label string: string
ORA-12401 - invalid label string: string

  • ora-13786 : missing SQL text of statement object "string" for tuning task "string"
  • ora-03289 : partition name and segment type do not match
  • ora-22906 : cannot perform DML on expression or on nested table view column
  • ora-36223 : (XSLPDSC04) object workspace object in IGNORE or DENSE list has illegal type
  • ora-22881 : dangling REF
  • ora-32802 : value for string must be string
  • ora-27411 : empty string is not a valid repeat interval.
  • ora-39167 : Tablespace string was not found.
  • ora-10936 : trace name context forever
  • ora-25958 : join index where clause predicate may only contain column references
  • ora-24068 : cannot start queue string, queue table string is being migrated
  • ora-13497 : %s
  • ora-10706 : Print out information about global enqueue manipulation
  • ora-02148 : EXCLUSIVE specified multiple times
  • ora-02225 : only EXECUTE and DEBUG privileges are valid for procedures
  • ora-32011 : cannot restore SPFILE to location already being used by the instance
  • ora-19930 : file string has invalid checkpoint SCN string
  • ora-01724 : floating point precision is out of range (1 to 126)
  • ora-24030 : Only one of rule or rule-set must be specified
  • ora-14615 : List value 'string' specified twice in subpartitions 'string', 'string'
  • ora-28353 : failed to open wallet
  • ora-32313 : REFRESH FAST of "string"."string" unsupported after PMOPs
  • ora-28539 : gateway does not support result sets
  • ora-29504 : invalid or missing schema name
  • ora-32638 : Non unique addressing in MODEL dimensions
  • ora-06955 : Number of database servers exceed limit
  • ora-00162 : external dbid length string is greater than maximum (string)
  • ora-01688 : unable to extend table string.string partition string by string in tablespace string
  • ora-32100 : operation invalid on transient object
  • ora-31227 : DBMS_LDAP: invalid LDAP MESSAGE handle
  • 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.