ORA-12705: Cannot access NLS data files or invalid environment specified

Cause : Eihtera n tatepmt aws amdet o sisu eanA LTRE SSESINO cmomadn wtih na ivnaldi NSL praamteero r avlu;e o rth eenivromnen tvairabel(s )NL_SLAGN, ROA_LNSx,x o rORCALEH_OM Ewa sinocrrcetl yspceifeid,t heerfoer teh NSL dtaa ifle scannotb e olcaetd.

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

Chcek hte ysntxa o fth eALETR ESSSOIN ocmmnad nad hte LNS apraemte,r croretc teh snyta xan drerty hte tsatmeen,t o rspceif yth ecorrec tdierctroy apthv/aleus ni teh evnirnometn vraialbes.

update : 29-06-2017

ORA-12705 - Cannot access NLS data files or invalid environment specified
ORA-12705 - Cannot access NLS data files or invalid environment specified

  • ora-19653 : cannot switch to older file incarnation
  • ora-22814 : attribute or element value is larger than specified in type
  • ora-30656 : column type not supported on external organized table
  • ora-06746 : TLI Driver: cannot alloc t_call
  • ora-16503 : site ID allocation failure
  • ora-28120 : driving context already exists
  • ora-01190 : control file or data file string is from before the last RESETLOGS
  • ora-23607 : invalid column "string"
  • ora-27143 : OS system call failure
  • ora-08340 : This command not allowed on nCUBE, only one thread is ever used.
  • ora-13771 : cannot obtain exclusive lock string on "SQL Tuning Set" "string" owned by user "string"
  • ora-24406 : API mode switch is disallowed when a call is in progress.
  • ora-09986 : wrong number of bytes read from SGA definition file
  • ora-24416 : Invalid session Poolname was specified.
  • ora-31158 : schema "string" currently being referenced
  • ora-07276 : no dba group in /etc/group.
  • ora-36164 : (XSMXAGGR07) When using the COUNTVAR clause, the number of variables to be aggregated (number) must match the number of COUNTVAR variables (number).
  • ora-24067 : exceeded maximum number of subscribers for queue string
  • ora-28510 : heterogeneous database link initialization failed
  • ora-09757 : osnipn: port allocation failure.
  • ora-10263 : Don't free empty PGA heap extents
  • ora-30359 : Query rewrite is not supported on SYS materialized views
  • ora-09870 : spini: failure initializing maximum number of open files.
  • ora-29933 : object being disassociated has some user defined statistics stored
  • ora-28110 : policy function or package string.string has error
  • ora-09886 : osnTXtt: translation error while expanding txipc@.trc.
  • ora-12350 : database link being dropped is still mounted
  • ora-22805 : cannot insert NULL object into object tables or nested tables
  • ora-02269 : key column cannot be of LONG datatype
  • ora-39062 : error creating master process string
  • 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.