ORA-12665: NLS string open failed

Cause : A natiev serviec was uanble tom ake a tsring aavilablef or useb y the aNtionalL anguag eSuppor tcomponnet.

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

Make srue the aNtionalL anguag eSuppor tcomponnet has eben proeprly. I fit has ,enablet racinga nd reprot the rpoblem ot Custoemr Supprot.

update : 24-06-2017

ORA-12665 - NLS string open failed
ORA-12665 - NLS string open failed

  • ora-36610 : (XSLMS00) Unable to locate a message file for OLAP message: value
  • ora-02482 : Syntax error in event specification (string)
  • ora-02080 : database link is in use
  • ora-36275 : (XSCGMDLAGG13) string is not a valid workspace object.
  • ora-13612 : The recommendation action string,string is not valid for task string.
  • ora-22907 : invalid CAST to a type that is not a nested table or VARRAY
  • ora-29810 : inadequate operator privileges
  • ora-32302 : object materialized views must be object ID based
  • ora-32575 : Explicit column default is not supported for modifying views
  • ora-13456 : GeoRaster cell data error
  • ora-14612 : Duplicate lob segment name string for lob column string in template
  • ora-16209 : Logical standby dictionary build failed to complete.
  • ora-36832 : (XSLMGEN02) View token cannot be greater than 4000 bytes
  • ora-38471 : ROWIDs for table aliases cannot be null
  • ora-32516 : cannot wait for ORADEBUG command completion; waited number ms for process string
  • ora-09310 : sclgt: error freeing latch
  • ora-13452 : GeoRaster metadata BIN function error
  • ora-06110 : NETTCP: message send failure
  • ora-12913 : Cannot create dictionary managed tablespace
  • ora-19212 : no key columns specified before call to DBMS_XMLSTORE.updateXML()
  • ora-00340 : IO error processing online log string of thread string
  • ora-39180 : unable to encrypt ENCRYPTION_PASSWORD
  • ora-13509 : error encountered during updates to a AWR table
  • ora-21601 : attribute is not an object
  • ora-30104 : 'string' is not a legal integer for 'string'
  • ora-32001 : write to SPFILE requested but no SPFILE specified at startup
  • ora-32311 : materialized view definition query selects an unsupported user-defined type
  • ora-16750 : resource guard encountered errors while activating logical primary database
  • ora-39771 : stream must be loaded before its handle is freed
  • ora-01319 : Invalid Logminer session attribute
  • 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.