探子 2025-05-22 20:14 采纳率: 0%
浏览 5

Oracle RAC vip重复注册

vmware安装centos7环境部署Oracle RAC (11.2.0.4)

部署时所有资源情况都是正常的,关机重启虚拟机后集群资源状态异常

--

部署规划

域名地址备注
rac16192.168.31.16
rac17192.168.31.17
rac16vip192.168.31.26vip
rac17vip192.168.31.27vip
oraclescan192.168.31.116sacnip
rac16prv10.10.10.128私网地址
rac17prv10.10.10.129私网地址

下面是重启后的集群情况 RAC16

rac16 资源情况

[grid@rac16 /]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ARCH.dg
               ONLINE  ONLINE       rac16                                        
ora.DATA.dg
               ONLINE  ONLINE       rac16                                        
ora.GRID.dg
               ONLINE  ONLINE       rac16                                        
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac16                                        
ora.asm
               ONLINE  ONLINE       rac16                    Started             
ora.gsd
               OFFLINE OFFLINE      rac16                                        
ora.net1.network
               ONLINE  ONLINE       rac16                                        
ora.ons
               ONLINE  ONLINE       rac16                                        
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac16                                        
ora.cvu
      1        ONLINE  ONLINE       rac16                                        
ora.oc4j
      1        ONLINE  ONLINE       rac16                                        
ora.orcl.db
      1        ONLINE  ONLINE       rac16                    Open                
      2        ONLINE  OFFLINE                                                   
ora.rac16.vip
      1        ONLINE  ONLINE       rac16                                        
ora.rac17.vip
      1        ONLINE  INTERMEDIATE rac16                    FAILED OVER         
ora.scan1.vip
      1        ONLINE  ONLINE       rac16                                        
[grid@rac16 /]$ 

RAC16 集群状态

[grid@rac16 /]$ crsctl check cluster -all
**************************************************************
rac16:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
rac17:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
[grid@rac16 /]$ 
[grid@rac16 /]$ olsnodes -s -t -n
rac16   1       Active  Unpinned
[grid@rac16 /]$ 



RAC16 网卡信息


[grid@rac16 /]$ ifconfig 
ens33: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        inet 192.168.31.16  netmask 255.255.255.0  broadcast 192.168.31.255
        inet6 fe80::c315:6443:c805:41cd  prefixlen 64  scopeid 0x20<link>
        ether 00:0c:29:72:1a:1f  txqueuelen 1000  (Ethernet)
        RX packets 49578  bytes 4729665 (4.5 MiB)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 72608  bytes 26891735 (25.6 MiB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

ens33:1: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        inet 192.168.31.27  netmask 255.255.255.0  broadcast 192.168.31.255
        ether 00:0c:29:72:1a:1f  txqueuelen 1000  (Ethernet)

ens33:2: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        inet 192.168.31.116  netmask 255.255.255.0  broadcast 192.168.31.255
        ether 00:0c:29:72:1a:1f  txqueuelen 1000  (Ethernet)

ens33:3: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        inet 192.168.31.26  netmask 255.255.255.0  broadcast 192.168.31.255
        ether 00:0c:29:72:1a:1f  txqueuelen 1000  (Ethernet)

ens37: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        inet 10.10.10.128  netmask 255.255.255.0  broadcast 10.10.10.255
        inet6 fe80::329a:9458:8eb5:962  prefixlen 64  scopeid 0x20<link>
        ether 00:0c:29:72:1a:29  txqueuelen 1000  (Ethernet)
        RX packets 5614  bytes 4178420 (3.9 MiB)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 6060  bytes 8816924 (8.4 MiB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

ens37:1: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        inet 169.254.136.214  netmask 255.255.0.0  broadcast 169.254.255.255
        ether 00:0c:29:72:1a:29  txqueuelen 1000  (Ethernet)

lo: flags=73<UP,LOOPBACK,RUNNING>  mtu 65536
        inet 127.0.0.1  netmask 255.0.0.0
        inet6 ::1  prefixlen 128  scopeid 0x10<host>
        loop  txqueuelen 1000  (Local Loopback)
        RX packets 17702  bytes 13913960 (13.2 MiB)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 17702  bytes 13913960 (13.2 MiB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

virbr0: flags=4099<UP,BROADCAST,MULTICAST>  mtu 1500
        inet 192.168.122.1  netmask 255.255.255.0  broadcast 192.168.122.255
        ether 52:54:00:a2:7b:90  txqueuelen 1000  (Ethernet)
        RX packets 0  bytes 0 (0.0 B)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 0  bytes 0 (0.0 B)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

[grid@rac16 /]$ ifconfig |grep 192.168.31
        inet 192.168.31.16  netmask 255.255.255.0  broadcast 192.168.31.255
        inet 192.168.31.27  netmask 255.255.255.0  broadcast 192.168.31.255
        inet 192.168.31.116  netmask 255.255.255.0  broadcast 192.168.31.255
        inet 192.168.31.26  netmask 255.255.255.0  broadcast 192.168.31.255
[grid@rac16 /]$ 

RAC17 节点信息

Rac17 资源状态

[grid@rac17 /]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ARCH.dg
               ONLINE  ONLINE       rac17                                        
ora.DATA.dg
               ONLINE  ONLINE       rac17                                        
ora.GRID.dg
               ONLINE  ONLINE       rac17                                        
ora.LISTENER.lsnr
               ONLINE  OFFLINE      rac17                                        
ora.asm
               ONLINE  ONLINE       rac17                    Started             
ora.gsd
               OFFLINE OFFLINE      rac17                                        
ora.net1.network
               ONLINE  ONLINE       rac17                                        
ora.ons
               ONLINE  ONLINE       rac17                                        
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  OFFLINE                                                   
ora.cvu
      1        ONLINE  ONLINE       rac17                                        
ora.oc4j
      1        ONLINE  ONLINE       rac17                                        
ora.orcl.db
      1        ONLINE  OFFLINE                                                   
      2        ONLINE  ONLINE       rac17                    Open                
ora.rac16.vip
      1        ONLINE  OFFLINE                                                   
ora.rac17.vip
      1        ONLINE  OFFLINE                                                   
ora.scan1.vip
      1        ONLINE  OFFLINE                                                   
[grid@rac17 /]$ 


Rac17 节点状态


[grid@rac17 /]$ olsnodes -s -t -n
rac17   2       Active  Unpinned
[grid@rac17 /]$ crsctl check cluster -all
**************************************************************
rac16:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
rac17:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
[grid@rac17 /]$ 


RAC17 网卡状态


[grid@rac17 /]$ ifconfig 
ens33: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        inet 192.168.31.17  netmask 255.255.255.0  broadcast 192.168.31.255
        inet6 fe80::e6c2:bbb3:8c1e:f5c6  prefixlen 64  scopeid 0x20<link>
        ether 00:0c:29:93:6d:25  txqueuelen 1000  (Ethernet)
        RX packets 56804  bytes 5358292 (5.1 MiB)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 83849  bytes 29176855 (27.8 MiB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

ens37: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        inet 10.10.10.129  netmask 255.255.255.0  broadcast 10.10.10.255
        inet6 fe80::d5fb:1be3:89e4:f351  prefixlen 64  scopeid 0x20<link>
        ether 00:0c:29:93:6d:2f  txqueuelen 1000  (Ethernet)
        RX packets 6702  bytes 5736589 (5.4 MiB)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 6249  bytes 7310148 (6.9 MiB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

ens37:1: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        inet 169.254.145.18  netmask 255.255.0.0  broadcast 169.254.255.255
        ether 00:0c:29:93:6d:2f  txqueuelen 1000  (Ethernet)

lo: flags=73<UP,LOOPBACK,RUNNING>  mtu 65536
        inet 127.0.0.1  netmask 255.0.0.0
        inet6 ::1  prefixlen 128  scopeid 0x10<host>
        loop  txqueuelen 1000  (Local Loopback)
        RX packets 15989  bytes 10228258 (9.7 MiB)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 15989  bytes 10228258 (9.7 MiB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

virbr0: flags=4099<UP,BROADCAST,MULTICAST>  mtu 1500
        inet 192.168.122.1  netmask 255.255.255.0  broadcast 192.168.122.255
        ether 52:54:00:a2:7b:90  txqueuelen 1000  (Ethernet)
        RX packets 0  bytes 0 (0.0 B)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 0  bytes 0 (0.0 B)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

[grid@rac17 /]$ ifconfig |grep 192.168.31
        inet 192.168.31.17  netmask 255.255.255.0  broadcast 192.168.31.255

虚拟磁盘环境

img

磁盘权限


[root@rac17 bin]# ls -lh /dev/sd*
brw-rw---- 1 root disk     8,  0 5月  22 19:33 /dev/sda
brw-rw---- 1 root disk     8,  1 5月  22 19:33 /dev/sda1
brw-rw---- 1 root disk     8,  2 5月  22 19:33 /dev/sda2
brw-rw---- 1 grid asmadmin 8, 16 5月  22 20:19 /dev/sdb
brw-rw---- 1 grid asmadmin 8, 32 5月  22 20:19 /dev/sdc
brw-rw---- 1 grid asmadmin 8, 48 5月  22 20:19 /dev/sdd
[root@rac17 bin]# ls -lh /dev/asm-*
lrwxrwxrwx 1 root root 3 5月  22 20:14 /dev/asm-arch -> sdc
lrwxrwxrwx 1 root root 3 5月  22 20:18 /dev/asm-data -> sdd
lrwxrwxrwx 1 root root 3 5月  22 20:14 /dev/asm-grid -> sdb
[root@rac17 bin]# 

  • 写回答

5条回答 默认 最新

  • 阿里嘎多学长 2025-05-22 20:15
    关注

    阿里嘎多学长整理AIGC生成,因移动端显示问题导致当前答案未能完全显示,请使用PC端查看更加详细的解答过程

    Oracle RAC VIP重复注册问题

    问题描述:在部署 Oracle RAC (11.2.0.4) 到 CentOS 7 环境中,虚拟机重启后,集群资源状态异常,VIP 重复注册。

    解决方案:

    1. 检查 VIP 配置:检查 VIP 配置文件(通常在 /etc/hosts/etc/hostname 文件中),确保 VIP 地址没有被重复注册。
    2. 检查 Oracle RAC 配置:检查 Oracle RAC 配置文件(通常在 oraenv 文件中),确保 VIP 地址没有被重复注册。
    3. 检查网络配置:检查网络配置文件(通常在 /etc/sysconfig/network 文件中),确保 VIP 地址没有被重复注册。
    4. 检查 Oracle RAC 服务状态:使用 crsctl 命令检查 Oracle RAC 服务状态,确保 VIP 服务状态为 "online"。
    5. 检查 Oracle RAC log 文件:检查 Oracle RAC log 文件,查看是否有相关错误信息。

    如果以上步骤都无法解决问题,可以尝试以下解决方案:

    • 重启 Oracle RAC 服务:使用 crsctl 命令重启 Oracle RAC 服务。
    • 检查 Oracle RAC configuration 文件:检查 Oracle RAC configuration 文件,确保 VIP 地址没有被重复注册。
    • 重新部署 Oracle RAC:重新部署 Oracle RAC,确保 VIP 地址没有被重复注册。

    如果问题仍然无法解决,可以提供更多的日志信息和配置文件,以便更好地 troubleshoot。

    评论

报告相同问题?

问题事件

  • 专家修改了标签 5月22日
  • 修改了问题 5月22日
  • 创建了问题 5月22日