Solve the Problem of connecting 64-bit Oracle with PLSQL, and connecting 64-bit oracle with plsql

Source: Internet
Author: User

Solve the Problem of connecting 64-bit Oracle with PLSQL, and connecting 64-bit oracle with plsql

Since most of the current laptops are 64-bit Windows 7 systems, PLSQL_Developer does not have 64-bit, which causes us to connect. Here we will teach you how to connect win7_oracle11g_64-bit to 32-bit PLSQL_Developer.

I have practiced it many times, but I have always reported the following error:

1. No database instance

2. The 32-bit client is not correctly installed.

3. Adapter Error

My tools:

  • 1. 64-bit Oracle database installed

  • 2. window7_64-bit Operating System

  • 3. PLSQL_Developer 9.0 or later (currently only 32-bit)

  • 4. The official instantclient-basic-win32-11.2.0.1.0 file (this is a 32-bit Oracle client) -- go to the official website to download the corresponding version, but must be the basic version !!

    • Install the PLSQL_Developer file you downloaded and click the Chinese file for localization.
      After the installation is enabled, you will find that your PLSQL_Developer cannot connect to the database normally and there is no database initialization content ,:

    • 1. Unzip the instantclient-basic-win32-11.2.0.3.0 file you downloaded. Copy it to the product folder installed in your database. Mine is:

      F: \ app \ admin \ product \ instantclient_11_2.


  • 2. Find the two listener. ora files and tnsnames. ora files in Oracle11g. My files are in F: \ app \ admin \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN. Are copied to F: \ app \ admin \ product \ instantclient_11_2.

  • 3. Find the installation directory of your PLSQL_Developer. Mine is:

    F: \ PLSQL_Developer

    Create a notebook in it and write the followingSimilarCode:

    @ Echo off
    Set path = F: \ app \ admin \ product \ instantclient_11_2
    Set ORACLE_HOME = F: \ app \ admin \ product \ instantclient_11_2
    Set TNS_ADMIN = F: \ app \ admin \ product \ instantclient_11_2
    Set NLS_LANG = AMERICAN_AMERICA.AL32UTF8
    Start plsqldev.exe


  • If it is a Chinese encoding, set it to NLS_LANG = SIMPLEFIED CHINESE_CHINA.AHS16GBK.

  • After writing it, change the name of your notepadStart. bat and click Run.

    4. Open PLSQL_Developer, cancel login, and enter the main interface.

    1. Click -- tool -- preferences -- connection:

    2. Change the above cancellation to submit

    3. Change the OCI Library to the path with instantclient_11_2.

    4. Run the application -- OK -- disable PLSQL_Developer and run it again.


    Check the selected connection,

    Oracle main directory name: F: \ app \ admin \ product \ instantclient_11_2,

    OCI Library: F: \ app \ admin \ product \ instantclient_11_2 \ oci. dll

    After completing the settings, click Apply. If no configuration is correct, the following error will be reported:


  • If the problem persists, configure the system environment variable.

  • Right-click my computer-computer properties-advanced system settings-environment variables.

    NLS_LANG (If NO, create one. If yes, click Edit ).

    Change its variable value to: SIMPLIFIED CHINESE_CHINA.ZHS16GBK

    Click -- OK.

    TNS_ADMIN: oracle root directory \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN
  • Oracle_sid: orcl

  • At this point, an error still occurs -- The ORA-12560: TNS: protocol adapter error is reported

  • Note: Check the listener. ora and tnsnames. ora files. What needs to be changed isInstantclient_11_2, but the two files in Oracle cannot be modified.

  • HOST = localhost in Oracle, and HOST = XXXX in the file under the 32-bit client (own HOST name)

  • Note: The version must be consistent-that is, the version of Oracle must be consistent with that of the 32-bit client. My version is 11.2.0.1.0.




  • Finally, restart PLSQL.

  • 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.