When Windows x64 PL/SQL is connected to oralce, the error "cocould not initialize" % ORACLE_HOME % \ bin \ OCI. dll "is returned"

Source: Internet
Author: User
Tags windows x64

After Oralce is re-installed on Windows 7x7, the following error message is displayed when you connect to the database through PL/SQL.


64-bit Windows 7

Oracle win64 11gR2

PL/SQL v9.0

Detailed error message [Plain]View

  1. Initialization error
  2. Cocould not initialize "C: \ oracle \ product \ 11.2.0 \ dbhome_1 \ bin \ oci. dll"
  3. Make sure you have the 32 bits Oracle Client installed.
  4. OCIDLL forced to C: \ oracle \ product \ 11.2.0 \ dbhome_1 \ bin \ oci. dll
  5. Loadlibrary (C: \ oracle \ product \ 11.2.0 \ dbhome_1 \ bin \ OCI. dll) returned 0
The cause of the problem is that Oracle's oci. dll is 64-bit after installation, and the 32-bit application PLSQL Developer cannot load it. Solution 1. Download Oracle from http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
Client Package. I downloaded the Instant Client for Microsoft Windows (32-bit) unzip instantclient-basic-nt-11.2.0.zip] 2. unzip the instantclient-basic-nt- to c: \ oracle, oci. dll Directory: c: \ oracle \ instantclient_11_2 \ 3. set the environment variable TNS_ADMIN = c: \ oracle \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN NLS_LANG = AMERICAN_AMERICA.ZHS16GBK ( Note: The first half of NLS_LANG must be AMERICAN_AMERICA, Because instant client does not support other languages. The latter half can be adjusted based on the character set of your database. If the database uses AL32UTF8, you can set AL32UTF8.4) Start PL/SQL Developer and click "cancel". Choose "Tools"> "Perferences"> "Connection" to modify the configurations of Oracle_Home and OCI Library:
OracleHome: OraDb11g_home1
OCI library: C: \ oracle \ instantclient_11_2 \ oci. dll5. restart PL/SQL and log on to the corresponding database. The connection is normal. The problem is solved successfully! From: http://blog.csdn.net/hemingwang0902/article/details/7027543
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.