64-bit oracle databases cannot be connected with 32-bit plsql developer (oci. dll cannot be loaded), plsqloci. dll

64-bit oracle databases cannot be connected with 32-bit plsql developer (oci. dll cannot be loaded), plsqloci. dll

Install the oracle database in a 64-bit operating system and download a new 64-bit database (if the 32-bit database is installed on a 64-bit operating system, whether it is a client or a server, do not select the path C: \ Program Files (x86), but modify the installation path to remove (x86 ). Install all the way, no problem. After plsql develop is installed, the 32-bit client cannot load the oci. dll file.

To use plsql developer, the oracle client must be installed locally; otherwise, it cannot be used. Therefore, the problem may be that when the oracle database is installed, the client is 64-bit, is inconsistent with plsql developer.

(1) download the oracle client instantclient-basic-nt-11.2.0.3.0 zip.

(2) decompress the package and place the instantclient_11_2 folder in the "F: \ app \ Administrator" directory of the oracle installation directory without modification ".

(3) Put the NETWORK folder in instantclient_11_2, and the NETWORK is tested from the oracle installation directory in "F: \ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ NETWORK. Copy the file to "F: \ app \ Administrator \ instantclient_11_2.

(4) install plsql develop. If you are a 32-bit plsql developer, change the installation path to C: \ Program Files.

(5) After the installation is complete, double-click Run plsql developer and click the cannel button to open it. Modify the oci library under tools-> preferences-> connection, for the oci file at the client you just added, go to the client directory you just installed.

The plsql developer tool cannot connect to the database after the 64-bit Windows 7 OS has oracle11g installed. How can this problem be solved?

Have you installed 64-bit oracle? No
If you want to use win7 64,
You must install the ORACLE 32-bit version.
(If the 64-bit version is installed, PLSQLDEV cannot configure the OCI, and it will always prompt that the operating system does not match. The main reason is that oci. dll is 64-bit, while PL/SQL developer is only 32-bit. An error occurs when the 64-bit oci. dll file is used .)

"Do not place the installation path in a folder such as Program Files (x86"
So I installed the client in the E: \ ORACLE \ *** XX directory. I think this is also the case for installation.
I don't know what will happen if I put it in Program Files (x86), but the fact is that there will always be some Files in it, which can be used later.

Plsql developer cannot connect to oracle. Why is 12154 unable to parse the specified connection identifier?

Is the database local or on the server?

The cmd window and the SQL plus provided by oracle can connect to the database. Is the local network service name used for connection?

Sqlplus user/pwd @ orcl
Or
Sqlplus user/pwd

Is it a 32-bit system or a 64-bit system?

In a 64-bit environment, use PL/SQL Developer to connect to Oracle:
• 1. Download the 32-bit Oracle InstantClient and expand it to a directory, such as C: \ instantclient-basic-nt-11.2.0.2.0;
• 2. Copy the system tnsnames. ora to this directory;
• 3. Set Oracle_Home and OCI Library in PLSQL Developer:
Tools configure Preferences configure Oracle connector Connection:
Oracle_Home: C :\ instantclient-basic-nt-11.2.0.2.0
OCI Library: C :\instantclient-basic-nt-11.2.0.2.0 \ oci. dll
• 4. Create the following bat file in the PLSQL Developer directory, replace the shortcut, and start PLSQL Developer:
@ Echo off
Set path = C: \ instantclient-basic-nt-11.2.0.2.0
Set ORACLE_HOME = C: \ instantclient-basic-nt-11.2.0.2.0
Set TNS_ADMIN = C: \ instantclient-basic-nt-11.2.0.2.0
Set NLS_LANG = AMERICAN_AMERICA.ZHS16GBK
Start plsqldev.exe