Oracle 11g 64-bit installation of 32-bit clients and PL/SQL

Tag:c   a   http   com    use     data    

Transfer from:http://www.360doc.com/content/14/0602/10/4903283_382949382.shtml  This you need to install a 32-bit Oracle client to use Plsql, But at this time sqlplus can not be used, hehe .  I tried the following method, successfully, haha  1) install Oracle 11g 64-bit  2) Install 32-bit Oracle client ( instantclient-basic-win32-11.2.0.1.0)  :http://www.oracle.com/technetwork/cn/topics/ winsoft-095945-zhs.html  Download Instantclient-basic-win32-11.2.0.1.0.zip (must be 32-bit, do not make the wrong version, Oracle official website has downloaded), Unzip it to product under the Oracle installation directory (this machine is named: instantclient_11_2): D:\Oracle\app\YM\product\instantclient_11_2.   Copy a directory under the root directory of the database installation D:\Oracle\app\YM\product\11.2.0\dbhome_1\NETWORK to the Oracle client directory D:\Oracle\app\YM\product\ Instantclient_11_2 (in fact only needs Network\admin\tnsnames.ora)  3) Install PL/SQL developer  install PL/SQL Developer, Set up OCI library and Oracle_home in Perference->connection, for example, native set to:  oracle home:d:\oracle\app\ym\product\ INSTANTCLIENT_11_2 OCI library:d:\oracle\app\ym\product\instantclient_11_2\oci.dll 4) Set environment variables ( Modify path and tns_admin environment variable)   for Nls_lang environment variables, it is best to set to the same database side, first query the character set information from the database side: sql> Select USErenv (' language ') Nls_lang from dual; nls_lang ----------------------------------------------------  simplified Chinese_china. zhs16gbk  Right-click on "My Computer"-"Properties"-"advanced"-"Environment variables"-"System environment variables":  1> Select "Path"-click "Edit" to "D:\Oracle\app\YM\product\instan tclient_11_2;  2> Click "New", the variable name is set to "Tns_admin", the variable value is set to "D:\Oracle\app\YM\product\instantclient_11_2;", click "  3> Click New, the variable name is set to "Nls_lang", and the variable value is set to "simplified Chinese_china. ZHS16GBK ", click" OK ";  finally click" OK "exit .   start PL/SQL Developer, run no problem.