Install no Oracle clients connect oracle9i with Pl/sql,toad for Oracle, 10g
As we all know, oralce client hundreds of trillion too large, online also has a lot of dir processing. The processing here is provided by the official Oralce Toolkit instant Client package!
Download Address: http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html
1: Download this, Instant Client package-basic package. Then extract to any directory such as: F:/oracleclient, in this directory to create a network folder, and then the folder and then set up the Admin folder, and then the service has been established Tnsnames.ora files to this directory, and modify IP;
2: Modify the environment variable to increase the oracle_home=f:/oracleclient; Modify the PATH environment variable to increase the f:/oracleclient;
3: Start Pl/sql, appear oralce logon press Cancel Calcel, open pl/sql-perference inside set OCI Library and Oracle_home, my setting is OCI library=f:/ Oracleclient/oci.dll,oracle_home=f:/oracleclient. Quit landing again. Login Tip If an Oracle Instant Client appears ora-12705:cannot access NLS data files or invalid environment specified error. Modified as follows: If the Windows platform, the registry/hkey_local_machine/software/oracle lookup key Nls_lang, this key was created by the ORACLE standard client installation, the value is NA. This led to a ORA-12705 error. The solution is to modify na to simplified Chinese_china. ZHS16GBK. Linux If the environment variable Nls_lang value is na will cause ORA-12705 error, the solution is to modify the set nls_lang=simplified Chinese_china. ZHS16GBK
Article references from: http://blog.csdn.net/lord_is_layuping/archive/2008/07/01/2601869.aspx