PL/SQ can only use 32-bit Oracle clients. 64-bit Oracle 11g is installed under 64-bit systems, and 32-bit Oracle clients are required to be installed with PL/SQL.
Test success as follows:
1) Install the 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, the Oracle website is downloaded), unzip it to the Oracle installation directory of product (native named : instantclient_11_2): D:/oracle/< Span style= "Width:auto; Height:auto; Color: #0000ff; font-size:14px; Float:none; " >app /ym/product/instantclient_11_2.
Copy database Install a directory under the root directory d:/oracle/app/ym/product/11.2.0/db home _1/network to the Oracle client directory d:/oracle/app/ym/product/instantclient_11_2 (in fact, it only requires network/admin/ Tnsnames.ora)
2) 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
3) Set environment variable (modify path and tns_admin environment variable) .
for Nls_lang environment variables, preferably set to and < Span style= "Width:auto; Height:auto; Color: #0000ff; font-size:14px; Float:none; " > The database is consistent, 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/instantclient_11_2; "join;
2 > ", the variable value is set to" Tns_admin oracle/app/ym/product/instantclient_11_2; ", click" OK ";
3> Click "New" and the variable name is set to "Nls_lang" and the variable value is set to "simplified Chinese_china. ZHS16GBK ", click" OK "; Finally click "OK" to exit. Start PL/SQL Developer and run without problems.
64-bit operating system installs 32-bit clients and PL/SQL