Oracle 64-bit, PSL cannot be connected

For Windows 64-bit Oracle 11G 64-bit, PLSQL developer has the following problems:

1. The database drop-down box is blank:

2. Enter the username, password, and database. The logon dialog box is displayed:

Reference initialation Error
Cocould not initialize
"...."
Make sure you have the 32 bits Oracle client installed.

Oraclehomekey:
Oraclehomedir :...
Found: OCI. dll
Using:
...
Loadlibrary (...)
Returned 0

PLSQL developer does not support Oracle 64-bit client connection.
Solution:

1. Download a 32-bit Oracle client
In fact, you can download the free installation version, http://www.oracle.com/technetwork/topics/winsoft-085727.html
I downloaded the first one: http://download.oracle.com/otn/nt/instantclient/112030/instantclient-basic-nt-11.2.0.3.0.zip
Download requires logon. You must register an account in Oracle before downloading!

2. Decompress
Decompress the downloaded package, for example, to E: \ app \ instantclient_11_2.

3. Set PLSQL developer
Input in tool-preference, connection, OCI Library
E: \ app \ instantclient_11_2 \ OCI. dll
For example:
.....

4. Add Environment Variables
Add Environment Variables
Add two system variables:
The first is to point to the directory where the TNS file is located. This directory is the directory where the TNS file of the 64-bit version of Oracle you installed is located. The TNS file stores the connection information.
Tns_admin value: e: \ app \ oyk \ product \ 11.2.0 \ dbhome_1 \ Network \ admin
The second is the encoding used by the specified database. If the value is not set to the following, all the Chinese content you see after connecting to the database will be garbled and will be a bunch of question marks.
Nls_lang value: Simplified chinese_china.zhs16gbk
Note:After setting the environment variables, you must log off or restart your computer to make the settings take effect!

The above test passes in win7x64. After four steps, you can connect the Oracle database of the local machine and other machines.