Plsql Developer installation, Tnsnames.ora configuration solution

The prerequisite is that you have installed the Plsql-developer tool, install the PLSQL program I believe everyone will

Normal Login window:

When your diagram is:

You cannot connect to the database without this option. If you do not have Oracle installed, there will be one less option "Connect as" and if you have an Oracle client installed, ignore that experience because the Plsql tool will automatically find the configuration information for Oracle from the system registry, no, as shown in the first picture , there is a second picture (or maybe an individual machine, even if the Oracle client is installed or not, so you need to manually add the Oracle's parameter profile), so how can you not install the Oracle client to implement the database connection?

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 tools → preferences → connection → fill in these two items:
Oracle Home directory name: Fill in the Oracle installation directory
OCI Library: Fill in the file path plus/oci.dll

Fill in the Oracle Storage directory display:

Apply, determine:



When re-opening the Plsql program, if you see the interface as shown, careful you will find below an option "Connect as"



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

Instantclient

Address

Download Instantclient-basic-nt-11.2.0.3.0.zip

Unzip to D:\Oracle\instantclient_11_2 (the directory you defined)

Oracle's directory points to this instantclient (instant client) directory

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 with the content 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 =
      (SERVI Ce_name = ORCL)
   
 )


Test-name =
  (DESCRIPTION =
    (ADDRESS _list =
      (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.10) (PORT = 1521))
   )
&nbs P   (Connect_data =
      (service_name = ORCL)
   )
 )

One of the following test- Name change 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

Plsql Developer installation, Tnsnames.ora configuration solution