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.
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
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]