oracle 状态d,oracle RAC 诊断集群状态命令

----------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

test1is running on node node1

Instance

test2is 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