Three installation and connection methods of Oracle ~

Oracle servers generally include the following three installation methods:

• Host-Based Mode: In this configuration, you can directly log on to the Oracle database on the computer where the database is installed.
• Client-server (two-layer model): databases and client terminals are installed on different computers. Users can access databases from their personal computers (clients) over the network.
• Client-Application Server-server (layer-3 Model): Users first log on to the application server from their personal computers, and then access the real database through the application server.

The connection is the communication path between the user and the Oracle server. Corresponds to the three installation methods of the Oracle server. A database user may use one of the following three methods to connect to the Oracle server.

• Host-Based Mode: At this time, the user is on the same operating system as the server process on the same computer, the communication path between a user process and an ORACLE Server is established through Interprocess Communication (IPC) in the operating system.
• Client-server mode: communication between user processes and Oracle servers is achieved through network protocols (such as TCP/IP.
• Client-Application Server-server mode: the user's personal computer communicates with the application server or network server over the network, and the application server or network server is connected to the computer running the database through the network.

 

The connection described above is a one-to-one connection between the user process and the server process, and also becomes a dedicated server connection ).