Solutions for using plsql+developer+ under win7+64 bit +oracle+11g+64
1) Install Oracle 11g 64-bit
2) Installing the 32-bit Oracle Client (instantclient-basic-win32-11.2.0.1.0)
Download Instantclient-basic-win32-11.2.0.1.0.zip (must be 32-bit, do not make the wrong version, the Oracle website has downloaded), Unzip it to product under the Oracle installation directory (this machine is named: instantclient_11_2): D:\Oracle\app\dd\product\instantclient_11_2.
Copy a directory under the root directory of the database installation D:\Oracle\app\dd\product\11.2.0\dbhome_1\NETWORK to the Oracle client directory D:\Oracle\app\dd\product\ Instantclient_11_2 (in fact only need 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 settings:
Oracle home:d:\oracle\app\dd\product\instantclient_11_2
OCI Library:d:\oracle\app\dd\product\instantclient_11_2\oci.dll
4) Set Environment variables (Modify environment variables)
For Nls_lang environment variables, it is best to set to the same as the 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 My Computer-Properties-advanced-environment variables-system environment variables:
1> Click "New" and the variable name is set to "Nls_lang" and the variable value is set to "simplified Chinese_china. ZHS16GBK ", click" OK ";
2>: New environment variable "tns_admin" with a value of "D:\Oracle\app\dd\product\instantclient_11_2"
Finally click "OK" to exit.
Start PL/SQL Developer and run without problems.
Old question: 64 run Plsql for the machine
