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 : 22-08-2017

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

  • ora-15163 : cluster not in rolling downgrade
  • ora-09845 : soacon: Archmon unable to open named pipe.
  • ora-26093 : input data column size (number) exceeds the maximum input size (number)
  • ora-19641 : backup datafile checkpoint is SCN string time string
  • ora-16038 : log string sequence# string cannot be archived
  • ora-25262 : agent name cannot be NULL if address is a multi-consumer queue
  • ora-23542 : dependent object "string"."string" already registered
  • ora-07574 : szrfc: $GETUAI failure
  • ora-32310 : object materialized views must select from an object table
  • ora-28012 : Manual commit not allowed here
  • ora-10641 : Cannot find a rollback segment to bind to
  • ora-26022 : index string.string was made unusable due to:
  • ora-40223 : data mining model import failed, job name=string, error=string
  • ora-25469 : data not specified for alias: string column name: string
  • ora-01643 : system tablespace can not be made read only
  • ora-39125 : Worker unexpected fatal error in string while calling string [string]
  • ora-37171 : dimension sources not specified
  • ora-06250 : NETNTT: cannot allocate send and receive buffers
  • ora-27144 : attempt to kill process failed
  • ora-04084 : cannot change NEW values for this trigger type
  • ora-16509 : the request timed out
  • ora-16656 : higher DRC UID sequence number detected
  • ora-25254 : time-out in LISTEN while waiting for a message
  • ora-29288 : invalid file name
  • ora-01198 : must specify size for log file if RESETLOGS
  • ora-16713 : the resource guard timed out while servicing the request
  • ora-24092 : invalid value string specified
  • ora-32022 : parameter value longer than string characters
  • ora-07441 : function address must be aligned on string byte boundary
  • ora-32104 : cannot retrieve OCI error message
  • 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.