[TOC]
1.VIP没添加成功
- vip没有被拉起，ping不成功
- listener 没有拉起。
[root@emdb1:~]# srvctl start listener
PRCR-1079 : Failed to start resource ora.LISTENER.lsnr
CRS-2805: Unable to start 'ora.LISTENER.lsnr' because it has a 'hard' dependency on resource type 'ora.cluster_vip_net1.type' and no resource of that type can satisfy the dependency
###
CRS-2525: All instances of the resource 'ora.emdb2.vip' are already running; relocate is not allowed because the force option was not specified
CRS-2525: All instances of the resource 'ora.emdb3.vip' are already running; relocate is not allowed because the force option was not specified
CRS-2525: All instances of the resource 'ora.emdb4.vip' are already running; relocate is not allowed because the force option was not specified
解决方法
检查环境
1. 检查集群情况
[root@emdb1:~]# ip a |grep 192
inet 192.168.6.11/24 brd 192.168.6.255 scope global enp0s3
inet 192.168.11.2/24 brd 192.168.11.255 scope global enp0s9
inet 192.168.12.2/24 brd 192.168.12.255 scope global enp0s9:1
inet 192.168.160.193/24 brd 192.168.160.255 scope global dynamic enp0s10
[root@emdb1:~]# grep vip /etc/hosts
192.168.6.21 emdb1-vip
192.168.6.22 emdb2-vip
192.168.6.23 emdb3-vip
192.168.6.24 emdb4-vip
[root@emdb1:~]# ping 192.168.6.21
PING 192.168.6.21 (192.168.6.21) 56(84) bytes of data.
^C
--- 192.168.6.21 ping statistics ---
3 packets transmitted, 0 received, 100% packet loss, time 1999ms
1.1 检查各节点的状态.
#root
crsctl stat res -t
- 下面的18行
ora.LISTENER.lsnr提示STATE:OFFLINE - 下面的54行
ora.emdb2.vip没有ora.emdb1.vip数据 ora.emdb.db显示数据库是OFFLINE
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.BAK.dg
ONLINE ONLINE emdb1
ONLINE ONLINE emdb3
ONLINE ONLINE emdb4
ora.DATA.dg
ONLINE ONLINE emdb1
ONLINE ONLINE emdb3
ONLINE ONLINE emdb4
ora.FRA.dg
ONLINE ONLINE emdb1
ONLINE ONLINE emdb3
ONLINE ONLINE emdb4
ora.LISTENER.lsnr
ONLINE OFFLINE emdb1
ONLINE ONLINE emdb3
ONLINE ONLINE emdb4
ora.OCR.dg
ONLINE ONLINE emdb1
ONLINE ONLINE emdb3
ONLINE ONLINE emdb4
ora.asm
ONLINE ONLINE emdb1 Started
ONLINE ONLINE emdb3 Started
ONLINE ONLINE emdb4 Started
ora.gsd
OFFLINE OFFLINE emdb1
OFFLINE OFFLINE emdb3
OFFLINE OFFLINE emdb4
ora.net1.network
ONLINE ONLINE emdb1
ONLINE ONLINE emdb3
ONLINE ONLINE emdb4
ora.ons
ONLINE ONLINE emdb1
ONLINE ONLINE emdb3
ONLINE ONLINE emdb4
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE emdb4
ora.cvu
1 ONLINE ONLINE emdb3
ora.emdb.db
1 OFFLINE OFFLINE
2 OFFLINE OFFLINE
3 ONLINE ONLINE emdb4 Open
4 ONLINE ONLINE emdb3 Open
ora.emdb2.vip
1 ONLINE INTERMEDIATE emdb4 FAILED OVER
ora.emdb3.vip
1 ONLINE ONLINE emdb3
ora.emdb4.vip
1 ONLINE ONLINE emdb4
ora.oc4j
1 ONLINE ONLINE emdb3
ora.scan1.vip
1 ONLINE ONLINE emdb4
1.2. 检查集群组件状态
- 可见组件是正常的。
#root
cd `su - grid -c 'echo ${ORACLE_HOME}/bin'`
crsctl check cluster -all
crsctl check cluster -all
**************************************************************
emdb1:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
emdb3:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
emdb4:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
1.3 检查现有的VIP情况
- 可见没有emdb1的VIP
srvctl config nodeapps -a
Network exists: 1/192.168.6.0/255.255.255.0/enp0s3, type static
VIP exists: /emdb2-vip/192.168.6.22/192.168.6.0/255.255.255.0/enp0s3, hosting node emdb2
VIP exists: /emdb3-vip/192.168.6.23/192.168.6.0/255.255.255.0/enp0s3, hosting node emdb3
VIP exists: /emdb4-vip/192.168.6.24/192.168.6.0/255.255.255.0/enp0s3, hosting node emdb4
1.4 检查网络现有节点情况
- GSD是Oracle的DNS
[root@emdb1:~]# srvctl status nodeapps
VIP emdb2-vip is enabled
VIP emdb2-vip is running on node: emdb4
VIP emdb3-vip is enabled
VIP emdb3-vip is running on node: emdb3
VIP emdb4-vip is enabled
VIP emdb4-vip is running on node: emdb4
Network is enabled
Network is running on node: emdb1
Network is running on node: emdb3
Network is running on node: emdb4
GSD is disabled
GSD is not running on node: emdb1
GSD is not running on node: emdb3
GSD is not running on node: emdb4
ONS is enabled
ONS daemon is running on node: emdb1
ONS daemon is running on node: emdb3
ONS daemon is running on node: emdb4
2. 解决方法:添加VIP,拉起监听
2.1 添加VIP
- -n 主机名， -A VIP在host的域名/子网掩码/绑定的网卡（与哪张网卡同域） -k 默认为1 （必要参数）
#root
cd `su - grid -c 'echo ${ORACLE_HOME}/bin'`
./srvctl add vip -n emdb1 -A emdb1-vip/255.255.255.0/enp0s3 -k 1
2.2 检查VIP是否注册成功
- 看到emdb1的VIP已经注册了。这一步就成功了。
#root
cd `su - grid -c 'echo ${ORACLE_HOME}/bin'`
srvctl config nodeapps -a
./srvctl config nodeapps -a
Network exists: 1/192.168.6.0/255.255.255.0/enp0s3, type static
VIP exists: /emdb1-vip/192.168.6.21/192.168.6.0/255.255.255.0/enp0s3, hosting node emdb1
VIP exists: /emdb2-vip/192.168.6.22/192.168.6.0/255.255.255.0/enp0s3, hosting node emdb2
VIP exists: /emdb3-vip/192.168.6.23/192.168.6.0/255.255.255.0/enp0s3, hosting node emdb3
VIP exists: /emdb4-vip/192.168.6.24/192.168.6.0/255.255.255.0/enp0s3, hosting node emdb4
2.3 拉起监听
#root
cd `su - grid -c 'echo ${ORACLE_HOME}/bin'`
./srvctl start listener
2.4 检查监听
- 拉起后，监听正常了。
#root
cd `su - grid -c 'echo ${ORACLE_HOME}/bin'`
./crs_stat -t -v
crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora.BAK.dg ora....up.type 0/5 0/ ONLINE ONLINE emdb1
ora.DATA.dg ora....up.type 0/5 0/ ONLINE ONLINE emdb1
ora.FRA.dg ora....up.type 0/5 0/ ONLINE ONLINE emdb1
ora....ER.lsnr ora....er.type 0/5 0/ ONLINE ONLINE emdb1
ora....N1.lsnr ora....er.type 0/5 0/0 ONLINE ONLINE emdb4
ora.OCR.dg ora....up.type 0/5 0/ ONLINE ONLINE emdb1
ora.asm ora.asm.type 0/5 0/ ONLINE ONLINE emdb1
ora.cvu ora.cvu.type 0/5 0/0 ONLINE ONLINE emdb3
ora.emdb.db ora....se.type 0/2 0/1 ONLINE ONLINE emdb1
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE emdb1
ora....B1.lsnr application 0/5 0/0 ONLINE ONLINE emdb1
ora.emdb1.gsd application 0/5 0/0 OFFLINE OFFLINE
ora.emdb1.ons application 0/3 0/0 ONLINE ONLINE emdb1
ora.emdb1.vip ora....t1.type 0/0 0/0 ONLINE ONLINE emdb1
ora.emdb2.vip ora....t1.type 0/0 1/0 ONLINE ONLINE emdb4
ora....SM3.asm application 0/5 0/0 ONLINE ONLINE emdb3
ora....B3.lsnr application 0/5 0/0 ONLINE ONLINE emdb3
ora.emdb3.gsd application 0/5 0/0 OFFLINE OFFLINE
ora.emdb3.ons application 0/3 0/0 ONLINE ONLINE emdb3
ora.emdb3.vip ora....t1.type 0/0 1/0 ONLINE ONLINE emdb3
ora....SM4.asm application 0/5 0/0 ONLINE ONLINE emdb4
ora....B4.lsnr application 0/5 0/0 ONLINE ONLINE emdb4
ora.emdb4.gsd application 0/5 0/0 OFFLINE OFFLINE
ora.emdb4.ons application 0/3 0/0 ONLINE ONLINE emdb4
ora.emdb4.vip ora....t1.type 0/0 1/0 ONLINE ONLINE emdb4
ora.gsd ora.gsd.type 0/5 0/ OFFLINE OFFLINE
ora....network ora....rk.type 1/5 0/ ONLINE ONLINE emdb1
ora.oc4j ora.oc4j.type 0/1 0/2 ONLINE ONLINE emdb3
ora.ons ora.ons.type 0/3 0/ ONLINE ONLINE emdb1
ora.scan1.vip ora....ip.type 0/0 1/0 ONLINE ONLINE emdb4
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
