Oracle 11g RAC 檢查各部分執行狀態

檢查RAC執行狀況

[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

檢查Database例項例狀態
[oracle@rac1 ~]$ srvctl status database -d prod 

Instance rac1 is running on node rac1 

Instance rac2 is running on node rac2

檢查節點應用狀態及配置
[oracle@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 disabled 

GSD is not running on node: rac1 

GSD is not 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 

[oracle@rac1 ~]$ srvctl config nodeapps -a -g -s -l

-l option has been deprecated and will be ignored.

VIP exists.:rac1 

VIP exists.: /rac1-vip/182.168.8.53/255.255.255.0/eth0 

VIP exists.:rac2 

VIP exists.: /rac2-vip/182.168.8.54/255.255.255.0/eth0 

GSD exists. 

ONS daemon exists. Local port 6100, remote port 6200 

Name: LISTENER Network: 1, Owner: grid 

Home: <CRS home> 

/u01/app/11.2.0/grid on node(s) rac2,rac1 

End points: TCP:1521

檢視資料庫配置
[oracle@rac1 ~]$ srvctl config database -d prod -a 

Database unique name: prod 

Database name: prod 

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

Oracle user: oracle

Spfile: +DATA/prod/spfileprod.ora 

Domain: 

Start options: open 

Stop options: immediate 

Database role: PRIMARY 

Management policy: AUTOMATIC 

Server pools: prod 

Database instances: prod1,prod2 

Disk Groups: DATA,FRA 

Services: 

Database is enabled 

Database is administrator managed

檢查 ASM狀態及配置
[oracle@rac1 ~]$ srvctl status asm 

ASM is running on rac1,rac2 

[oracle@rac1 ~]$ srvctl status asm 

ASM is running on rac1,rac2 

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

ASM home: /u01/app/11.2.0/grid 

ASM listener: LISTENER 

ASM is enabled.

檢查 TNS的狀態及配置
[oracle@rac1 ~]$ srvctl status listener 

Listener LISTENER is enabled 

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

[oracle@rac1 ~]$ srvctl status listener 

Listener LISTENER is enabled 

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

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

Name: LISTENER 

Network: 1, Owner: grid 

Home: <CRS home> 

/u01/app/11.2.0/grid on node(s) rac2,rac1 

End points: TCP:1521

檢查 SCAN 的狀態及配置
[oracle@rac1 ~]$ srvctl status scan 

SCAN VIP scan1 is enabled

SCAN VIP scan1 is running on node rac1 

[oracle@rac1 ~]$ srvctl config scan 

SCAN name: rac-scan, Network: 1/182.168.8.0/255.255.255.0/eth0 

SCAN VIP name: scan1, IP: /rac-scan.xl.com/182.168.8.55

檢查 VIP的狀態及配置
[oracle@rac1 ~]$ srvctl status vip -n rac1 

VIP rac1-vip is enabled 

VIP rac1-vip is running on node: rac1 

[oracle@rac1 ~]$ srvctl status vip -n rac2 

VIP rac2-vip is enabled 

VIP rac2-vip is running on node: rac2 

[oracle@rac1 ~]$ srvctl config vip -n rac1 

VIP exists.:rac1 

VIP exists.: /rac1-vip/182.168.8.53/255.255.255.0/eth0 

[oracle@rac1 ~]$ srvctl config vip -n rac2 

VIP exists.:rac2 

VIP exists.: /rac2-vip/182.168.8.54/255.255.255.0/eth0