Troubleshoot issues that cannot be connected to Oracle DB using Plsql Developer in a Windows X64bit environment

This article is original article, reproduced please indicate the source:

http://blog.csdn.net/msdnchina/article/details/46416455

Troubleshoot issues that cannot be connected to Oracle DB using Plsql Developer in a Windows X64bit environment

Background: Plsql developer does not have a 64bit version, so it can only be connected via a 32bit Oracle client.

Knowledge Point One:

Oracle 32-bit Client on Windows 64-bit OS would be registered under Hyve key ' Wow6432node ' like:--------------------------- ------------------------------hkey_local_machine\software\wow6432node\oracle\key_<oracle Home name>

Reference from:
--how to Verify the Word Size (32bit vs64bit) of the Oracle Binary on MS Windows Systems ( Document ID465060.1)

Knowledge Point two:

F:\oracle\product\10.2.0\client_1\bin\oracle.key file: Oracle.key The contents of the file are as follows: Software\oracle\key_oraclient10g_ HOME1: Indicates the location of the home in the Windows Registry-Personal understanding

Troubleshoot issues that cannot be connected to Oracle DB using Plsql Developer in a Windows X64bit environment