I got ” ORA-12705: Cannot access NLS data files or invalid environment specified” error in Oracle database.
ORA-12705: Cannot access NLS data files or invalid environment specified
Details of error are as follows.
ORA-12705: "invalid or unknown NLS parameter value specified" Cause: 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. Action: Check the syntax of the ALTER SESSION command and the NLS parameter, correct the syntax and retry the statement, or specify correct values in the NLS_LANG environment variable.
invalid or unknown NLS parameter value specified
This ORA-12705 errors are related with 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.
Action: Check the syntax of the ALTER SESSION command and the NLS parameter, correct the syntax and retry the statement, or specify correct values in the NLS_LANG environment variable.
Firstly Unset the NLS_LANG environment variable,
Windows – The NLS_LANG must be unset in the Windows registry. 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”
You can set it as follows.
[MSDB]/home/oracle $ export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P9 [MSDB]/home/oracle $ [MSDB]/home/oracle $ echo $NLS_LANG AMERICAN_AMERICA.WE8ISO8859P9
And you can set the nls_date_language parameter as follows. ( you can set the value according to your language )
SQL> alter session set nls_date_language = 'AMERICAN'; Session altered. SQL> show parameter NLS_DATE_LANGUAGE NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ nls_date_language string AMERICAN SQL>
Do you want to learn Oracle Database for Beginners, then read the following articles.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )