Oracle Learning (iii) installation of PLSQL Developer client

1. Download the Oracle Client

a) : http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html, click Connect to enter the following page appears. Select the first instant Client for Microsoft Windows (32-bit) to download it, please do not download 64bit, I tried, can not implement the connection.

b) directly extracted to your installed directory, this client does not need to install, the direct decompression configuration can be used, such as extracting into the D:\JavaDevTools\instantclient_11_2 directory, and then in Instantclient_11_2 directory under the new two-tier folder \network\admin, and then under the Admin folder to build a tnsnames.ora file, Then add the following to the file:

ORACLE = (  DESCRIPTION = (    ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))    (Connect_data =      (SERV ER = dedicated)      (service_name = ORACLE)    )  listener_oracle =  (ADDRESS = (PROTOCOL = TCP) (HOST = localhost ) (PORT = 1521)) Oraclr_connection_data =  (DESCRIPTION = (    address_list = (      ADDRESS = (PROTOCOL = IPC) (KEY = EXT PROC1521))    )    (Connect_data =      (SID = Clrextproc)      (PRESENTATION = RO)  ))

The above content can be copied in this place:D:\JavaDevTools\oracle11g\app\oracle\product\11.2.0\server\network\ADMIN\ Tnsnames.ora This completes the configuration of the Oracle client and is truncated to configure the PL/SQ Developer Client tool

2. Download and unzip the installation of the PL/SQL Developer Client Tool

The first login will fail because we have not yet configured the information for this client, so we click Cancel to go in non-login mode (i.e. first go to the interface where the software is not logged in), then click Tools and select the Preference option as shown:

Then as configured

Click "Apply" and then click "OK" to complete the configuration. Quit the program and start again.

3. Verify that the installation is successful

Start the SQL Query window to test that the client is successfully connected to the database

If present, the installation configuration is successful.

Oracle Learning (iii) installation of PLSQL Developer client