PLSQL cannot connect to Oracle 11g database-Solution

Problem description:

I have installed the Oracle 11g R2 Database Service on my PC. I cannot connect to the database through PL/SQL. The following describes the installation environment.

PC operating system: Window7 (64bit)

Oracle Server version: Oracle 11g R2 (installation directory: D: \ oracle \) (64bit)

PL/SQL version: pl SQL 10.0.

After configuring the tnsnames. ora file of oracle (D: \ oracle \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN \), the content is as follows:

# Tnsnames. ora Network Configuration File: D: \ oracle \ product \ 11.2.0 \ dbhome_1 \ network \ admin \ tnsnames. ora
# Generated by Oracle configuration tools.

DAVID =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521 ))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = david)
)
)

Configure Oracle Home and Oracle library in the Tools --> Preferences window, as shown in:

The oracle service name DAVID cannot be detected on the PL/SQL login interface, for example:

After the "Enter" key, the following error prompt box is displayed, for example:

Problem Analysis

Since PLSQL does not have a 64-bit version, an error will be reported when connecting 64-bit Oracle through 32bit PLSQL. A 32-bit oracle client tool instantclient is required for conversion.

Problem Solving

1. Download the oracle client

Download instantclient-basic-win32-10.2.0.5.zip: http://www.oracle.com/technetwork/topics/winsoft-085727.html

2. Install instantclient

Decompress the installation package instantclient-basic-win32-10.2.0.5.zip, and decompress the Directory: D: \ Program Files \ destination files \ oracleclient

Create a Directory D: \ Program Files \ destination files \ oracleclient \ NETWORK \ ADMIN

3. Copy tnsnames. ora

Copy the tnsnames. ora file under the D: \ oracle \ product \ 11.2.0 \ dbhome_1 \ NETWORK \ ADMIN directory to the D: \ Program Files \ destination files \ oracleclient \ NETWORK \ ADMIN directory

4. Configure PLSQL

Open the Tools --> Preferences window to configure Oracle Home and Oracle library, such:

Oracle Home: D: \ Program Files \ destination files \ oracleclient

Oracle library: D: \ Program Files \ destination files \ oracleclient \ oci. dll

5. Restart PLSQL

Restart PLSQL and the service name of the DAVID database appears on the Oracle login interface, for example:

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