如何在oracle集群中更换私有网络的网卡
您现在的位置：首页>教程>编程开发>Oracle教程 > 如何在oracle集群中更换私有网络的网卡 如何在oracle集群中更换私有网络的网卡 感谢 3lian8 的投递 时间：2014-03-18 来源：三联教程 如何在oracle 集群中更换私有网络的网卡。 今天是2014-03-17，目前学习进
您现在的位置：首页 > 教程 > 编程开发 > Oracle教程 > 如何在oracle集群中更换私有网络的网卡
如何在oracle集群中更换私有网络的网卡
感谢 3lian8 的投递 时间：2014-03-18 来源：三联教程
如何在oracle 集群中更换私有网络的网卡。
今天是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 /:cluster_interconnect
删除一个私网接口
$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 文件(每个节点都要备份)。
节点一：
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
[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]$
节点二：
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
[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]$
2、查看目前节点私网信息
节点二：
?
1
2
3
4
5
6
7
8
9
10
[grid@rac-two peer]$ oifcfg getif
eth0 192.168.4.0 global public
eth3 192.168.2.0 global cluster_interconnect
[grid@rac-two peer]$ oifcfg iflist -p -n
eth0 192.168.4.0 PRIVATE 255.255.255.0
eth3 192.168.2.0 PRIVATE 255.255.255.0
eth3 169.254.0.0 UNKNOWN 255.255.0.0
eth1 192.168.1.0 PRIVATE 255.255.255.0
eth2 192.168.1.0 PRIVATE 255.255.255.0
[grid@rac-two peer]$
节点一：
?
1
2
3
4
5
6
7
8
9
10
[grid@rac-one peer]$ oifcfg getif
eth0 192.168.4.0 global public
eth3 192.168.2.0 global cluster_interconnect
[grid@rac-one peer]$ oifcfg iflist -p -n
eth0 192.168.4.0 PRIVATE 255.255.255.0
eth1 192.168.1.0 PRIVATE 255.255.255.0
eth2 192.168.1.0 PRIVATE 255.255.255.0
eth3 192.168.2.0 PRIVATE 255.255.255.0
eth3 169.254.0.0 UNKNOWN 255.255.0.0
[grid@rac-one peer]$
目前可以知道集群内部连接私有网络设备名为eth3，所需要做的是将集群内部私有网络设备名由eth3改变为eth1和eth2.
3、增加新的集群内部连接
?
1
2
3
[grid@rac-one peer]$ oifcfg setif -global eth1/192.168.1.0:cluster_interconnect
[grid@rac-one peer]$ oifcfg setif -global eth2/192.168.1.0:cluster_interconnect
[grid@rac-one peer]$
4、验证
节点一：
?
1
2
3
4
5
6
[grid@rac-one peer]$ oifcfg getif
eth0 192.168.4.0 global public
eth3 192.168.2.0 global cluster_interconnect
eth1 192.168.1.0 global cluster_interconnect
eth2 192.168.1.0 global cluster_interconnect
[grid@rac-one peer]$
节点二：
?
1
2
3
4
5
6
[grid@rac-two peer]$ oifcfg getif
eth0 192.168.4.0 global public
eth3 192.168.2.0 global cluster_interconnect
eth1 192.168.1.0 global cluster_interconnect
eth2 192.168.1.0 global cluster_interconnect
[grid@rac-two peer]$
5、删除192.168.2.0这个集群内部连接：
[grid@rac-two peer]$ oifcfg delif -global eth3/192.168.2.0
[grid@rac-two peer]$
6、在所有节点关闭集群和禁用crs服务且重启
节点一：
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
root@rac-one cdgi]# ./crsctl stop crs
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac-one'
CRS-2673: Attempting to stop 'ora.crsd' on 'rac-one'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac-one'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac-one'
CRS-2673: Attempting to stop 'ora.GIDG.dg' on 'rac-one'
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'rac-one'
CRS-2673: Attempting to stop 'ora.DATADG.dg' on 'rac-one'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac-one'
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rac-one' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac-one'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac-one' succeeded
CRS-2673: Attempting to stop 'ora.rac-one.vip' on 'rac-one'
CRS-2677: Stop of 'ora.DATADG.dg' on 'rac-one' succeeded
CRS-2677: Stop of 'ora.scan1.vip' on 'rac-one' succeeded
CRS-2672: Attempting to start 'ora.scan1.vip' on 'rac-two'
CRS-2677: Stop of 'ora.registry.acfs' on 'rac-one' succeeded
CRS-2677: Stop of 'ora.rac-one.vip' on 'rac-one' succeeded
CRS-2672: Attempting to start 'ora.rac-one.vip' on 'rac-two'
CRS-2676: Start of 'ora.scan1.vip' on 'rac-two' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'rac-two'
CRS-2676: Start of 'ora.rac-one.vip' on 'rac-two' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'rac-two' succeeded
CRS-2677: Stop of 'ora.GIDG.dg' on 'rac-one' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac-one'
CRS-2677: Stop of 'ora.asm' on 'rac-one' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'rac-one'
CRS-2677: Stop of 'ora.ons' on 'rac-one' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'rac-one'
CRS-2677: Stop of 'ora.net1.network' on 'rac-one' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac-one' has completed
CRS-2677: Stop of 'ora.crsd' on 'rac-one' succeeded
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac-one'
CRS-2673: Attempting to stop 'ora.crf' on 'rac-one'
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac-one'
CRS-2673: Attempting to stop 'ora.evmd' on 'rac-one'
CRS-2673: Attempting to stop 'ora.asm' on 'rac-one'
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'rac-one'
CRS-2677: Stop of 'ora.mdnsd' on 'rac-one' succeeded
CRS-2677: Stop of 'ora.crf' on 'rac-one' succeeded
CRS-2677: Stop of 'ora.evmd' on 'rac-one' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac-one' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac-one'
CRS-2677: Stop of 'ora.ctssd' on 'rac-one' succeeded
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac-one' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac-one'
CRS-2677: Stop of 'ora.cssd' on 'rac-one' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac-one'
CRS-2677: Stop of 'ora.drivers.acfs' on 'rac-one' succeeded
CRS-2677: Stop of 'ora.gipcd' on 'rac-one' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac-one'
CRS-2677: Stop of 'ora.gpnpd' on 'rac-one' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac-one' has completed
CRS-4133: Oracle High Availability Services has been stopped.
[root@rac-one cdgi]# crsctl disable crs
-bash: crsctl: command not found
[root@rac-one cdgi]# ./crsctl disable crs
CRS-4621: Oracle High Availability Services autostart is disabled.
[root@rac-one cdgi]# ./crsctl enable crs
CRS-4622: Oracle High Availability Services autostart is enabled.
[root@rac-one cdgi]# ./crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
节点二：
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
[root@rac-two ~]# cd /u01/app/11.2.0/grid/bin/
[root@rac-two bin]# ./crsctl stop crs
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac-two'
CRS-2673: Attempting to stop 'ora.crsd' on 'rac-two'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac-two'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac-two'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN3.lsnr' on 'rac-two'
CRS-2673: Attempting to stop 'ora.GIDG.dg' on 'rac-two'
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'rac-two'
CRS-2673: Attempting to stop 'ora.DATADG.dg' on 'rac-two'
CRS-2673: Attempting to stop 'ora.cvu' on 'rac-two'
CRS-2673: Attempting to stop 'ora.oc4j' on 'rac-two'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac-two'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'rac-two'
CRS-2673: Attempting to stop 'ora.rac-two.vip' on 'rac-two'
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rac-two' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac-two'
CRS-2677: Stop of 'ora.cvu' on 'rac-two' succeeded
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac-two' succeeded
CRS-2677: Stop of 'ora.LISTENER_SCAN3.lsnr' on 'rac-two' succeeded
CRS-2673: Attempting to stop 'ora.scan3.vip' on 'rac-two'
CRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'rac-two' succeeded
CRS-2673: Attempting to stop 'ora.scan2.vip' on 'rac-two'
CRS-2677: Stop of 'ora.DATADG.dg' on 'rac-two' succeeded
CRS-2677: Stop of 'ora.rac-two.vip' on 'rac-two' succeeded
CRS-2673: Attempting to stop 'ora.rac-one.vip' on 'rac-two'
CRS-2677: Stop of 'ora.registry.acfs' on 'rac-two' succeeded
CRS-2677: Stop of 'ora.scan1.vip' on 'rac-two' succeeded
CRS-2677: Stop of 'ora.scan3.vip' on 'rac-two' succeeded
CRS-2677: Stop of 'ora.scan2.vip' on 'rac-two' succeeded
CRS-2677: Stop of 'ora.rac-one.vip' on 'rac-two' succeeded
CRS-2677: Stop of 'ora.GIDG.dg' on 'rac-two' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac-two'
CRS-2677: Stop of 'ora.oc4j' on 'rac-two' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac-two' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'rac-two'
CRS-2677: Stop of 'ora.ons' on 'rac-two' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'rac-two'
CRS-2677: Stop of 'ora.net1.network' on 'rac-two' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac-two' has completed
CRS-2677: Stop of 'ora.crsd' on 'rac-two' succeeded
CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'rac-two'
CRS-2673: Attempting to stop 'ora.crf' on 'rac-two'
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac-two'
CRS-2673: Attempting to stop 'ora.evmd' on 'rac-two'
CRS-2673: Attempting to stop 'ora.asm' on 'rac-two'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac-two'
CRS-2677: Stop of 'ora.crf' on 'rac-two' succeeded
CRS-2677: Stop of 'ora.evmd' on 'rac-two' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'rac-two' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac-two' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac-two'
CRS-2677: Stop of 'ora.ctssd' on 'rac-two' succeeded
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac-two' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac-two'
CRS-2677: Stop of 'ora.drivers.acfs' on 'rac-two' succeeded
CRS-2677: Stop of 'ora.cssd' on 'rac-two' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'rac-two'
CRS-2677: Stop of 'ora.gipcd' on 'rac-two' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac-two'
CRS-2677: Stop of 'ora.gpnpd' on 'rac-two' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac-two' has completed
CRS-4133: Oracle High Availability Services has been stopped.
[root@rac-two bin]# ./crsctl enable crs
CRS-4622: Oracle High Availability Services autostart is enabled.
[root@rac-two bin]# ./crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
[root@rac-two bin]#
7、验证
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
[grid@rac-two ~]$ crsctl status resource -t
--------------------------------------------------------------------------------
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
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
How long will Oracle database logs be kept?
May 10, 2024 am 03:27 AM
The retention period of Oracle database logs depends on the log type and configuration, including: Redo logs: determined by the maximum size configured with the "LOG_ARCHIVE_DEST" parameter. Archived redo logs: Determined by the maximum size configured by the "DB_RECOVERY_FILE_DEST_SIZE" parameter. Online redo logs: not archived, lost when the database is restarted, and the retention period is consistent with the instance running time. Audit log: Configured by the "AUDIT_TRAIL" parameter, retained for 30 days by default.
Function to calculate the number of days between two dates in oracle
May 08, 2024 pm 07:45 PM
The function in Oracle to calculate the number of days between two dates is DATEDIFF(). The specific usage is as follows: Specify the time interval unit: interval (such as day, month, year) Specify two date values: date1 and date2DATEDIFF(interval, date1, date2) Return the difference in days
The order of the oracle database startup steps is
May 10, 2024 am 01:48 AM
The Oracle database startup sequence is: 1. Check the preconditions; 2. Start the listener; 3. Start the database instance; 4. Wait for the database to open; 5. Connect to the database; 6. Verify the database status; 7. Enable the service (if necessary ); 8. Test the connection.
How much memory does oracle require?
May 10, 2024 am 04:12 AM
The amount of memory required by Oracle depends on database size, activity level, and required performance level: for storing data buffers, index buffers, executing SQL statements, and managing the data dictionary cache. The exact amount is affected by database size, activity level, and required performance level. Best practices include setting the appropriate SGA size, sizing SGA components, using AMM, and monitoring memory usage.
How to use interval in oracle
May 08, 2024 pm 07:54 PM
The INTERVAL data type in Oracle is used to represent time intervals. The syntax is INTERVAL <precision> <unit>. You can use addition, subtraction, multiplication and division operations to operate INTERVAL, which is suitable for scenarios such as storing time data and calculating date differences.
How to see the number of occurrences of a certain character in Oracle
May 09, 2024 pm 09:33 PM
To find the number of occurrences of a character in Oracle, perform the following steps: Get the total length of a string; Get the length of the substring in which a character occurs; Count the number of occurrences of a character by subtracting the substring length from the total length.
How to replace string in oracle
May 08, 2024 pm 07:24 PM
The method of replacing strings in Oracle is to use the REPLACE function. The syntax of this function is: REPLACE(string, search_string, replace_string). Usage steps: 1. Identify the substring to be replaced; 2. Determine the new string to replace the substring; 3. Use the REPLACE function to replace. Advanced usage includes: multiple replacements, case sensitivity, special character replacement, etc.
Oracle database server hardware configuration requirements
May 10, 2024 am 04:00 AM
Oracle database server hardware configuration requirements: Processor: multi-core, with a main frequency of at least 2.5 GHz. For large databases, 32 cores or more are recommended. Memory: At least 8GB for small databases, 16-64GB for medium sizes, up to 512GB or more for large databases or heavy workloads. Storage: SSD or NVMe disks, RAID arrays for redundancy and performance. Network: High-speed network (10GbE or higher), dedicated network card, low-latency network. Others: Stable power supply, redundant components, compatible operating system and software, heat dissipation and cooling system.
