Oracle 10g RAC public IP and private IP

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.