oracle集群基本查询命令

查询 CRS 的软件版本
#  crsctl query crs softwareversion

查询主节点-grid用户执行 oclumon manage -get MASTER REPLICA
+ASM1:/home/grid@db1>   oclumon manage -get MASTER REPLICA

Master = db1
Replica = db2

集群资源状态crsctl check crs

+ASM1:/home/grid@db1> crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online

Vote disks配置        crsctl query css votedisk

+ASM1:/home/grid@db1> crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   a8f3865e32764f52bf0e232f56abee3d (/dev/mapper/crs1) [CRS]
 2. ONLINE   0b5a32f5ab2e4f6bbf0eb66fe3eddb66 (/dev/mapper/crs2) [CRS]
 3. ONLINE   7b547135ac334f68bf977e42a1b9ae8c (/dev/mapper/crs3) [CRS]
 4. ONLINE   2b71acf5df4c4f02bf43a9d704478b32 (/dev/mapper/crs4) [CRS]
 5. ONLINE   8067c78fe2c44f1ebfb35be9d71de25e (/dev/mapper/crs5) [CRS]
Located 5 voting disk(s).

集群OCR配置情况:ocrcheck

[root@db1 ~]#  ocrcheck
Status of Oracle Cluster Registry is as follows :
     Version                  :          3
     Total space (kbytes)     :     262120
     Used space (kbytes)      :       2948
     Available space (kbytes) :     259172
     ID                       :  623071370
     Device/File Name         :       +CRS
                                    Device/File integrity check succeeded

                                    Device/File not configured

                                    Device/File not configured

                                    Device/File not configured

                                    Device/File not configured

     Cluster registry integrity check succeeded

     Logical corruption check succeeded

OCR自动备份: ocrconfig -showbackup

ASM1:/home/grid@db1> ocrconfig -showbackup

db1     2023/03/02 16:28:40     /u01/app/grid/product/11.2.0/grid_1/cdata/db-cluster/backup00.ocr

db1     2023/03/02 12:28:40     /u01/app/grid/product/11.2.0/grid_1/cdata/db-cluster/backup01.ocr

db1     2023/03/02 08:28:40     /u01/app/grid/product/11.2.0/grid_1/cdata/db-cluster/backup02.ocr

db1     2023/03/01 12:28:38     /u01/app/grid/product/11.2.0/grid_1/cdata/db-cluster/day.ocr

db1     2023/02/24 04:28:26     /u01/app/grid/product/11.2.0/grid_1/cdata/db-cluster/week.ocr
PROT-25: Manual backups for the Oracle Cluster Registry are not available

验证软件的完整性- -使用grid用户
cluvfy comp software -verbose      

 cluvfy对集群ASM组件进行的检查----使用grid用户
 cluvfy comp asm -n db1,db2 -verbose

cluvfy stage -pre crsinst -n db1,db2 -verbose     

cluvfy comp nodecon -n db1,db2 -verbose

对两个节点做硬件和操作系统的后期检查--grid用户执行
cluvfy stage -post hwos -n db1,db2

检查是否有共享存储--grid用户执行
cluvfy comp ssa -n all -verbose

检查节点间的连同性
cluvfy comp nodereach -n all -verbose

检查对指定的网络接口--grid用户执行
cluvfy comp nodecon -n all  -verbose

检查ons vip gsd --grid用户执行
cluvfy comp nodeapp -n all -verbose

验证用户的等价性
cluvfy comp admprv -n all -o user_equiv -verbose

检查clusterware的组件是否健康
cluvfy comp crs -n all -verbose
cluvfy comp crs -allnodes      --19C命令
检查ocr是否健康-无风险
cluvfy comp ocr -n all -verbose

集群组件查查
cluvfy comp crs -n all -verbose
cluvfy comp clumgr -n all -verbose
cluvfy comp ocr -n all -verbose
集群一致性检查
cluvfy comp clu

grid用户执行，查看当前运行环境是否达标

cluvfy comp sys -n all -p crs -verbose

pre crsinst ：安装集群管理软件（GI)之前
post crsinst：安装集群管理软件之后
pre dbinst：  安装数据库软件之前
pre dbcfg：      创建数据库之前

 ##grid用户执行-可以检查出不合理的参数
 cluvfy stage -pre patch

+ASM1:/home/grid@db1> cluvfy stage -pre patch

Performing following verification checks ...

  cluster upgrade state ...PASSED
  OLR Integrity ...PASSED
  Hosts File ...PASSED
  Free Space: db2:/ ...PASSED
  Free Space: db1:/ ...PASSED
  OPatch utility version consistency ...PASSED
  Software home: /u01/app/19.0.0/grid_1 ...PASSED
  ORAchk checks ...
    Oracle database software owner soft nproc shell limit ...PASSED
    Software maintenance best practices ...PASSED
    Hostname formatting ...PASSED
    SELinux status ...PASSED
    ip_local_port_range ...PASSED
    VIP NIC bonding config. ...PASSED
    Check for parameter net.core.wmem_default ...WARNING
    Oracle database software owner soft stack shell limits ...PASSED
    Check for parameter semmsl ...PASSED
    Check for parameter net.core.rmem_default ...WARNING
    Check for parameter net.core.wmem_max ...WARNING
    pam_limits check ...PASSED
    Disks without Disk Group ...PASSED
    /etc directory free space ...PASSED
    NTP with correct setting ...WARNING
    /var directory free space ...PASSED
    NIC Bonding Mode interconnect ...PASSED
    Check for parameter semmni ...WARNING
    NIC Bonding Mode Public ...PASSED
    Check for parameter semmns ...PASSED
    Oracle database software owner hard nproc shell limits ...PASSED
    Clusterware resource status ...PASSED
    oradism executable permission ...PASSED
    Interconnect NIC bonding config. ...PASSED
    oradism executable ownership ...PASSED
    Verify operating system hugepages count satisfies total SGA requirements ...FAILED
    Non-routable network for interconnect ...PASSED
    ORA_CRS_HOME env variable for Grid infrastructure owner ...PASSED
    Oracle database software owner hard stack shell limits ...PASSED
    Oracle database software owner hard nofile shell limits ...PASSED
    Oracle database software owner  soft nofile shell limits ...PASSED
    Check for parameter kernel.shmmni ...WARNING
    /tmp directory free space ...PASSED
    Check for parameter kernel.shmall ...WARNING
  ORAchk checks ...FAILED

Pre-check for Patch Application was unsuccessful.
Checks did not pass for the following nodes:
    db1

Failures were encountered during execution of CVU verification request "stage -pre patch".

ORAchk checks ...FAILED
  Check for parameter net.core.wmem_default ...WARNING
  db1: AHF-4659: net.core.wmem_default is not configured according to
  recommendation

  Check for parameter net.core.rmem_default ...WARNING
  db1: AHF-5392: net.core.rmem_default Is NOT Configured According to
  Recommendation

  Check for parameter net.core.wmem_max ...WARNING
  db1: AHF-5303: net.core.wmem_max Is NOT Configured According to
  Recommendation

  NTP with correct setting ...WARNING
  db1: AHF-1688: NTP is not running with correct setting

  Check for parameter semmni ...WARNING
  db1: AHF-1160: Kernel Parameter SEMMNI Is Lower Than The Recommended Value

  Verify operating system hugepages count satisfies total SGA requirements
  ...FAILED
  db1: AHF-2711: Operating system hugepages count does not satisfy total SGA
  requirements

  Check for parameter kernel.shmmni ...WARNING
  db1: AHF-1170: Kernel Parameter kernel.shmmni  Is Lower Than The
  Recommended Value

  Check for parameter kernel.shmall ...WARNING
  db1: AHF-1161: Kernel Parameter kernel.shmall Is lower than the recommended
  value

CVU operation performed:      stage -pre patch
Date:                         Aug 9, 2023 7:33:35 PM
CVU version:                  19.19.0.0.0 (040623x8664)
Clusterware version:          19.0.0.0.0
CVU home:                     /u01/app/19.0.0/grid_1
Grid home:                    /u01/app/19.0.0/grid_1
User:                         grid
Operating system:             Linux4.14.35-1818.3.3.el7uek.x86_64

手动漂移scan ip      # srvctl relocate scan -i 1 -i db1