VIP不在集群：CRS-2805: Unable to start 'ora.LISTENER.lsnr'

[TOC]

1.VIP没添加成功

1. vip没有被拉起，ping不成功
2. 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   
复制