[Oracle] [Oracle client without installation] ORA-12705: cannot access NLS data files or invalid environment specified Error

Error in ORA-12705: cannot access NLS data files or invalid environment specified

 
Oracle client installation-free use of PL/SQL, toad for Oracle and other managers to connect Oracle9i, 10g, 11g

As we all know, the oralce client is several hundred megabytes too large, and there are many dir processing on the Internet. Here we use the official oralce toolkit Instant Client package!

: Http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html

1: download this, Instant Client package-Basic Package. Decompress the package to any directory such as F:/oracleclient, create a network folder under this directory, create an admin folder under this folder, and then create tnsnames on the service. add the ora file to this directory and modify the IP address;

2: Add ORACLE_HOME = F:/oracleclient to change the environment variable; add F:/oracleclient to change the path environment variable;

3: Start PL/SQL. When oralce logon presses cancel calcel, open PL/SQL-"perference to set OCI library and ORACLE_HOME. My settings are OCI library = F: /oracleclient/OCI. DLL, ORACLE_HOME = F:/oracleclient. Log out and log on again. Login prompt if Oracle Instant Client appears ORA-12705: cannot access NLS data files or invalid environment specified error. Modify as follows:

For Windows, the/HKEY_LOCAL_MACHINE/software/Oracle search key nls_lang in the registry is created by installing the Oracle standard client with the value of Na. This caused a ORA-12705 error. The solution is to change na to simplified chinese_china.zhs16gbk. Of course, you can also add nls_lang = simplified chinese_china.zhs16gbk to the environment variable.
 
In Linux, if the environment variable nls_lang value is Na will cause a ORA-12705 error, the solution is to modify set nls_lang = simplified chinese_china.zhs16gbk

 

The specific setting method can also be referred here: http://blog.csdn.net/xys_777/archive/2010/08/03/5784296.aspx