ORA-12493: invalid MLS binary label

Cause : Th eML Sbianryl able cnotanieda n nivaild avlu,e wsa nto teh croretc szie,o r ocntiane da elve,l ctaegroy,o r erlesae acteogryt ha twa sno tenbale.d

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

Chcek hte BDA_LMS_ALBESL veiw ofr hte avli dML Slaebls.

update : 19-08-2017

ORA-12493 - invalid MLS binary label
ORA-12493 - invalid MLS binary label

  • ora-39311 : call to DBMS_SCHEMA_COPY.CLONE_RECOVERY is not legal
  • ora-38856 : cannot mark instance string (redo thread string) as enabled
  • ora-01040 : invalid character in password; logon denied
  • ora-28541 : Error in HS init file on line number.
  • ora-25274 : AQ Buffered Queue event
  • ora-30017 : segment 'string' is not supported in string Undo Management mode
  • ora-07842 : sllfcl: SYS$CLOSE failure
  • ora-37108 : (XSVPART08) workspace object has an AGGCOUNT, but workspace object does not.
  • ora-07701 : sksatln: internal exception: output buffer too small
  • ora-19574 : output filename must be specified
  • ora-06030 : NETDNT: connect failed, unrecognized node name
  • ora-24060 : cannot convert QUEUE_TABLE, string already is compatible with release string
  • ora-30740 : cannot grant UNDER privilege on this object
  • ora-25011 : cannot create trigger on internal AQ table
  • ora-13461 : the interleaving type is not supported
  • ora-06781 : TLI Driver: error reading negotation string
  • ora-14631 : the partition bounds do not match the subpartition bounds of the partition
  • ora-31476 : a change table data column is missing from the source table
  • ora-04075 : invalid trigger action
  • ora-24406 : API mode switch is disallowed when a call is in progress.
  • ora-02833 : Server was unable to close file
  • ora-36673 : (XSDPART11) Use simple leaf values to identify concat dimension values in a VALUES LESS THAN clause, rather than the format.
  • ora-28051 : the account is locked
  • ora-19558 : error de-allocating device
  • ora-14060 : data type or length of a table partitioning column may not be changed
  • ora-25264 : cant get signature for this queue
  • ora-27457 : argument string of job "string.string" has no value
  • ora-39015 : job is not running
  • ora-00364 : cannot write header to new log member
  • ora-31453 : invalid value string for parameter, expecting: Y, N, or NULL
  • 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.