what is oracle client

Oracle client is a tool that interacts with the server, allowing remote connection to the underlying database of the application; the interaction process refers to the statement executed by the client being transmitted to the server, and the server executes the operation after parsing and Output the execution results to the client.

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

What is the Oracle client

In this case, the client is a class library (DLL) that allows you to remotely connect to the application's underlying database

Client The client is just a tool that interacts with the server, such as sqlplus. SQL statements are executed in sqlplus and sent to the server. The server parses and executes the operations in the SQL, and outputs the operation results to the client. This completes the interaction process between the client and the server. To put it simply, the client is like a remote desktop tool. It is only responsible for providing an interface to connect to the backend server. The specific processing operations are all on the server~

The oracle client is not absolute, it is just an interface that can be connected to Oracle Server tools

oracle client only refers to the tool that interacts with the server. To log in and use the oracle database service, you need to install the client (such as PLSQL) and use PLSQL to connect to the database to perform some additions to the oralce service. Delete, modify, check and other operations.

oracle client, divided into two types:

The first one provides the client for installation, for windows system

1. Change %ORACLE_HOME% Add lib to the PATH environment variable.

2. Add %ORACLE_HOME%jdbclibclasses12.jar to the CLASSPATH environment variable. You can also copy classes12.jar to the commanlib directory of tomcat.

The second type, streamlined client, does not require installation, just decompress it and use it

For Windows system (assuming decompression is on the d drive):

1. Put d: Add instantclient_10_2 to the PATH environment variable

2. Add d:instantclient_10_2classes12.jar to the CLASSPATH environment variable. You can also copy classes12.jar to the commanlib directory of tomcat.

Recommended tutorial: "Oracle Video Tutorial"

The above is the detailed content of what is oracle client. For more information, please follow other related articles on the PHP Chinese website!