Troubleshooting Plsql connection to 64-bit Oracle

Since the current notebook is mostly 64-bit window7 system, however plsql_developer no 64-bit, which caused the trouble of our connection, here teaches you how to connect win7_oracle11g_64 bit to 32 bit plsql_developer.

I have practiced many times, but have been error:

1. No database instance

2.32-bit client not installed correctly

3. Adapter Error

My tools:

• 64-bit Oracle database already installed

• WINDOW7_64-bit operating system

• Plsql_developer 9.0 + (currently only 32-bit)

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

• • Install your downloaded plsql_developer and click on the Chinese file for Chinese.
    Install well open you will find that your plsql_developer can not connect to the database properly, there is no initialization of the database content:

  • Please unzip the instantclient-basic-win32-11.2.0.3.0 file you downloaded. Then copy the product folder under the folder to your database installation, and mine is:

    F:\app\admin\product\instantclient_11_2.

• 
  

• Then find the two files in oracle11g Listener.ora and tnsnames.ora my in F:\app\admin\product\11.2.0\dbhome_1\ Network\admin inside. are copied to the bottom of the F:\app\admin\product\instantclient_11_2.
  

• Then find your Plsql_developer installed directory, mine is:

  F:\PLSQL_Developer

  Create a new notepad inside and write the following similar code:

  @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 the encoding is Chinese, it is set to Nls_lang=simplefied Chinese_china. AHS16GBK

When you're finished, change the name of your Notepad to Start.bat and click Run.

After opening the Plsql_developer, cancel the login and enter the main interface.

1. Click--Tools--preferences--Connect:

2. Change the above cancellation to submit

The 3.OCI library is changed to a path with instantclient_11_2.

4. Apply--OK--turn off Plsql_developer to run again.

Check the connection selected,

Oracle Home directory Name: f:\app\admin\product\instantclient_11_2 ,

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

Click Apply when the settings are complete. Not configured, the following error is reported:

If you still have problems at this point, you can configure them further: System environment variables

Right-click on My Computer-computer Properties-Advanced system settings-environment variables.

Nls_lang (no words to create a new, some words click-Edit).

Change its variable value to: Simplified Chinese_china. Zhs16gbk

Then click-OK.

tns_admin:oracle root directory \product\11.2.0\dbhome_1\network\admin

ORACLE_SID:ORCL

at this time, Still error-- report ora-12560:tns: Protocol Adapter error

Note: Check file listener.ora and Tnsnames.ora, the need to change is the client--that is, instantclient_11_2, but cannot change these 2 files in Oracle

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

Note: Versions are consistent-that is, the version of Oracle is consistent with the version of the 32-bit client, my version is 11.2.0.1.0

Troubleshooting Plsql connection to 64-bit Oracle