Plsql Unable to connect 64-bit Oracle Database solution

This is a system that WIN8 64 bits a second. Then there's a 64-bit oracle11g,oracle11g. Download page: http://www.oracle.com/technetwork/database/enterprise-edition/ downloads/index.html , find a suitable database for their own system, you need to download file1 and file2, compressed into the same folder to install, or not install.

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 \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~

Originated in: http://blog.sina.com.cn/s/blog_475839a50101hoyg.html Afantou's blog

If the system can open the login page normally but cannot log on to the system, prompting "login error", but PL/SQL is already connected you need to do the following:

such as E:\instantclient_11_2 This is a 32-bit client; Then you need to add the address of the client to the environment variable

Add the above path to the system's environment variable path.

Then run the program, the program will follow the path path to find Oci.dll, the program will automatically find 32-bit or 64-bit oci.dll can connect to the database.

There's another way: if it's too much trouble, install a 32-bit server version

Plsql Unable to connect 64-bit Oracle Database solution