"Cannot access NLS data files or invalid enviro" appears in the Oracle client tool.

Source: Internet
Author: User


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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.