ORA-12705: Cannot access NLS data files or invalid environment specified Oracle V 12.2.0.7 Windows 10

Question

I am trying to login into sqlplus at the windows command prompt and get the ORA-12705 error. I have tried setting the NLS_LANG variable to a couple of times (as shown below) with no success.

set NLS_LANG=american_america.US8PC437

set NLS_LANG=ENGLISH_UNITED KINGDOM.WE8MSWIN1252

I have searched the install log files to see if I can find the NLS settings at installation time and couldn't find any details.

The NLS settings in the init.ora are shown below.

nls_language="ENGLISH" nls_territory="UNITED KINGDOM"

Any help on how / what value to set the nls variables to would be really appreciated.

Thanks

Glyn.

Answer 1

my guess would be to open Windows registry HKEY_LOCAL_MACHINE\SOFTWARE\Oracle<your_client> and to check what NLS_LANG parameter set to. Then set it in the command window.

Anotther try would be to unset this parameter by just renaming it in the registry to. Like "old_NLS_LANG" or something similar.

Please don't do that on production server without trying on a test environment