系统: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显示正常.
|