我们知道RAC网络有私有网络和公用网络，公用网络提供客户访问请求，私用网络提供oracle 的cache fusion和节点心跳等作用，因为在
今天是2014-03-17，目前学习进度也正在紧锣密鼓的进行着，今天把一小部分实验在做一下记录一下笔记。
我们知道RAC网络有私有网络和公用网络，，公用网络提供客户访问请求，私用网络提供Oracle 的cache fusion和节点心跳等作用，因为在11G R2可以执行4个private network 进行cache fusion。
但在刚刚开始安装的时候进行了忽略，那么安装之后如何修改呢？且该环节可以模拟oracle RAC怎么添加私用网卡，如果替换损坏网卡等真实环节。
另外对于网络调整无非有、更改私用主机名啊、不改变网段和掩码改变私用地址啊、改变私有网络的mtu啊、改变私有网卡子网或是掩码，这么几种情况。
今天就谈如何改变私网网卡。那么这时候需要使用一个工具叫oracle interface configuration assistant(oifcfg).
在11G r2之前，oracle在ocr中存储网络接口名称和子网信息，那么使用oifcfg即可完成修改：
1、增加和删除私网接口
增加一个私网接口
$ORA_CRS_HOME/bin/oifcfg setif -global
删除一个私网接口
$ORA_CRS_HOME/bin/oifcfg delif -global
2、查看网卡改变情况
$ORA_CRS_HOME/bin/oifcfg getif
3、重启集群
crsctl stop crs
crsctl start crs
那么对于oracle 11G R2或是更高版本，如何修改私网呢？
在11.2gi中，私有网络配置不在保存在ocr中，而是保存在gpnp profile文件中，该文件是一个xml文件，不推荐使用手动编辑，在进行配置私网之前
首先需要备份该文件，进而进行后续操作。由于我的实验环境正好是11.2.0.4，因此随即记录真实修改过程。
1、备份gpnp profile 文件（每个节点都要备份）。
节点一：
[root@rac-one cdgi]# su - grid
[grid@rac-one ~]$ cd /u01/app/11.2.0/grid/gpnp/rac-one/profiles/peer/
[grid@rac-one peer]$ ls -l
total 12
-rw-r--r-- 1 grid oinstall 1857 Feb 25 21:54 profile.old
-rw-r--r-- 1 grid oinstall 1830 Feb 13 02:51 profile_orig.xml
-rw-r--r-- 1 grid oinstall 1896 Feb 25 21:58 profile.xml
[grid@rac-one peer]$ cp profile.xml profile.xml_bak
[grid@rac-one peer]$ ls -ltr
total 16
-rw-r--r-- 1 grid oinstall 1830 Feb 13 02:51 profile_orig.xml
-rw-r--r-- 1 grid oinstall 1857 Feb 25 21:54 profile.old
-rw-r--r-- 1 grid oinstall 1896 Feb 25 21:58 profile.xml
-rw-r--r-- 1 grid oinstall 1896 Mar 17 17:47 profile.xml_bak
[grid@rac-one peer]$
节点二：
[root@rac-two ~]# su - grid
[grid@rac-two ~]$ cd /u01/app/11.2.0/grid/gpnp/rac-two/profiles/peer/
[grid@rac-two peer]$ ls -l
total 12
-rw-r--r-- 1 grid oinstall 1857 Feb 25 21:54 profile.old
-rw-r--r-- 1 grid oinstall 1830 Feb 13 02:27 profile_orig.xml
-rw-r--r-- 1 grid oinstall 1896 Feb 25 21:58 profile.xml
[grid@rac-two peer]$ cp profile.xml profile.xml_bak
[grid@rac-two peer]$ ls -ltr
total 16
-rw-r--r-- 1 grid oinstall 1830 Feb 13 02:27 profile_orig.xml
-rw-r--r-- 1 grid oinstall 1857 Feb 25 21:54 profile.old
-rw-r--r-- 1 grid oinstall 1896 Feb 25 21:58 profile.xml
-rw-r--r-- 1 grid oinstall 1896 Mar 17 17:48 profile.xml_bak
[grid@rac-two peer]$
Reduce the use of MySQL memory in DockerMar 04, 2025 pm 03:52 PMThis article explores optimizing MySQL memory usage in Docker. It discusses monitoring techniques (Docker stats, Performance Schema, external tools) and configuration strategies. These include Docker memory limits, swapping, and cgroups, alongside
How to solve the problem of mysql cannot open shared libraryMar 04, 2025 pm 04:01 PMThis article addresses MySQL's "unable to open shared library" error. The issue stems from MySQL's inability to locate necessary shared libraries (.so/.dll files). Solutions involve verifying library installation via the system's package m
How do you alter a table in MySQL using the ALTER TABLE statement?Mar 19, 2025 pm 03:51 PMThe article discusses using MySQL's ALTER TABLE statement to modify tables, including adding/dropping columns, renaming tables/columns, and changing column data types.
Run MySQl in Linux (with/without podman container with phpmyadmin)Mar 04, 2025 pm 03:54 PMThis article compares installing MySQL on Linux directly versus using Podman containers, with/without phpMyAdmin. It details installation steps for each method, emphasizing Podman's advantages in isolation, portability, and reproducibility, but also
What is SQLite? Comprehensive overviewMar 04, 2025 pm 03:55 PMThis article provides a comprehensive overview of SQLite, a self-contained, serverless relational database. It details SQLite's advantages (simplicity, portability, ease of use) and disadvantages (concurrency limitations, scalability challenges). C
Running multiple MySQL versions on MacOS: A step-by-step guideMar 04, 2025 pm 03:49 PMThis guide demonstrates installing and managing multiple MySQL versions on macOS using Homebrew. It emphasizes using Homebrew to isolate installations, preventing conflicts. The article details installation, starting/stopping services, and best pra
How do I configure SSL/TLS encryption for MySQL connections?Mar 18, 2025 pm 12:01 PMArticle discusses configuring SSL/TLS encryption for MySQL, including certificate generation and verification. Main issue is using self-signed certificates' security implications.[Character count: 159]
What are some popular MySQL GUI tools (e.g., MySQL Workbench, phpMyAdmin)?Mar 21, 2025 pm 06:28 PMArticle discusses popular MySQL GUI tools like MySQL Workbench and phpMyAdmin, comparing their features and suitability for beginners and advanced users.[159 characters]
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
EditPlus Chinese cracked version
Small size, syntax highlighting, does not support code prompt function
Dreamweaver Mac version
Visual web development tools
ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment
SublimeText3 Mac version
God-level code editing software (SublimeText3)
mPDF
mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),
