合 Oracle集群之ora.chad介绍
Tags： Oracle高可用racCHAAutonomous Health FrameworkchactlCluster Health Advisorora.chadAHF
ora.chad返回UNKNOWN
19c rac节点2的ora.chad返回UNKNOWN，如下：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 | [root@oracle-rac1 ~]# crsctl stat res -t -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.LISTENER.lsnr ONLINE ONLINE oracle-rac1 STABLE ONLINE ONLINE oracle-rac2 STABLE ora.chad ONLINE ONLINE oracle-rac1 STABLE ONLINE UNKNOWN oracle-rac2 Wrong check return,S TABLE ora.net1.network ONLINE ONLINE oracle-rac1 STABLE ONLINE ONLINE oracle-rac2 STABLE ora.ons ONLINE ONLINE oracle-rac1 STABLE ONLINE ONLINE oracle-rac2 STABLE -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup) 1 ONLINE ONLINE oracle-rac1 STABLE 2 ONLINE ONLINE oracle-rac2 STABLE 3 ONLINE OFFLINE STABLE ora.DATA.dg(ora.asmgroup) 1 ONLINE ONLINE oracle-rac1 STABLE 2 ONLINE ONLINE oracle-rac2 STABLE 3 OFFLINE OFFLINE STABLE ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE oracle-rac2 STABLE ora.OCR.dg(ora.asmgroup) 1 ONLINE ONLINE oracle-rac1 STABLE 2 ONLINE ONLINE oracle-rac2 STABLE 3 OFFLINE OFFLINE STABLE ora.asm(ora.asmgroup) 1 ONLINE ONLINE oracle-rac1 Started,STABLE 2 ONLINE ONLINE oracle-rac2 Started,STABLE 3 OFFLINE OFFLINE STABLE ora.asmnet1.asmnetwork(ora.asmgroup) 1 ONLINE ONLINE oracle-rac1 STABLE 2 ONLINE ONLINE oracle-rac2 STABLE 3 OFFLINE OFFLINE STABLE ora.cvu 1 ONLINE ONLINE oracle-rac2 STABLE ora.oracle-rac1.vip 1 ONLINE ONLINE oracle-rac1 STABLE ora.oracle-rac2.vip 1 ONLINE ONLINE oracle-rac2 STABLE ora.orcl.db 1 ONLINE ONLINE oracle-rac1 Open,HOME=/u01/app/o racle/product/19.3.0 /dbhome_1,STABLE 2 ONLINE ONLINE oracle-rac2 Open,HOME=/u01/app/o racle/product/19.3.0 /dbhome_1,STABLE ora.qosmserver 1 ONLINE ONLINE oracle-rac2 STABLE ora.scan1.vip 1 ONLINE ONLINE oracle-rac2 STABLE -------------------------------------------------------------------------------- [root@oracle-rac1 ~]# crsctl status res ora.chad NAME=ora.chad TYPE=ora.chad.type TARGET=ONLINE , ONLINE STATE=ONLINE on oracle-rac1, UNKNOWN on oracle-rac2 [root@oracle-rac1 ~]# crsctl stat res ora.chad -t -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.chad ONLINE ONLINE oracle-rac1 STABLE ONLINE UNKNOWN oracle-rac2 Wrong check return,S TABLE -------------------------------------------------------------------------------- [root@oracle-rac1 ~]# srvctl start cha PRCR-1079 : Failed to start resource ora.chad CRS-2680: Clean of 'ora.chad' on 'oracle-rac2' failed [root@oracle-rac1 ~]# chactl status monitoring nodes oracle-rac1 monitoring databases orcl [root@oracle-rac2 diag]# srvctl status cha Oracle Cluster Health Analysis Service is enabled Oracle Cluster Health Analysis Service is running on nodes: oracle-rac1 |
chad stands for the Cluster Health Advisor (CHA) daemon which is is part of the Oracle Autonomous Health Framework(AHF), It continuously monitors cluster nodes and Oracle RAC databases for performance and availability issues.
Oracle Cluster Health Advisor runs as a highly available cluster resource, ochad, on each node in the cluster.
Each Oracle Cluster Health Advisor daemon (ochad) monitors the operating system on the cluster node and optionally, each Oracle Real Application Clusters (Oracle RAC) database instance on the node.
The ochad daemon receives operating system metric data from the Cluster Health Monitor and gets Oracle RAC database instance metrics from a memory-mapped file. The daemon does not require a connection to each database instance. This data, along with the selected model, is used in the Health Prognostics Engine of Oracle Cluster Health Advisor for both the node and each monitored database instance in order to analyze their health multiple times a minute.
