Solution to PLSQL + developer + in win7 + 64-bit + Oracle + 11g + 64-bit
1) install Oracle 11G 64-bit (this part will not be mentioned)
2) install a 32-bit Oracle client (instantclient-basic-win32-11.2.0.1.0)
Download instantclient-basic-win32-11.2.0.1.0.zip (it must be a 32-bit version. Do not download it on the Oracle official website.) decompress it to the product in the Oracle Installation Directory (the local name is instantclient_11_2 ): d: \ oracle \ app \ dd \ product \ instantclient_11_2.
Copy a Directory D: \ oracle \ app \ dd \ product \ 11.2.0 \ dbhome_1 \ Network under the root directory of the database installation to the Oracle Client Directory D: \ oracle \ app \ dd \ product \ instantclient_11_2 (in fact, only network \ admin \ tnsnames is required. ora)
3) install PL/SQL developer
Install PL/SQL developer and set OCI library and ORACLE_HOME in perference-> connection. For example, set the local machine:
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 the nls_lang environment variables, it is best to set them to be consistent with the database. First, query the character set information from the database:
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", set the variable name to "nls_lang", set the variable value to "simplified chinese_china.zhs16gbk", and click "OK ";
2>. Create an environment variable "tns_admin" with the value "D: \ oracle \ app \ dd \ product \ instantclient_11_2"
Click "OK" to exit.
Start PL/SQL developer and run it normally.