Shulou(Shulou.com)06/01 Report--

Oracle RAC error-- A case of oifcfg error

System environment:

Operating system: RedHat EL5

Cluster: Oracle GI (Grid Infrastructure)

Oracle: Oracle 11.2.0.1.0

As shown in the figure: RAC system architecture

Error phenomenon:

[root@zhangqn1 ~] # oifcfg delif-global eth0/192.168.6.0:public

PRIF-26: Error in update the profiles in the cluster

RAC error modifying ip information!

Solution:

1. Check the network configuration

[root@zhangqn1 ~] # ifconfig eth0eth0 Link encap:Ethernet HWaddr 08:00:27:F4:11:8F inet addr:192.168.8.231 Bcast:192.168.8.255 Mask:255.255.255.0 inet6 addr: fe80::a00:27ff:fef4:118f/64 Scope:Link UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:18175 errors:0 dropped:0 overruns:0 frame:0 TX packets:2965 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:1653589 (1.5 MiB) TX bytes:460593 (449.7 KiB)

[root@zhangqn1 ~] # cat / etc/hosts

# Do not remove the following line Or various programs# that require network functionality will fail.127.0.0.1 localhost.localdomain localhost192.168.8.231 zhangqn1192.168.8.232 zhangqn210.10.10.101 zhangqn1-priv10.10.10.102 zhangqn2-priv192.168.8.235 zhangqn1-vip192.168.8.236 zhangqn2-vip192.168.8.230 zhangqn-scan

2. Check the RAC configuration

[root@zhangqn1 ~] # ocrcheck

Status of Oracle Cluster Registry is as follows: Version: 3 Total space (kbytes): 262120 Used space (kbytes): 2936 Available space (kbytes): 259184 ID: 1655283749 Device/File Name: + OCR_VOTE Device/File integrity check succeeded Device/File not configured Cluster registry integrity check succeeded Logical corruption check succeeded

[root@zhangqn1 ~] # crsctl query css votedisk

# # STATE File Universal Id File Name Disk group-- 1. ONLINE 6ba76ea8b6c04f9cbfeeaa13e9d6fab0 (ORCL:OCR_VOTE1) [OCR_VOTE] 2. ONLINE 7b8307d585724fd8bfe3d1b415c2c0aa (ORCL:OCR_VOTE2) [OCR_VOTE] 3. ONLINE 619d624c79d34fbdbfe2bb4d0cf488c2 (ORCL:OCR_VOTE3 ) [OCR_VOTE] Located 3 voting disk (s)

[root@zhangqn1 ~] # crs_stat-t

Name Type Target State Host-ora.DATA.dg ora....up.type OFFLINE OFFLINE ora.DG1.dg ora....up. Type OFFLINE OFFLINE ora.DG2.dg ora....up.type OFFLINE OFFLINE ora.DG3.dg ora....up.type OFFLINE OFFLINE ora.DG4.dg ora....up.type OFFLINE OFFLINE ora....ER.lsnr ora....er.type OFFLINE OFFLINE ora....N1.lsnr Ora....er.type OFFLINE OFFLINE ora....VOTE.dg ora....up.type ONLINE ONLINE zhangqn1 ora.RCY.dg ora....up.type OFFLINE OFFLINE ora.asm ora.asm.type ONLINE ONLINE zhangqn1 ora.eons ora.eons.type ONLINE ONLINE zhangqn1 ora.gsd ora.gsd.type OFFLINE OFFLINE Ora....network ora....rk.type ONLINE OFFLINE ora.oc4j ora.oc4j.type OFFLINE OFFLINE ora.ons ora.ons.type ONLINE ONLINE zhangqn1 ora.proddb.db ora....se.type OFFLINE OFFLINE ora....ry.acfs ora....fs.type ONLINE ONLINE zhangqn1 ora.scan1.vip ora.... Ip.type OFFLINE OFFLINE ora....SM1.asm application ONLINE ONLINE zhangqn1 ora....N1.lsnr application OFFLINE OFFLINE ora....qn1.gsd application OFFLINE OFFLINE ora....qn1.ons application ONLINE ONLINE zhangqn1 ora....qn1.vip ora....t1.type OFFLINE OFFLINE ora....SM2.asm application ONLINE ONLINE zhangqn2 ora....N2.lsnr application OFFLINE OFFLINE ora....qn2.gsd application OFFLINE OFFLINE ora....qn2.ons application ONLINE ONLINE zhangqn2 ora....qn2.vip ora....t1.type OFFLINE OFFLINE

It is found that the ons service is still in the online state, and ons is related to the RAC network configuration service.

Note:

Oracle Notification Service, divided into master node ONS and child node ONS, is the process of publishing and reporting "UP,DOWN,Not_restart,Restart_failed,Node_Down,preConn_Up,preConn_Down" events caused by manual initialization, dependent service failure, operation failure, automatic restart and other reasons in the Oracle distributed cluster system. It is a high availability heartbeat service. Ps-ef | grep ons can only see whether the ONS service is running before onsctl ping can confirm whether the ORC service is running properly.

4. Stop the ons service

[root@zhangqn1 ~] # crs_stat | grep ons

NAME=ora.eonsTYPE=ora.eons.typeNAME=ora.onsTYPE=ora.ons.typeNAME=ora.zhangqn1.onsNAME=ora.zhangqn2.ons [root@zhangqn1 ~] # crs_stop-f ora.zhangqn1.onsAttempting to stop `ora.ons` on member `zhangqn1`St op of `ora.ons` on member `zhangqn1` succeeded. [root@zhangqn1 ~] # crs_stop-f ora.zhangqn2.onsAttempting to stop `ora.ons`on member `zhangqn2`Stop of `ora.ons` on member `zhangqn2` succeeded.

[root@zhangqn1 ~] # crs_stat-t

Name Type Target State Host-ora.DATA.dg ora....up.type OFFLINE OFFLINE ora.DG1.dg ora....up. Type OFFLINE OFFLINE ora.DG2.dg ora....up.type OFFLINE OFFLINE ora.DG3.dg ora....up.type OFFLINE OFFLINE ora.DG4.dg ora....up.type OFFLINE OFFLINE ora....ER.lsnr ora....er.type OFFLINE OFFLINE ora....N1.lsnr Ora....er.type OFFLINE OFFLINE ora....VOTE.dg ora....up.type ONLINE ONLINE zhangqn1 ora.RCY.dg ora....up.type OFFLINE OFFLINE ora.asm ora.asm.type ONLINE ONLINE zhangqn1 ora.eons ora.eons.type ONLINE ONLINE zhangqn1 ora.gsd ora.gsd.type OFFLINE OFFLINE Ora....network ora....rk.type ONLINE OFFLINE ora.oc4j ora.oc4j.type OFFLINE OFFLINE ora.ons ora.ons.type OFFLINE OFFLINE ora.proddb.db ora....se.type OFFLINE OFFLINE ora....ry.acfs ora....fs.type ONLINE ONLINE zhangqn1 ora.scan1.vip ora .... ip.type OFFLINE OFFLINE ora....SM1.asm application ONLINE ONLINE zhangqn1 ora....N1.lsnr application OFFLINE OFFLINE ora....qn1.gsd application OFFLINE OFFLINE ora....qn1.ons application OFFLINE OFFLINE ora....qn1.vip ora....t1.type OFFLINE OFFLINE ora .... SM2.asm application ONLINE ONLINE zhangqn2 ora....N2.lsnr application OFFLINE OFFLINE ora....qn2.gsd application OFFLINE OFFLINE ora....qn2.ons application OFFLINE OFFLINE ora....qn2.vip ora....t1.type OFFLINE OFFLINE

5. Modify the network configuration again through oifcfg

[root@zhangqn1 ~] # oifcfg setif-global eth0/192.168.8.0:public [root@zhangqn1 ~] # ifcfg getifMissing IP address argument. [root@zhangqn1 ~] # oifcfg getifeth0 192.168.6.0 global publiceth2 10.10.10.0 global cluster_interconnecteth0 192.168.8.0 global public [root@zhangqn1] # oifcfg delif-global eth0/192.168.6.0 [root@zhangqn1 ~] # oifcfg getifeth2 10.10.10.0 global cluster_interconnecteth0 192.168.0 global public

@ configuration successful!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.