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