ORA-12705: Cannot access NLS data files or invalid environment specified error
Free install the Oracle client to use PL / SQL, TOAD FOR oracle connection manager such as Oracle9i, 10g
As we all know, Oralce client a few megabytes too big, there are many online DIR processing. This treatment uses official ORALCE Kit Instant Client Package!
1: Download this, Instant Client Package - Basic package. Then extract to any directory for example: F: \ oracleClient, established in this directory NETWORK folder, then under this folder and then re-establish ADMIN folder, and then service has been established on the tnsnames.ora file to this directory, and modify the IP ;
2: Modify the environment variable to increase Oracle_home = F: \ oracleClient; modify the Path environment variable increase in F: \ oracleClient;
3: Start PL / SQL, there ORALCE logon Cancel Calcel, open PL/SQL- "Perference which set OCI Library and Oracle_home, I set the OCI Library = F: \ oracleClient \ oci.dll, Oracle_home = F: \ oracleClient . Exit back in. Login prompt appears if Oracle Instant Client ORA-12705: Cannot access NLS data files or invalid environment specified error. Amended as follows:
If the Windows platform, the registry \ HKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE find key NLS_LANG, the key standards by the Oracle client installation created value is NA. This led to the ORA-12705 error. The solution is to modify the NA of SIMPLIFIED CHINESE_CHINA.ZHS16GBK.
Linux, if the environment variable NLS_LANG value is NA will cause ORA-12705 error, the workaround is to modify the
set NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK
This article comes from CSDN blog, reproduced, please indicate the source: http://blog.csdn.net/zhengsj/archive/2009/06/01/4231348.aspx