32-bit Plsql link oralce database 64-bit error

Solution: Plsql does not support 64-bit, download 32-bit client files

Then use the Plsql connection database to try, found that no connection permissions are optional,

Enter the user name, password, and database name directly, as prompted below:

Description Plsql is not able to connect directly to the 64-bit Oracle database and can only connect 32-bit. Now that you have installed 64-bit Oracle, you can not uninstall the 32-bit, then how to connect 64-bit, it can only be achieved with the help of 32-bit clients. Here's how to share this with you:

1. Download the 32-bit Oracle client first

: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html ,

Be sure to download the red flag of 32-bit that, click to find the appropriate version of the existing database to download the file, I installed the oracle11.2.0.1, so

Right click Thunder Download can, not big, seemingly 49M a little bit more.

2. After the download is complete, directly extracted to a hard disk directory, such as E:\, the following e-disk as an example, after the decompression completed, in the E-disk directory with a instantclient_11_2 directory, and then in the Instantclient_11_2 directory under the new two-tier folder \network \admin, install the Oracle root directory that is already installed \product\11.2.0\dbhome_1\network\admin\tnsnames.ora

The file is copied over.

3. Configure preferences for Plsql

Open Plsql, click Cancel to not connect to the database. After entering, find the tools preferences in the toolbar,

Check the connection selected,

Oracle Home directory Name: E:\instantclient_11_2,

OCI Library: E:\instantclient_11_2\oci.dll

Click Apply when the settings are complete.

4. Add Environment variables

Right-click the computer---Properties---advanced system settings---Advanced tab environment variables,

Add two variables to a system variable:

Tns_admin:oracle root directory \product\11.2.0\dbhome_1\network\admin

Nls_lang:simplified Chinese_china. Zhs16gbk

Click OK.

5. Restart the computer, restart Plsql, you will have unexpected surprises ~~~try it! Good luck! O (∩_∩) o~