[Practical Experience] 64-bit win7 installation + 32-bit Oracle + PL/SQL Solution

Software environment: 64-bit win7, 32-bit Oracle 10g, PL/SQL 9.0.4.1644

In the past, 32-bit systems were used for development and suddenly switched to 64-bit systems. The installation environment was a little troublesome, especially for PL/SQL, which only supported 32-bit systems. I read a lot of materials, but some problems cannot be solved directly. It took a day to complete the installation. Next we will record the problems encountered during the installation process for future reference and hope to help you solve similar problems.

1. Scenario: After Windows 7 is installed, a new user is created. However, after installing Oracle, click net configuration assistant..

　　　 Cause:For permission issues, you must have high-level administrator permissions;

　　　Solution:The administor advanced Administrator account is built in win7. After the installation is enabled, you can install it under this account.

Enabling method: right-click my computer> Manage> Computer Management> System Tools> local users and groups> Users> administrator> Properties] -Cancel [Account Disabled] Select status-restart your computer,

 

 

2.Scenario: When PL/SQL is installed and Oracle cannot be connected, an exception occurs: Oracle-12154

　　　 Cause:PL/SQL is 32-bit and cannot load 64-bit OCI. dll (Oracle file)

Solution:

• Download instantclient-basiclite-win32-10.2.0.4.zip or instantclient-basic-win32-10.2.0.4.zip from the oracleofficial network;
• Decompress the file to "D: \ oracle \ product" (my Oracle installation path is like this );
• Copy tnsnames. ora under "D: \ oracle \ product \ db_1 \ Network \ ADMIN" to "D: \ oracle \ product \ instantclient_10_2 ";
• If you are not logged on, go to PL/SQL developer, go to tools-preferences, and set ORACLE_HOME and OCI library in connection. ORACLE_HOME is set to the decompress directory of instantclient, OCI library is set to the OCI under this directory. DLL;

• • Add environment variables:

Path = D: \ oracle \ product \ instantclient_10_2;

ORACLE_HOME = D: \ oracle \ product \ instantclient_10_2

Tns_admin = D: \ oracle \ product \ instantclient_10_2

Nls_lang = american_america.al32utf8

• • Log on to PL/SQL again;

 

3.Scenario: An error occurred while connecting to Oracle using nhib.pdf in the Code. Oracle-12154 TNS:

Cause:If the ORACLE_HOME variable value in the registry is incorrect, it points to the original path of Oracle, not the path changed in the previous step.

Solution: [Start]-[enter Regedit]-[Press enter]-[search ORACLE_HOME]-[change value to: D: \ oracle \ product \ instantclient_10_2 (set according to your own situation) ]-[restart the machine]

 

(The original homepage is still deleted for me !!!!!!!!!!!!!!)