Solution to the Oracle client tool "Cannot access NLS data files or invalid environment specified" error: After the Oracle client tool Navicat for Oracle is installed a few days ago, no errors have been found, when I installed it on the computer in the school data center, the error occurred. At first, I thought the dll files were not properly configured, I re-configured and checked the dll files written in the previous blog. I think there is nothing to do with this. When I open the software again, it is still that error, it seems that only the Internet can find a solution. After several minutes of searching, the solution is finally found. Next I will discuss the solution: first when using the tool to create a new connection, click the "connection test" button, the following error will appear: ORA-12705: cannot access NLS data files or invalid environment specified. :
In fact, this error occurs not only in this software, but also in other client tools. The cause of the error may be that other Oracle versions are installed in the system, the registry settings of a certain item are incorrect, and the database of Oracle 9i is installed on the computer of the school data center, which leads to the above error. The solution is simple. You only need to modify the registry. First, press Win + R in Windows to open the run dialog box, enter the "regedit" command, open the registry, and find the following location in sequence: www.2cto.com \ HKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE search key "NLS_LANG", which is created by the Oracle standard client and the value is NA. This is why the ORA-12705 error occurs. You just need to change its value (NV) to "SIMPLIFIED CHINESE_CHINA.ZHS16GBK. :
However, it is not difficult to make such changes every time. Therefore, we write a registry file with the following content:
Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE] "NLS_LANG" = "SIMPLIFIED CHINESE_CHINA.ZHS16GBK" save the file as "Oracle. reg ". You only need to double-click the file to modify the registry. By the way, you must configure the dll files. Otherwise, other errors may occur.