测试 19c asm flex 的 功能: 在节点1上面执行 srvctl stop asm -node test-rac19c-01 -stopoption abort -force 报错 因为 ora.asm_listener.type 是asm监听的主节点,节点1为主节点,主节点无法关闭 [grid@test-rac19c-01 ~]$ srvctl stop asm -node test-rac19c-01 -stopoption abort -force PRCR-1214 : failed to stop resource group ora.asmgroup PRCR-1214 : failed to stop resource group ora.asmgroup CRS-2670: Unable to start/relocate 'ora.asm_listener.type' because 'ora.asm' has a stop-time 'hard' dependency on it CRS-5027: The ASM instance on node "test-rac19c-01" cannot be stopped because it is currently being used by Cluster Ready Services. CRS-0222: Resource 'RGI: ora.asmgroup 1 1' has dependency error. [grid@test-rac19c-01 ~]$ [grid@test-rac19c-01 ~]$ 然后在节点2上执行:正常关闭 [grid@test-rac19c-02 ~]$ srvctl stop asm -node test-rac19c-02 -stopoption abort -force [grid@test-rac19c-02 ~]$ 然后 查看看集群的状态: 节点1: [grid@test-rac19c-01 ~]$ crsctl status res -t -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.LISTENER.lsnr ONLINE ONLINE test-rac19c-01 STABLE ONLINE ONLINE test-rac19c-02 STABLE ora.chad ONLINE ONLINE test-rac19c-01 STABLE ONLINE ONLINE test-rac19c-02 STABLE ora.net1.network ONLINE ONLINE test-rac19c-01 STABLE ONLINE ONLINE test-rac19c-02 STABLE ora.ons ONLINE ONLINE test-rac19c-01 STABLE ONLINE ONLINE test-rac19c-02 STABLE -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup) 1 ONLINE ONLINE test-rac19c-01 STABLE 2 OFFLINE OFFLINE STABLE 3 ONLINE OFFLINE STABLE ora.DATADG.dg(ora.asmgroup) 1 ONLINE ONLINE test-rac19c-01 STABLE 2 OFFLINE OFFLINE STABLE 3 OFFLINE OFFLINE STABLE ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE test-rac19c-01 STABLE ora.OCRDG.dg(ora.asmgroup) 1 ONLINE ONLINE test-rac19c-01 STABLE 2 OFFLINE OFFLINE STABLE 3 OFFLINE OFFLINE STABLE ora.asm(ora.asmgroup) 1 ONLINE ONLINE test-rac19c-01 Started,STABLE 2 OFFLINE OFFLINE Instance Shutdown,ST ABLE 3 OFFLINE OFFLINE STABLE ora.asmnet1.asmnetwork(ora.asmgroup) 1 ONLINE ONLINE test-rac19c-01 STABLE 2 OFFLINE OFFLINE STABLE 3 OFFLINE OFFLINE STABLE ora.cvu 1 ONLINE ONLINE test-rac19c-01 STABLE ora.prod19c.db 1 ONLINE ONLINE test-rac19c-01 Open,HOME=/u01/app/o racle/product/19.0.0 /dbhome_1,STABLE 2 ONLINE ONLINE test-rac19c-02 Open,HOME=/u01/app/o racle/product/19.0.0 /dbhome_1,STABLE ora.qosmserver 1 ONLINE ONLINE test-rac19c-01 STABLE ora.scan1.vip 1 ONLINE ONLINE test-rac19c-01 STABLE ora.test-rac19c-01.vip 1 ONLINE ONLINE test-rac19c-01 STABLE ora.test-rac19c-02.vip 1 ONLINE ONLINE test-rac19c-02 STABLE -------------------------------------------------------------------------------- 节点2: [grid@test-rac19c-02 ~]$ crsctl status res -t -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.LISTENER.lsnr ONLINE ONLINE test-rac19c-01 STABLE ONLINE ONLINE test-rac19c-02 STABLE ora.chad ONLINE ONLINE test-rac19c-01 STABLE ONLINE ONLINE test-rac19c-02 STABLE ora.net1.network ONLINE ONLINE test-rac19c-01 STABLE ONLINE ONLINE test-rac19c-02 STABLE ora.ons ONLINE ONLINE test-rac19c-01 STABLE ONLINE ONLINE test-rac19c-02 STABLE -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup) 1 ONLINE ONLINE test-rac19c-01 STABLE 2 OFFLINE OFFLINE STABLE 3 ONLINE OFFLINE STABLE ora.DATADG.dg(ora.asmgroup) 1 ONLINE ONLINE test-rac19c-01 STABLE 2 OFFLINE OFFLINE STABLE 3 OFFLINE OFFLINE STABLE ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE test-rac19c-01 STABLE ora.OCRDG.dg(ora.asmgroup) 1 ONLINE ONLINE test-rac19c-01 STABLE 2 OFFLINE OFFLINE STABLE 3 OFFLINE OFFLINE STABLE ora.asm(ora.asmgroup) 1 ONLINE ONLINE test-rac19c-01 Started,STABLE 2 OFFLINE OFFLINE Instance Shutdown,ST ABLE 3 OFFLINE OFFLINE STABLE ora.asmnet1.asmnetwork(ora.asmgroup) 1 ONLINE ONLINE test-rac19c-01 STABLE 2 OFFLINE OFFLINE STABLE 3 OFFLINE OFFLINE STABLE ora.cvu 1 ONLINE ONLINE test-rac19c-01 STABLE ora.prod19c.db 1 ONLINE ONLINE test-rac19c-01 Open,HOME=/u01/app/o racle/product/19.0.0 /dbhome_1,STABLE 2 ONLINE ONLINE test-rac19c-02 Open,HOME=/u01/app/o racle/product/19.0.0 /dbhome_1,STABLE ora.qosmserver 1 ONLINE ONLINE test-rac19c-01 STABLE ora.scan1.vip 1 ONLINE ONLINE test-rac19c-01 STABLE ora.test-rac19c-01.vip 1 ONLINE ONLINE test-rac19c-01 STABLE ora.test-rac19c-02.vip 1 ONLINE ONLINE test-rac19c-02 STABLE -------------------------------------------------------------------------------- [grid@test-rac19c-02 ~]$ 查看节点1的pmon进程: 发现数据库正常服务 [oracle@test-rac19c-01 ~]$ [oracle@test-rac19c-01 ~]$ ps -ef |grep pmon grid 11647 1 0 17:07 ? 00:00:00 asm_pmon_+ASM1 oracle 13359 1 0 17:08 ? 00:00:00 ora_pmon_prod19c1 oracle 52632 30576 0 18:06 pts/0 00:00:00 grep --color=auto pmon [oracle@test-rac19c-01 ~]$ 查看节点2的pmon 进程:发现数据库正常服务,但是asm进程没有了,这就是 flex asm 的功能,增加了一定的伸缩性与容错性 [grid@test-rac19c-02 ~]$ [grid@test-rac19c-02 ~]$ ps -ef |grep pmon oracle 15747 1 0 17:09 ? 00:00:00 ora_pmon_prod19c2 grid 46983 17662 0 18:06 pts/0 00:00:00 grep --color=auto pmon [grid@test-rac19c-02 ~]$