Oracle Client Management Software Installation

1. First, explain why you should install the Oracle Client Management tool.

Because the Oracle server is too large and consumes too much resources, most companies will install the service on the company's servers rather than on the employees ' computers, so this time it is necessary to use the Oracle Client Management tool to remotely connect to the Oracle service side. To summarize: The Oracle Client Management tool is a tool used to remotely connect to the Oracle server. The following is a brief introduction to several commonly used Oracle clients.

2. Introduction of Oracle Client

(1) SQL Developer

SQL Developer is an Oracle-brought client tool that is automatically installed after Oracle is installed, because the software itself is too large and the user experience is not very good, so fewer people

The diagram on the left is Oracle's own client SQL Developer, and note that to use this client there is a pit where the JDK must be downloaded, and the JDK will have different versions of the JDK because of different versions of Oracle.

I downloaded the JDK8, but this tool may be older and requires 1.5.0~1.6.1 between the JDK

After downloading the JDK, open SQL Developer again and specify the location of the JDK's Java.exe so that SQL Developer can be used normally.

(2) PL/SQL Developer

PL/SQL teaches that the latter is a good cross-platform, but it is relatively large (about 300M) that is very resource-intensive, and the user experience is generally, and PL/SQL is only about 40M and easier to use.

However, using PL/SQL to connect an Oracle database, whether local or remote, requires an Oracle client (around 500M) to be installed, and the configuration file needs to be modified on different operating systems. More trouble.

The following is the installation process

A, first download PL/SQL Developer, and then the idiot installation .... Multiple steps omitted here

B. Ensure Oracle Instant Client installation is complete Click to view installation steps

b, before performing this step, make sure that the listener and the local network Service are configured!!! If not configured, then nothing in the Tnsnames.ora file

Create a new network\admin under Oralce Server installation directory path \instantclient-basic-windows.x64-12.1.0.2.0\instantclient_12_1, Then create a new Tnsnames.ora file (which stores the configuration of the Oracle Local Network Service), which also exists under the Network\admin directory on the Oracle server

Copy the file in the Red box (local network service profile on the server) to the client's admin folder

E. Open the PL/SQL developer tool

Set the Oracle home in the red box to the ORALCE Server installation directory \instantclient-basic-windows.x64-12.1.0.2.0\instantclient_12_1, The decompression path for the Oracle client that was just installed

The OCI library path is the ORALCE server-side installation directory \instantclient-basic-windows.x64-12.1.0.2.0\instantclient_12_1\oci.dll.

F, Setup complete, open PL/SQL developer for login

Landing success

Oracle Client Management Software Installation