ITPub博客

首页 > 数据库 > Oracle > oracle RAC 诊断集群状态命令

oracle RAC 诊断集群状态命令

原创 Oracle 作者:sambatuzi 时间:2020-07-24 18:41:15 0 删除 编辑

----------crsctl check 命令 ------------

$ crsctl check has                                                          ##检查has组件状态

CRS-4638: Oracle High Availability Services is online


$ crsctl check crs                                                            ##检查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


$crsctl query crs activeversion                                       ## 列出Oracle Clusterware操作版本

Oracle Clusterware active version on the cluster is [11.2.0.4.0]


$crsctl query crs releaseversion                                                 ## 列出Oracle Clusterware发行版本

Oracle High Availability Services release version on the local node is [11.2.0.4.0]


$ crsctl query crs softwareversion                                  ## 列出已安装的Oracle Clusterware软件的版本      

Oracle Clusterware version on node [node1] is [11.2.0.4.0]   


$ crsctl query crs softwareversion -all 

Oracle Clusterware version on node [node1] is [11.2.0.4.0]

Oracle Clusterware version on node [node2] is [11.2.0.4.0]


$ crsctl query css votedisk                                                 ## 列出群集同步服务使用的裁决文件

##  STATE    File Universal Id                                         File Name                     Disk group

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

 1. ONLINE   2dea0d4c4b964fa8bf51ee03537ca179     (/dev/asm-diskaq)            [CRS]

 2. ONLINE   70e8ca3eaa164f7bbf3d10a78cc7aa24      (/dev/asm-diskap)           [CRS]

 3. ONLINE   4f9f14a9d17a4f1dbf712cfefa75c345         (/dev/asm-diskar)            [CRS]


crsctl query crs  administrator                                        ## 显示管理员列表

CRS Administrator List: *



---------crsctl statu 可以显示RAC集群组件的相关信息------------

$ crsctl status serverpool 

NAME=Free

ACTIVE_SERVERS=


NAME=Generic

ACTIVE_SERVERS=node1 node2


NAME=ora.test

ACTIVE_SERVERS=node1 node2


$ crsctl status serverpool -p 

NAME=Free

IMPORTANCE=0

MIN_SIZE=0

MAX_SIZE=-1

SERVER_NAMES=

PARENT_POOLS=

EXCLUSIVE_POOLS=

ACL=owner:grid:rwx,pgrp:oinstall:rwx,other::r-x


NAME=Generic

IMPORTANCE=0

MIN_SIZE=0

MAX_SIZE=-1

SERVER_NAMES=node1 node2

PARENT_POOLS=

EXCLUSIVE_POOLS=

ACL=owner:grid:r-x,pgrp:oinstall:r-x,other::r-x


NAME=ora.test

IMPORTANCE=1

MIN_SIZE=0

MAX_SIZE=-1

SERVER_NAMES=node1 node2

PARENT_POOLS=Generic

EXCLUSIVE_POOLS=

ACL=owner:oracle:rwx,pgrp:oinstall:rwx,other::r--


crsctl status serverpool  ora.test -p 

NAME=ora.test

IMPORTANCE=1

MIN_SIZE=0

MAX_SIZE=-1

SERVER_NAMES=node1 node2

PARENT_POOLS=Generic

EXCLUSIVE_POOLS=

ACL=owner:oracle:rwx,pgrp:oinstall:rwx,other::r--



-------srvctl status  可以显示集群关系的相关资源的状态信息----------

$ srvctl status server -n node2,node1 

Server name: node2

Server state: ONLINE

Server name: node1

Server state: ONLINE


$ srvctl status database -d test

Instance test1 is running on node node1

Instance test2 is running on node node2


$srvctl status instance  -d test-i test1

Instance test1 is running on node node1


$ srvctl status  nodeapps

VIP test_vip1 is enabled

VIP test_vip1 is running on node: node1

VIP test_vip2 is enabled

VIP test_vip2 is running on node: node2

Network is enabled

Network is running on node: node1

Network is running on node: node2

GSD is disabled

GSD is not running on node: node1

GSD is not running on node: node2

ONS is enabled

ONS daemon is running on node: node1

ONS daemon is running on node: node2


$ srvctl status  nodeapps -n node1

VIP test_vip1 is enabled

VIP test_vip1 is running on node: node1

Network is enabled

Network is running on node: node1

GSD is disabled

GSD is not running on node: node1

ONS is enabled

ONS daemon is running on node: node1


$ srvctl status  asm

ASM is running on node2,node1


$srvctl status  diskgroup -g DATA 

Disk Group DATA is running on node2,node1


$ srvctl status  listener

Listener LISTENER is enabled

Listener LISTENER is running on node(s): node2,node1


$ srvctl status  listener -n node2

Listener LISTENER is enabled on node(s): node2

Listener LISTENER is running on node(s): node2


$ srvctl status  scan

SCAN VIP scan1 is enabled

SCAN VIP scan1 is running on node node2

SCAN VIP scan2 is enabled

SCAN VIP scan2 is running on node node1


$ srvctl status  scan -i  1

SCAN VIP scan1 is enabled

SCAN VIP scan1 is running on node node2


$ srvctl status  scan_listener

SCAN Listener LISTENER_SCAN1 is enabled

SCAN listener LISTENER_SCAN1 is running on node node2

SCAN Listener LISTENER_SCAN2 is enabled

SCAN listener LISTENER_SCAN2 is running on node node1


$ srvctl status  scan_listener -i 1 

SCAN Listener LISTENER_SCAN1 is enabled

SCAN listener LISTENER_SCAN1 is running on node node2


$ srvctl status  vip -n node2

VIP test_vip2 is enabled

VIP test_vip2 is running on node: node2







来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31519308/viewspace-2706856/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 12C RMAN备份恢复
请登录后发表评论 登录
全部评论

注册时间:2018-01-30

  • 博文量
    19
  • 访问量
    7668