Pl-sql Developer Configuration using Oracle client connections

Users who do not have Oracle installed locally must download a instantclient (even the client), and the path points to it for normal use

Download Instantclient-basic-nt-11.2.0.3.0.zip

Unzip to D:\Oracle\instantclient_11_2

First open the Plsql interface pop-up login box This time you very impulsive entered the correct user name password, as well as the IP address port number, But when you click OK, it pops up as shown in the first figure below. This means that you do not have an Oracle client installed on your computer or that the Plsql tool preferences are not configured correctly. So the direct point cancellation, Plsql will automatically open the software as shown in the second figure. You'll see the top left tip of the software is not logged in.

Oracle client does not have correct installation prompts

Click Cancel without logging into the software interface

Click →connection→ to fill in the following two things:

Oracle Home: Fill out the Client installation directory
OCI Library: Complete the client installation directory Oci.dll

Also add a Tnsnames.ora configuration
In the immediate client directory, create a new folder network, the network in the new admin, in the admin directory, a suffix named. ora file: Tnsnames.ora

\instantclient_11_2\network\admin\tnsnames.ora

Notepad opens and the content is added as follows:

# Tnsnames.ora Network Configuration File:d:\oracle\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.


ORCL =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521))
)
(Connect_data =
(service_name = ORCL)
)
)


Test-name =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.10) (PORT = 1521))
)
(Connect_data =
(service_name = ORCL)
)
)

One of the following test-name changes to the name you want to see in the Login display box, and the host changes to the IP of the database you want to connect to

Pl-sql Developer Configuration using Oracle client connections