PLSQL Developer cannot connect 64-bit Oracle 11 GB Solution

PLSQL Developer cannot connect 64-bit Oracle 11 GB Solution

Preface:

PLSQL Developer cannot connect to Oracle Server64bit in two cases. The first case is to install PLSQL on the Oracle Server 64bit database Server, and the second case is to install PLSQL Developer on another machine to connect to the Oracle Server 64bit database Server.

Symptoms:

Initialization error

SQL * Net not properly installed

OracleHomeKey:

OracleHomeDir:

Cause:

Oracle client is 64-bit, while plsql is 32-bit, which is incompatible

Solution 1:

Download the instantclient of the same version as the oracle server and configure PLSQL. Set OCI Library and Oracle_Home in perference-> Connection. For example, set the local machine:

Oracle Home: D: \ app \ oracle \ product \ 11.2.0 \ instantclient_11_2

OCI Library: D: \ app \ oracle \ product \ 11.2.0 \ instantclient_11_2 \ oci. dll

Like other navicat connections to Oracle Server64bit, you also need to specify the instantclient and then specify oci. dll. Refer to the blog: Navicat Premium to connect to the Oracle database.

Note)

If this method is used, the configuration file read by PLSQL is also the configuration file under the instantclient_11_2 directory. For example, the path of my configuration file is:

D: \ app \ oracle \ product \ 11.2.0 \ instantclient_11_2 \ NETWORK \ ADMIN

In this case, using the net configuration assistant and net manager provided by Oracle Server64bit is useless. However, you can configure it in net configuration assistant and overwrite the configured configuration file to the \ instantclient_11_2 \ directory.

For example, you can set three configuration files (listener) in D: \ app \ oracle \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN. ora, sqlnet. ora, tnsnames. ora) overwrites D: \ app \ oracle \ product \ 11.2.0 \ instantclient_11_2 \ NETWORK \ ADMIN

Solution 2:

After installing Oracle Server64bit, install oracle_client_32bit, and place a bet on the Configuration:

Oracle Server64bit configure listener and database connection name testdb

Oracle_client_32bit do not configure the listener. Only the database connection name testdb is configured.

Then install plsql, connect to testdb, and connect normally.

Solution to the second situation

Install oracle_client_32bit, create a database connection, and install plsql developer.

TNS_ADMIN settings

This environment variable is used to set whether to use the tns configuration file. Because we have installed Oracle Server64bit and oracle client 32bit on a machine, there will be two tns configuration files, and the two configuration files will be placed in the following directory:

D: \ app \ oracle \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN

D: \ app \ oracle \ product \ 11.2.0 \ client_1 \ NETWORK \ ADMIN

If TNS_ADMIN is not set, tns of client_1 is used by default.

If you set the environment TNS_ADMIN = D: \ app \ oracle \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN, the above path will change.

After Oracle 10g is installed, restart the system. If PLSQL is used for connection, no listening is reported.

ORA-03114 PLSQL process compilation disconnection Error

Simple configuration of PLSQL connection to Oracle

Detailed description on Performance Improvement of PLSQL batch Forall operations

Use Oracle SQLDeveloper to connect to the database and create a user

Oracle PL/SQL Developer import and export data

Install the Oracle 11g and Oracle SQL Developer clients in 64-bit Windows 7