Public Network: provides external services for connecting clients, application systems, and databases. In addition to database maintenance, users seldom directly connect to the database,
A common practice is to connect a user to a database through the middleware (Application Server ).
Advantage: database connections can be cached and reused. Middleware can establish multiple database connections at a time at startup and then maintain them within one lifecycle. Multiple users can
Reuse the same database connection to avoid frequent establishment and release of database connections and reduce system resource consumption.
Private Network: Oracle clusterware and instance use this network for communication.
We recommend that you use redundancy to configure the network. You can bind two physical NICs. Even if one Nic is broken, the other Nic can still provide services, effectively avoiding network card damage.
Single point of failure.
Data transmitted on the private network includes:
Cache fusion data, that is, data blocks
Locks resource lock request information
Heartbeat data
SCN Information
Private networks can only be used for the preceding purposes and cannot be used for other purposes.
Network Protocol:
Clusterware: TCP/IP
RAC: UDP
Multi-nic binding: Linux (bonding), Solaris (link aggregation), and Aix (etherchannel)
Oracle recommends that the private network be configured with at least 1 GB of Network
1. GB-level Ethernet Card
2. InfiniBand (Oracle exadata solution), the Protocol Stack is less than TCP/IP, consumes less CPU resources, and is expensive.
OS system parameter adjustment for private networks:
Because the cluster uses the UDP protocol for communication, you need to adjust relevant parameters on the operating system to improve UDP transmission efficiency and avoid OS idle errors when large data volumes occur.
Linux parameters are as follows:
Sysctl-P
Net. Core. rmem_default = 262144
Net. Core. wmem_default = 262144
Net. Core. rmem_max = 262144
Net. Core. wmem_max = 262144
Personal Original, reprinted please indicate the source
Http://blog.csdn.net/xiangsir/article/details/8576754