Oracle RAC问题诊断

本文描述诊断RAC问题时一些有效的命令行和工具。

crsctl

除了其他功能之外，crsctl命令行可以检查集群的健康状况。以下命令显示了集群的顶层视图：

# cd /u01/app/11.2.0/grid/bin

# ./crsctl check cluster -all
**************************************************************
ol6-112-rac1:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
ol6-112-rac2:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************

以下命令显示了单个资源的信息：

# ./crsctl stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS      
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       ol6-112-rac1                                
               ONLINE  ONLINE       ol6-112-rac2                                
ora.LISTENER.lsnr
               ONLINE  ONLINE       ol6-112-rac1                                
               ONLINE  ONLINE       ol6-112-rac2                                
ora.asm
               ONLINE  ONLINE       ol6-112-rac1             Started            
               ONLINE  ONLINE       ol6-112-rac2             Started            
ora.gsd
               OFFLINE OFFLINE      ol6-112-rac1                                
               OFFLINE OFFLINE      ol6-112-rac2                                
ora.net1.network
               ONLINE  ONLINE       ol6-112-rac1                                
               ONLINE  ONLINE       ol6-112-rac2                                
ora.ons
               ONLINE  ONLINE       ol6-112-rac1                                
               ONLINE  ONLINE       ol6-112-rac2                                
ora.registry.acfs
               ONLINE  ONLINE       ol6-112-rac1                                
               ONLINE  ONLINE       ol6-112-rac2                                
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       ol6-112-rac1                                
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       ol6-112-rac2                                
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       ol6-112-rac2                                
ora.cvu
      1        ONLINE  ONLINE       ol6-112-rac2                                
ora.oc4j
      1        ONLINE  ONLINE       ol6-112-rac2                                
ora.ol6-112-rac1.vip
      1        ONLINE  ONLINE       ol6-112-rac1                                
ora.ol6-112-rac2.vip
      1        ONLINE  ONLINE       ol6-112-rac2                                
ora.rac.db
      1        ONLINE  ONLINE       ol6-112-rac1             Open               
      2        ONLINE  ONLINE       ol6-112-rac2             Open               
ora.scan1.vip
      1        ONLINE  ONLINE       ol6-112-rac1                                
ora.scan2.vip
      1        ONLINE  ONLINE       ol6-112-rac2                                
ora.scan3.vip
      1        ONLINE  ONLINE       ol6-112-rac2                                

olsnodes

在所有集群节点运行olsnodes命令，可以看到每次都返回了一个包含全部节点的列表：

# cd /u01/app/11.2.0/grid/bin

# ./olsnodes
ol6-112-rac1
ol6-112-rac2

cluvfy

你可能已经在安装集群软件之前运行了runcluvfy.sh工具。在安装完Oracle软件后，可以使用cluvfy命令获得有用的安装后信息。使用“-help”查看使用信息：

$ cluvfy stage -help

USAGE:
cluvfy stage {-pre|-post}    [-verbose]

SYNTAX (for Stages):
cluvfy stage -pre cfs -n  -s  [-verbose]
cluvfy stage -pre
                   crsinst -file  [-fixup [-fixupdir ]] [-verbose]
                   crsinst -upgrade [-n ] [-rolling] -src_crshome  -dest_crshome
                           -dest_version  [-fixup [-fixupdir ]] [-verbose]
                   crsinst -n  [-r {10gR1|10gR2|11gR1|11gR2}]
                           [-c ] [-q ]
                           [-osdba ] [-orainv ]
                           [-asm [-asmgrp ] [-asmdev ]] [-crshome ]
                           [-fixup [-fixupdir ]] [-networks ]
                           [-verbose]
cluvfy stage -pre acfscfg -n  [-asmdev ] [-verbose]
cluvfy stage -pre
                   dbinst -n  [-r {10gR1|10gR2|11gR1|11gR2}] [-osdba ] [-d ]
                          [-fixup [-fixupdir ]] [-verbose]
                   dbinst -upgrade -src_dbhome  [-dbname ] -dest_dbhome  -dest_version
                          [-fixup [-fixupdir ]] [-verbose]
cluvfy stage -pre dbcfg -n  -d  [-fixup [-fixupdir ]] [-verbose]
cluvfy stage -pre hacfg [-osdba ] [-orainv ] [-fixup [-fixupdir ]] [-verbose]
cluvfy stage -pre nodeadd -n  [-vip ] [-fixup [-fixupdir ]] [-verbose]
cluvfy stage -post hwos -n  [-s ] [-verbose]
cluvfy stage -post cfs -n  -f  [-verbose]
cluvfy stage -post crsinst -n  [-verbose]
cluvfy stage -post acfscfg -n  [-verbose]
cluvfy stage -post hacfg [-verbose]
cluvfy stage -post nodeadd -n  [-verbose]
cluvfy stage -post nodedel -n  [-verbose]

以下显示了2个示例：

$ cluvfy stage -post crsinst -n ol6-112-rac1,ol6-112-rac2
$ cluvfy stage -pre dbcfg -n ol6-112-rac1,ol6-112-rac2 -d /u01/app/oracle/product/11.2.0/db_1

检查输出，并修改出现的错误。

RACcheck

Oracle提供了RACcheck工具（MOS [ID 1268927.1]）审核RAC、CRS、ASM以及GI等的配置。它支持的数据库版本包括10.2-11.2，可以作为一个非常有用的分析起点。MOS注释包含了下载和安装信息。

$ unzip raccheck.zip
$ cd rachcheck
$ chmod 755 raccheck
$ ./raccheck -a

CRS stack is running and CRS_HOME is not set. Do you want to set CRS_HOME to /u01/app/11.2.0/grid?[y/n][y]

Checking ssh user equivalency settings on all nodes in cluster

Node ol6-112-rac2 is configured for ssh user equivalency for oracle user
 

Searching for running databases . . . . .

.
List of running databases registered in OCR
1. RAC
2. None

Select databases from list for checking best practices. For multiple databases, select 1 for All or comma separated number like 1,2 etc [1-2][1].
. .


Checking Status of Oracle Software Stack - Clusterware, ASM, RDBMS

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
-------------------------------------------------------------------------------------------------------
                                                 Oracle Stack Status                            
-------------------------------------------------------------------------------------------------------
Host Name  CRS Installed  ASM HOME       RDBMS Installed  CRS UP    ASM UP    RDBMS UP  DB Instance Name
-------------------------------------------------------------------------------------------------------
ol6-112-rac1 Yes             Yes             Yes             Yes        Yes      Yes      RAC1      
ol6-112-rac2 Yes             Yes             Yes             Yes        Yes      Yes      RAC2      
-------------------------------------------------------------------------------------------------------
.
.

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

转载于:http://blog.itpub.net/24945919/viewspace-762620/