The Oracle 11G database must be installed and deployed based on the hardware platform and operating system.
1. Independent host structure of multiple databases
This application architecture is physically a single server with one or more hard disks on the server. But it is functionally multiple logical database servers, multiple databases. As shown in the figure:
This application architecture consists of multiple database servers, multiple database files, that is, two or more versions of databases (such as Oracle 10G and Oracle 11g) installed on a single computer. Although they are on the same computer, neither memory structures, server processes, nor database files are shared. In this case, the database files should be stored in different paths on different disks as much as possible. Since each logical server requires allocating global system area memory and server background processes, the hardware requirements are high.
2. Client/server structure In the client/server structure, the management and application of database server are distributed on two computers. Application programs and connection tools are installed on the client. The server runs the database, receives the connection request through the network protocol, and sends the execution result back to the client.
You can have multiple physical database servers and multiple physical clients on the same network. Multiple database servers, or multiple database routines of a single database server, can be installed on a single physical database server. Oracle supports multiple home directories, allowing Oracle 10G and Oracle 11g to be installed on one physical database server at the same time, which can exist independently in two different home directories.
Distributed architecture Distributed architecture is a special type of client/server architecture. In this structure, distributed database systems are logically integrated, but physically distributed across different computer networks, connected together by networks. Each node in the network can independently process the data in the local database server and perform local applications. It can also access and process data in multiple remote database servers and perform global applications.
