Oracle 64-bit, PSL cannot be connected

Source: Internet
Author: User
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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.