Oracle RAC错误之--oifcfg错误案例
来源:互联网 发布:淘宝网店策划书怎么写 编辑:程序博客网 时间:2024/05/22 06:26
Oracle RAC错误之--oifcfg错误案例
系统环境:
操作系统:RedHat EL5
Cluster: Oracle GI(Grid Infrastructure)
Oracle: Oracle 11.2.0.1.0
如图所示:RAC 系统架构
错误现象:
[root@zhangqn1 ~]# oifcfg delif -global eth0/192.168.6.0:public
PRIF-26: Error in update the profiles in the cluster
RAC修改ip信息出错!
解决方法:
1、检查网络配置
[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、检查RAC配置
[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 Device/File not configured Device/File not configured 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
发现ons服务仍处于online状态,ons和RAC网络配置服务有关。
附注:
Oracle Notification Service,分主节点ONS和子节点ONS,就是Oracle分布式集群系统中各服务器上发布和上报因为用户手工初始化、依赖服务失败、运行失败,自动重启等原因产生的"UP,DOWN,Not_restart,Restart_failed,Node_Down,preConn_Up,preConn_Down"事件的进程,是构成高可用性的心跳服务。ps -ef |grep ons只能看到ONS服务是否在运行中,onsctl ping才能确认ORC服务运行是否正常。
4、停止ons服务
[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`Stop 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、重新通过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 publiceth1 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 getifeth1 10.10.10.0 global cluster_interconnecteth0 192.168.8.0 global public
@配置成功!
本文出自 “天涯客的blog” 博客,请务必保留此出处http://tiany.blog.51cto.com/513694/1544851
0 0
- Oracle RAC错误之--oifcfg错误案例
- Oracle Study之--Oracle 11g RAC设置归档路径错误案例
- Oracle Study之案例--AIX安装RAC错误之(rootpre)
- Oracle 11g RAC Installer 错误案例之--grid 安装失败
- Oracle 11gR2 安装RAC错误之--HOSTS文件错误
- Oracle Study之案例--Oracle Sqlplus错误
- Oracle Study之--Oracle 11g RAC添加节点错误
- Oracle 归档错误案例
- oracle rac 安装错误整理。
- oracle-rac 遇到的错误
- Oracle 11g RAC 错误集锦之---VIP 故障
- Oracle 11g RAC ASM 错误之(1)
- Oracle 11gR2 安装RAC错误之--时钟不同步
- Oracle错误案例:TNS-00510
- Oracle错误案例:ORA-00922
- Oracle错误案例:ORA-00235
- Oracle Study之案例--RMAN ORA-19921错误
- Oracle Study之--Logical Standby日志应用错误案例
- 通过案例学习调优之--Oracle ASH
- Android调用系统相册和系统相机拍照
- 通过案例学调优之--动态视图(v$bh和x$bh)
- 通过案例学调优之--Oracle参数(db_file_multiblock_read_count)
- 通过案例学调优之--跨库建立物化视图(Materialized View)
- Oracle RAC错误之--oifcfg错误案例
- 通过案例学调优之--JOB管理
- 通过案例学调优之--10046事件
- 通过案例学调优之--Oracle数据块(block)
- 通过案例学调优之--模拟buffer busy waits事件
- 语音识别之找出字符串的最短距离
- Oracle参数open_cursors和session_cached_cursor详解
- 通过案例学调优之--IOSTAT(查看磁盘I/O)
- 通过案例学调优之--分区表基本概念