重庆思庄Oracle、Redhat认证学习论坛

标题: 集群一个节点的vip状态为INTERMEDIATE [打印本页]

作者: denglj 时间: 2022-8-30 13:03
标题: 集群一个节点的vip状态为INTERMEDIATE

系统：oel 7.9

数据库：oracle19.12

环境：rac (双节点)

问题描述：查看集群状态时，发现节点2的ora.hisdb2.vip状态为“INTERMEDIATE”、“FAILEDOVER”，如下所示：

[grid@hisdb1~]$ crsctl stat res -t

--------------------------------------------------------------------------------

Name Target State Server Statedetails

--------------------------------------------------------------------------------

LocalResources

--------------------------------------------------------------------------------

ora.LISTENER.lsnr

ONLINE ONLINE hisdb1 STABLE

ONLINE OFFLINE hisdb2 STABLE

ora.chad

ONLINE ONLINE hisdb1 STABLE

ONLINE ONLINE hisdb2 STABLE

ora.net1.network

ONLINE ONLINE hisdb1 STABLE

ONLINE ONLINE hisdb2 STABLE

ora.ons

ONLINE ONLINE hisdb1 STABLE

ONLINE ONLINE hisdb2 STABLE

ora.proxy_advm

OFFLINE OFFLINE hisdb1 STABLE

OFFLINE OFFLINE hisdb2 STABLE

--------------------------------------------------------------------------------

ClusterResources

--------------------------------------------------------------------------------

ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)

1 ONLINE ONLINE hisdb1 STABLE

2 ONLINE ONLINE hisdb2 STABLE

ora.DATA.dg(ora.asmgroup)

1 ONLINE ONLINE hisdb1 STABLE

2 ONLINE ONLINE hisdb2 STABLE

ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE hisdb1 STABLE

ora.OCR.dg(ora.asmgroup)

1 ONLINE ONLINE hisdb1 STABLE

2 ONLINE ONLINE hisdb2 STABLE

ora.asm(ora.asmgroup)

1 ONLINE ONLINE hisdb1 Started,STABLE

2 ONLINE ONLINE hisdb2 Started,STABLE

ora.asmnet1.asmnetwork(ora.asmgroup)

1 ONLINE ONLINE hisdb1 STABLE

2 ONLINE ONLINE hisdb2 STABLE

ora.cvu

1 ONLINE ONLINE hisdb2 STABLE

ora.heal.db

1 ONLINE ONLINE hisdb1 Open,HOME=/u01/app/o

racle/product/19.12.

0/db,STABLE

2 ONLINE ONLINE hisdb2 Open,HOME=/u01/app/o

racle/product/19.12.

0/db,STABLE

ora.hisdb1.vip

1 ONLINE ONLINE hisdb1 STABLE

ora.hisdb2.vip

1 ONLINE INTERMEDIATE hisdb1 FAILED OVER,STABLE

ora.qosmserver

1 ONLINE ONLINE hisdb2 STABLE

1 ONLINE ONLINE hisdb1 STABLE

--------------------------------------------------------------------------------

异常原因：两个节点同时启动，造成VIP资源抢夺导致.

解决方案：重启集群监听.

解决过程：

[grid@hisdb1~]$ srvctl stop listener -l LISTENER

[grid@hisdb1~]$ crsctl stat res -t

--------------------------------------------------------------------------------

Name Target State Server Statedetails

--------------------------------------------------------------------------------

LocalResources

--------------------------------------------------------------------------------

ora.LISTENER.lsnr

OFFLINE OFFLINE hisdb1 STABLE

OFFLINE OFFLINE hisdb2 STABLE

……

[grid@hisdb1~]$ srvctl start listener -l LISTENER

[grid@hisdb1~]$ crsctl stat res -t

--------------------------------------------------------------------------------

Name Target State Server Statedetails

--------------------------------------------------------------------------------

LocalResources

--------------------------------------------------------------------------------

ora.LISTENER.lsnr

ONLINE ONLINE hisdb1 STABLE

ONLINE ONLINE hisdb2 STABLE

ora.chad

ONLINE ONLINE hisdb1 STABLE

ONLINE ONLINE hisdb2 STABLE

ora.net1.network

ONLINE ONLINE hisdb1 STABLE

ONLINE ONLINE hisdb2 STABLE

ora.ons

ONLINE ONLINE hisdb1 STABLE

ONLINE ONLINE hisdb2 STABLE

ora.proxy_advm

OFFLINE OFFLINE hisdb1 STABLE

OFFLINE OFFLINE hisdb2 STABLE

--------------------------------------------------------------------------------

ClusterResources

--------------------------------------------------------------------------------

ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)

1 ONLINE ONLINE hisdb1 STABLE

2 ONLINE ONLINE hisdb2 STABLE

ora.DATA.dg(ora.asmgroup)

1 ONLINE ONLINE hisdb1 STABLE

2 ONLINE ONLINE hisdb2 STABLE

ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE hisdb1 STABLE

ora.OCR.dg(ora.asmgroup)

1 ONLINE ONLINE hisdb1 STABLE

2 ONLINE ONLINE hisdb2 STABLE

ora.asm(ora.asmgroup)

1 ONLINE ONLINE hisdb1 Started,STABLE

2 ONLINE ONLINE hisdb2 Started,STABLE

ora.asmnet1.asmnetwork(ora.asmgroup)

1 ONLINE ONLINE hisdb1 STABLE

2 ONLINE ONLINE hisdb2 STABLE

ora.cvu

1 ONLINE ONLINE hisdb2 STABLE

ora.heal.db

1 ONLINE ONLINE hisdb1 Open,HOME=/u01/app/o

racle/product/19.12.

0/db,STABLE

2 ONLINE ONLINE hisdb2 Open,HOME=/u01/app/o

racle/product/19.12.

0/db,STABLE

ora.hisdb1.vip

1 ONLINE ONLINE hisdb1 STABLE

ora.hisdb2.vip

1 ONLINE ONLINE hisdb2 STABLE

ora.qosmserver

1 ONLINE ONLINE hisdb2 STABLE

1 ONLINE ONLINE hisdb1 STABLE

--------------------------------------------------------------------------------

说明：重启监听后，ora.hisdb2.vip显示正常.

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)