一.巡检RAC数据库

1.1列出数据库

[grid@node1 ~]$ srvctl config database
racdb
[grid@node1 ~]$

1.2列出数据库的实例

[grid@node1 ~]$ srvctl status database -d racdb
Instance racdb1 is running on node node1
Instance racdb2 is running on node node2

1.3数据库的配置

[grid@node1 ~]$ srvctl config database -d racdb -a
Database unique name: racdb
Database name: racdb
Oracle home: /u01/app/oracle/11.2./dbhome_1
Oracle user: oracle
Spfile: +DATA/racdb/spfileracdb.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: racdb
Database instances: racdb1,racdb2
Disk Groups: DATA
Services:
Database is enabled
Database is administrator managed
[grid@node1 ~]$

二.巡检Grid

2.1集群名称

[grid@node1 ~]$ cemutlo -n
scan-cluster
[grid@node1 ~]$

2.2检查集群栈状态

[grid@node1 ~]$ crsctl check cluster -all
**************************************************************
node1:
CRS-: Cluster Ready Services is online
CRS-: Cluster Synchronization Services is online
CRS-: Event Manager is online
**************************************************************
node2:
CRS-: Cluster Ready Services is online
CRS-: Cluster Synchronization Services is online
CRS-: Event Manager is online
**************************************************************
[grid@node1 ~]$

2.3 集群的资源

[grid@node1 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.LISTENER.lsnr
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.asm
ONLINE ONLINE node1 Started
ONLINE ONLINE node2 Started
ora.eons
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.gsd
OFFLINE OFFLINE node1
OFFLINE OFFLINE node2
ora.net1.network
ONLINE ONLINE node1
ONLINE ONLINE node2
ora.ons
ONLINE ONLINE node1
ONLINE ONLINE node2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
ONLINE ONLINE node2
ora.LISTENER_SCAN2.lsnr
ONLINE ONLINE node1
ora.LISTENER_SCAN3.lsnr
ONLINE ONLINE node1
ora.node1.vip
ONLINE ONLINE node1
ora.node2.vip
ONLINE ONLINE node2
ora.oc4j
OFFLINE OFFLINE
ora.racdb.db
ONLINE ONLINE node1 Open
ONLINE OFFLINE
ora.scan1.vip
ONLINE ONLINE node2
ora.scan2.vip
ONLINE ONLINE node1
ora.scan3.vip
ONLINE ONLINE node1
[grid@node1 ~]$

主机node1的更加详细的资源

[grid@node1 ~]$ crsctl status res -t -init
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
ONLINE ONLINE node1 Started
ora.crsd
ONLINE ONLINE node1
ora.cssd
ONLINE ONLINE node1
ora.cssdmonitor
ONLINE ONLINE node1
ora.ctssd
ONLINE ONLINE node1 ACTIVE:
ora.diskmon
ONLINE ONLINE node1
ora.evmd
ONLINE ONLINE node1
ora.gipcd
ONLINE ONLINE node1
ora.gpnpd
ONLINE ONLINE node1
ora.mdnsd
ONLINE ONLINE node1
[grid@node1 ~]$

主机node2的更加详细的资源

[grid@node2 ~]$ crsctl status res -t -init
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
ONLINE ONLINE node2 Started
ora.crsd
ONLINE ONLINE node2
ora.cssd
ONLINE ONLINE node2
ora.cssdmonitor
ONLINE ONLINE node2
ora.ctssd
ONLINE ONLINE node2 ACTIVE:-
ora.diskmon
ONLINE ONLINE node2
ora.evmd
ONLINE ONLINE node2
ora.gipcd
ONLINE ONLINE node2
ora.gpnpd
ONLINE ONLINE node2
ora.mdnsd
ONLINE ONLINE node2
[grid@node2 ~]$

2.4检查节点应用

[grid@node1 ~]$ srvctl status nodeapps
VIP node1-vip is enabled
VIP node1-vip is running on node: node1
VIP node2-vip is enabled
VIP node2-vip 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
eONS is enabled
eONS daemon is running on node: node1
eONS daemon is running on node: node2
[grid@node1 ~]$

2.5 检查SCAN

检查scan-ip地址的配置
[grid@node1 ~]$ srvctl config scan
SCAN name: scan-cluster.com, Network: /192.168.0.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /scan-cluster/192.168.0.24
SCAN VIP name: scan2, IP: /scan-cluster/192.168.0.25
SCAN VIP name: scan3, IP: /scan-cluster/192.168.0.26
[grid@node1 ~]$ 检查scan-ip地址的实际分布及状态
[grid@node1 ~]$ 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
SCAN VIP scan3 is enabled
SCAN VIP scan3 is running on node node1
[grid@node1 ~]$ 检查scan监听配置
[grid@node1 ~]$ srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:
SCAN Listener LISTENER_SCAN2 exists. Port: TCP:
SCAN Listener LISTENER_SCAN3 exists. Port: TCP:
[grid@node1 ~]$ 检查scan监听状态
[grid@node1 ~]$ 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
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node node1
[grid@node1 ~]$

2.6 检查VIP和监听

检查VIP的配置情况
[grid@node1 ~]$ srvctl config vip -n node1
VIP exists.:node1
VIP exists.: /node1-vip/192.168.0.21/255.255.255.0/eth0
[grid@node1 ~]$ srvctl config vip -n node2
VIP exists.:node2
VIP exists.: /node2-vip/192.168.0.31/255.255.255.0/eth0
[grid@node1 ~]$ 检查VIP的状态
[grid@node1 ~]$ srvctl status nodeapps

[grid@node1 ~]$ srvctl status vip -n node1
VIP node1-vip is enabled
VIP node1-vip is running on node: node1
[grid@node1 ~]$ srvctl status vip -n node2
VIP node2-vip is enabled
VIP node2-vip is running on node: node2
[grid@node1 ~]$ 检查本地监听配置:
[grid@node1 ~]$ srvctl config listener -a
Name: LISTENER
Network: , Owner: grid
Home: <CRS home>
/u01/app/11.2./grid on node(s) node2,node1
End points: TCP: 检查本地监听状态:
[grid@node1 ~]$ srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): node1,node2
[grid@node1 ~]$

2.7 检查ASM

检查ASM状态
[grid@node1 ~]$ srvctl status asm -a
ASM is running on node1,node2
ASM is enabled. 检查ASM配置
[grid@node1 ~]$ srvctl config asm -a
ASM home: /u01/app/11.2.0/grid
ASM listener: LISTENER
ASM is enabled.
[grid@node1 ~]$ 检查磁盘组
[grid@node1 ~]$ srvctl status diskgroup -g DATA
Disk Group DATA is running on node1,node2
[grid@node1 ~]$ 查看ASM磁盘
[root@node1 bin]# oracleasm listdisks
VOL1
VOL2
[root@node1 bin]# 查看物理磁盘与asm 磁盘对应关系
[root@node1 bin]# oracleasm querydisk -v -p VOL1
Disk "VOL1" is a valid ASM disk
/dev/sdb1: LABEL="VOL1" TYPE="oracleasm"
[root@node1 bin]#

2.8检查集群节点间的时钟同步

检查节点node1的时间同步
[grid@node1 ~]$ cluvfy comp clocksync -verbose
.......
Verification of Clock Synchronization across the cluster nodes was successful.
[grid@node1 ~]$
检查节点node2的时间同步
[grid@node2 ~]$ cluvfy comp clocksync -verbose
..............
CTSS is in Active state. Proceeding with check of clock time offsets on all nodes...
Reference Time Offset Limit: 1000.0 msecs
Check: Reference Time Offset
Node Name Time Offset Status
------------ ------------------------ ------------------------
node2 -89900.0 failed
Result: PRVF-9661 : Time offset is NOT within the specified limits on the following nodes:
"[node2]" PRVF-9652 : Cluster Time Synchronization Services check failed Verification of Clock Synchronization across the cluster nodes was unsuccessful on all the specified nodes.
[grid@node2 ~]$

  注:节点2的服务器时间出现问题

  至此,对Grid的巡检基本上就算完成了

最新文章

  1. iOS 保持界面流畅的技巧 (转载)
  2. biweb后台添加上传下载功能
  3. HDU 5970 最大公约数
  4. 6. Adapter Class/Object(适配器)
  5. 如何引用jQuery实现下拉列表,点击展开,点击关闭。
  6. 水题 ZOJ 3875 Lunch Time
  7. java获取当前时间戳的方法
  8. Windows内核对象
  9. [原]Android开发环境搭建
  10. Objective-C之消息机制
  11. kali rolling 安装typecho
  12. oracle11实战详解
  13. 让sublime总是在新选项卡打开新文件
  14. HTML页面只能使用微信浏览器打开
  15. Lodop删除语句Deleted只能内嵌设计维护可用
  16. IIS 添加 MIME
  17. three.js 微信小游戏
  18. HZAU2018年十大阅读之星演讲稿
  19. tabel 选中行变色和取当前选中行值等问题
  20. 解决 div 设为 inline-block 后标题不对齐

热门文章

  1. How to make remote key fob for 2002 BMW 3 series
  2. 【阿里云产品公测】ACE安装Discuz超详细图文教程
  3. Oracle基础 游标
  4. CF Soldier and Badges (贪心)
  5. HDU 1087 Super Jumping! Jumping! Jumping! (DP)
  6. vagrant WARNING: You are not using an encrypted connection
  7. 【转】jmeter 进行java request测试
  8. 【CSS3】---练习制作导航菜单
  9. 正则表达式删除指定的HTML 标签
  10. 1 对WinMain的理解