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

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.