oracle 11g RAC 常用命令

1.检查集群状态

[grid@rac1 ~]$ crsctl check clusterCRS-4537: Cluster Ready Services is onlineCRS-4529: Cluster Synchronization Services is onlineCRS-4533: Event Manager is online

2.检查所有实例状态

[grid@rac1 ~]$ srvctl status database -d orclInstance orcl1 is running on node rac1Instance orcl2 is running on node rac2

3.节点应用程序状态

[grid@rac1 ~]$ srvctl status nodeappsVIP rac1-vip is enabledVIP rac1-vip is running on node: rac1VIP rac2-vip is enabledVIP rac2-vip is running on node: rac2Network is enabledNetwork is running on node: rac1Network is running on node: rac2GSD is disabledGSD is not running on node: rac1GSD is not running on node: rac2ONS is enabledONS daemon is running on node: rac1ONS daemon is running on node: rac2

4.数据库配置

[grid@rac1 ~]$ srvctl config database -d orcl -aDatabase unique name: orclDatabase name: orclOracle home: /u01/app/oracle/product/11.2.0/db_1Oracle user: oracleSpfile: +DATADG/orcl/spfileorcl.oraDomain:Start options: openStop options: immediateDatabase role: PRIMARYManagement policy: AUTOMATICServer pools: orclDatabase instances: orcl1,orcl2Disk Groups: DATADG,SYSTEMDGMount point paths:Services:Type: RACDatabase is enabledDatabase is administrator managed

5.ASM状态及配置

[grid@rac1 ~]$ srvctl status asmASM is running on rac2,rac1

[grid@rac1 ~]$ srvctl config asm -aASM home: /u01/app/11.2.0/gridASM listener: LISTENERASM is enabled.

6.TNS监听状态及配置

[grid@rac1 ~]$ srvctl status listenerListener LISTENER is enabledListener LISTENER is running on node(s): rac2,rac1

[grid@rac1 ~]$ srvctl config listener -aName: LISTENERNetwork: 1, Owner: gridHome: <CRS home>  /u01/app/11.2.0/grid on node(s) rac1,rac2End points: TCP:1521

7.SCAN状态及配置

[grid@rac1 ~]$ srvctl status scanSCAN VIP scan1 is enabledSCAN VIP scan1 is running on node rac1

[grid@rac1 ~]$ srvctl config scanSCAN name: rac-cluster-scan, Network: 1/192.168.8.0/255.255.255.0/eth0SCAN VIP name: scan1, IP: /rac-cluster-scan/192.168.8.225

8.VIP各个节点的状态及配置

[grid@rac1 ~]$ srvctl status vip -n rac1VIP rac1-vip is enabledVIP rac1-vip is running on node: rac1[grid@rac1 ~]$ srvctl status vip -n rac2VIP rac2-vip is enabledVIP rac2-vip is running on node: rac2[grid@rac1 ~]$ srvctl config vip -n rac1VIP exists: /rac1-vip/192.168.8.222/192.168.8.0/255.255.255.0/eth0, hosting node rac1[grid@rac1 ~]$ srvctl config vip -n rac2VIP exists: /rac2-vip/192.168.8.224/192.168.8.0/255.255.255.0/eth0, hosting node rac2

10.验证所有集群节点间的时钟同步

[grid@rac1 ~]$ cluvfy comp clocksync -verboseVerifying Clock Synchronization across the cluster nodesChecking if Clusterware is installed on all nodes...Check of Clusterware install passedChecking if CTSS Resource is running on all nodes...Check: CTSS Resource running on all nodes  Node Name                             Status  ------------------------------------  ------------------------  rac1                                  passedResult: CTSS resource check passedQuerying CTSS for time offset on all nodes...Result: Query of CTSS for time offset passedCheck CTSS state started...Check: CTSS state  Node Name                             State  ------------------------------------  ------------------------  rac1                                  ActiveCTSS is in Active state. Proceeding with check of clock time offsets on all nodes...Reference Time Offset Limit: 1000.0 msecsCheck: Reference Time Offset  Node Name     Time Offset               Status  ------------  ------------------------  ------------------------  rac1          0.0                       passedTime offset is within the specified limits on the following set of nodes:"[rac1]"Result: Check of clock time offsets passedOracle Cluster Time Synchronization Services check passedVerification of Clock Synchronization across the cluster nodes was successful.