Solve the problem that PLSQL Developer cannot be used to connect to Oracle DB in Windows x64bit environment, x64bitplsql

Solve the problem that PLSQL Developer cannot be used to connect to Oracle DB in Windows x64bit environment, x64bitplsql

This article is an original article. For more information, see the source:

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

 

Solve the problem that PLSQL Developer cannot be used to connect to Oracle DB in Windows x64bit Environment

 

Background: PLSQL Developer does not have 64-bit versions. Therefore, it can only be connected through a 32-bit Oracle Client.

Knowledge Point 1:

Oracle 32-bit Client on Windows 64-bit OS will be registered under hyve key 'wow6432node' like: --------------------------------------------------------- HKEY_LOCAL_MACHINE \ SOFTWARE \ Wow6432Node \ ORACLE \ KEY _ <Oracle Home Name>

 

Reference:
-- How To Verify the Word Size (32bit vs64bit) of the Oracle Binary on MS Windows systems (document ID465060.1)

 

 

Knowledge Point 2:

F: \ oracle \ product \ 10.2.0 \ client_1 \ bin \ oracle. key File: oracle. key the file content is as follows: SOFTWARE \ ORACLE \ key_1_lient10g_home1 indicates the location of the HOME in the Windows registry-personal understanding