oracle 11g R2 RAC健康检查报告

oracle 11g R2 RAC健康检查

1.检查集群状态

[grid@rac1 ~]$ id

uid=501(grid) gid=501(oinstall) groups=501(oinstall),504(asmadmin),506(asmdba),507(asmoper)

[grid@rac1 ~]$ crsctl check cluster

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

[grid@rac1 ~]$

2.检查rac下实例的状态

[grid@rac1 ~]$ srvctl config database

1.检查集群状态

[grid@rac1 ~]$ id

uid=501(grid) gid=501(oinstall) groups=501(oinstall),504(asmadmin),506(asmdba),507(asmoper)

[grid@rac1 ~]$ crsctl check cluster

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

[grid@rac1 ~]$

2.检查rac下实例的状态

[grid@rac1 ~]$ srvctl config database

orcl

[grid@rac1 ~]$ srvctl status database -d orcl

Instance orcl1 is running on node rac1

Instance orcl2 is running on node rac2

[grid@rac1 ~]$

3.检查rac下某个实例状态

[grid@rac1 ~]$ srvctl status instance -d orcl -i orcl1

Instance orcl1 is running on node rac1

[grid@rac1 ~]$ srvctl status instance -d orcl -i orcl2

Instance orcl2 is running on node rac2

[grid@rac1 ~]$

4.检查rac各个节点应用程序状态（vip,network,gsd,ons,eons）

[grid@rac1 ~]$ srvctl status nodeapps

VIP rac1-vip is enabled

VIP rac1-vip is running on node: rac1

VIP rac2-vip is enabled

VIP rac2-vip is running on node: rac2

Network is enabled

Network is running on node: rac1

Network is running on node: rac2

GSD is enabled

GSD is running on node: rac1

GSD is running on node: rac2

ONS is enabled

ONS daemon is running on node: rac1

ONS daemon is running on node: rac2

eONS is enabled

eONS daemon is running on node: rac1

eONS daemon is running on node: rac2

[grid@rac1 ~]$

5.检查rac下的数据库配置

[grid@rac1 ~]$ srvctl config database -d orcl -a

Database unique name: orcl

Database name: orcl

Oracle home: /u01/app/oracle/product/11.2.0/db_1

Oracle user: oracle

Spfile: +DATA/orcl/

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: orcl

Database instances: orcl1,orcl2

Disk Groups: DATA,BACK

Services:

Database is enabled

Database is administrator managed

[grid@rac1 ~]$

6.检查rac下的ASM状态以及ASM配置

[grid@rac1 ~]$ srvctl status asm

ASM is running on rac1,rac2

[grid@rac1 ~]$ srvctl status asm -a

ASM is running on rac1,rac2

ASM is enabled.

[grid@rac1 ~]$ srvctl config asm -a

ASM home: /u01/app/grid/11.2.0/grid

ASM listener: LISTENER

ASM is enabled.

[grid@rac1 ~]$

7.检查rac下的TNS监听器状态以及配置

[grid@rac1 ~]$ srvctl status listener

Listener LISTENER is enabled

Listener LISTENER is running on node(s): rac1,rac2

[grid@rac1 ~]$ srvctl config listener -a