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

by

There are two possible causes:

An attempt was made to issue an ALTER SESSION statement with an invalid NLS parameter or value.

The NLS_LANG environment variable contains an invalid language, territory, or character set.

Fix:

Unset the NLS_LANG environment variable

Windows – The NLS_LANG must be unset in the Windows registry (re-named is best). Look for the NLS_LANG subkey in the registry at \HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE, and rename it.

Linux/UNIX – Here you simply issue the Linux command “unset NLS_LANG”

More Related Contents:

  1. Calculate difference between 2 date / times in Oracle SQL
  2. Can you SELECT everything, but 1 or 2 fields, without writer’s cramp?
  3. How to generate entire DDL of an Oracle schema (scriptable)?
  4. How to get records randomly from the oracle database?
  5. Oracle PL/SQL – Raise User-Defined Exception With Custom SQLERRM
  6. Auto Increment for Oracle
  7. Get resultset from oracle stored procedure
  8. Deploying and Configuring ODP.NET to work without installation with Entity Framework
  9. Add a auto increment primary key to existing table in oracle [duplicate]
  10. ways to avoid global temp tables in oracle
  11. Spring Batch ORA-08177: can’t serialize access for this transaction when running single job, SERIALIZED isolation level
  12. How to generate an entity-relationship (ER) diagram using Oracle SQL Developer
  13. String to date in Oracle with milliseconds
  14. Error while trying to retrieve text for error ORA-01804
  15. Create Pivot view in SQL from a SQL table
  16. Does Oracle support full text search?
  17. Oracle.ManagedDataAccess.EntityFramework – ORA-01918: user ‘dbo’ does not exist
  18. Why doesn’t PL/SQL respect privileges granted by Roles?
  19. ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
  20. Can We use threading in PL/SQL?
  21. Speed up to_sql() when writing Pandas DataFrame to Oracle database using SqlAlchemy and cx_Oracle
  22. What is the algorithm used by the ORA_HASH function?
  23. oracle SQL plus how to end command in SQL file?
  24. Why is the GETDATE() an invalid identifier
  25. ORA-04091: table [blah] is mutating, trigger/function may not see it
  26. How to use parameters in a ‘where value in…’ clause?
  27. How to call an Oracle function with a Ref Cursor as Out-parameter from C#?
  28. How to Register Pluggable Database(PDB) with new created LISTENER
  29. Grant Select on all Tables Owned By Specific User
  30. ORA-12704: character set mismatch

Leave a Comment