oracle rac集群 crs常用命令

1、oracle rac 集群 crs 常用命令常用的 crs 命令如下：$ORA_CRS_HOME/bin/crs_stat t crs 例如oraclerac2 css$ $ORA_CRS_HOME/bin/crs_stat -tName Type Target State Hostora.CL1.srv application ONLINE ONLINE rac1 ora.CL2.srv application ONLINE ONLINE rac2 ora.TEST.cs application ONLINE ONLINE rac1 ora.L1.inst application ONLIN

2、E ONLINE rac1 ora.L2.inst application ONLINE ONLINE rac2 ora.ORCL.db application ONLINE ONLINE rac1 ora.SM1.asm application ONLINE ONLINE rac1 ora.C1.lsnr application ONLINE ONLINE rac1 ora.rac1.gsd application ONLINE ONLINE rac1 ora.rac1.ons application ONLINE ONLINE rac1 ora.rac1.vip application O

3、NLINE ONLINE rac1 ora.SM2.asm application ONLINE ONLINE rac2 ora.C2.lsnr application ONLINE ONLINE rac2 ora.rac2.gsd application ONLINE ONLINE rac2 ora.rac2.ons application ONLINE ONLINE rac2 ora.rac2.vip application ONLINE ONLINE rac2 oraclerac2 css$ORA_CRS_HOME/bin/crs_start allState UNKNOWN。$ORA_

4、CRS_HOME/bin/crs_start 集群服务名（集群服务名可以通过$ORA_CRS_HOME/bin/crs_stat 得到）$ORA_CRS_HOME/bin/crs_stop -all$ORA_CRS_HOME/bin/crs_stop 集群服务名（集群服务名可以通过$ORA_CRS_HOME/bin/crs_stat 得到）crs crs 讲解这些命令的使用。举例如下：Oracle RAC RAC下面是系统自动启动以后的情况；oraclerac1 $ crs_stat -tName Type Target State Hostora.CL1.srv application ON

5、LINE UNKNOWN rac1ora.CL2.srv application ONLINE UNKNOWN rac2 ora.TEST.cs application ONLINE UNKNOWN rac2 ora.L1.inst application ONLINE OFFLINE ora.L2.inst application ONLINE OFFLINE ora.ORCL.db application ONLINE UNKNOWN rac1 ora.SM1.asm application ONLINE UNKNOWN rac1 ora.C1.lsnr application ONLIN

6、E UNKNOWN rac1 ora.rac1.gsd application ONLINE UNKNOWN rac1 ora.rac1.ons application ONLINE UNKNOWN rac1 ora.rac1.vip application ONLINE ONLINE rac1 ora.SM2.asm application ONLINE UNKNOWN rac2 ora.C2.lsnr application ONLINE UNKNOWN rac2 ora.rac2.gsd application ONLINE UNKNOWN rac2 ora.rac2.ons appli

7、cation ONLINE UNKNOWN rac2 ora.rac2.vip application ONLINE ONLINE rac2 oraclerac1 $vip UNKNOWN srvctl 启动试试！$ srvctl start nodeapps -n rac1CRS-1028: Dependency analysis failed because of:CRS-0223: Resource ora.rac1.gsd has placement CRS-1028: Dependency analysis failed because of:CRS-0223: Resource o

8、ra.rac1.vip has placement CRS-1028: Dependency analysis failed because of:CRS-0223: Resource ora.rac1.ons has placement CRS-1028: Dependency analysis failed because of:CRS-0223: Resource ora.rac1.LISTENER_RAC1.lsnr has placement error.测试 crs：$crsctl check crs CSS appears healthy CRS appears EVM appe

9、ars healthyoraclerac1 bin$ crsctl start resources Starting resources.Successfully started CRS resources oraclerac1 bin$ pwd/oracle/app/oracle/oracle/product/10.2.0/crs/bin oraclerac1 bin$ gsdctl stoporaclerac1 bin$ gsdctl status oraclerac1 bin$ ./gsdctl oraclerac1 bin$ gsdctl startoraclerac1 bin$ sr

10、vctl start nodeapps -n rac1 CRS-1028: Dependency analysis failed because of:CRS-0223: Resource ora.rac1.gsd has placement error. CRS-1028: Dependency analysis failed because of: CRS-0223: Resource ora.rac1.vip has placement error.CRS-1028: Dependency analysis failed because of:CRS-0223: Resource ora

11、.rac1.ons has placement CRS-1028: Dependency analysis failed because of:CRS-0223: Resource ora.rac1.LISTENER_RAC1.lsnr has placement error. oraclerac1 $ crs_stat -tName Type Target State Hostora.CL1.srv application ONLINE UNKNOWN rac1 ora.CL2.srv application ONLINE UNKNOWN rac2 ora.TEST.cs applicati

12、on ONLINE UNKNOWN rac2 ora.L1.inst application ONLINE OFFLINE ora.L2.inst application ONLINE OFFLINE ora.ORCL.db application ONLINE UNKNOWN rac1 ora.SM1.asm application ONLINE UNKNOWN rac1 ora.C1.lsnr application ONLINE UNKNOWN rac1 ora.rac1.gsd application ONLINE UNKNOWN rac1 ora.rac1.ons applicati

13、on ONLINE UNKNOWN rac1 ora.rac1.vip application ONLINE ONLINE rac1 ora.SM2.asm application ONLINE UNKNOWN rac2 ora.C2.lsnr application ONLINE UNKNOWN rac2 ora.rac2.gsd application ONLINE UNKNOWN rac2 ora.rac2.ons application ONLINE UNKNOWN rac2 ora.rac2.vip application ONLINE ONLINE rac2可以看到，仍然是启动后的

14、原始状态。State UNKNOWNcrs 在启动的时候无法认到系统已经注册的资源造成的。解决方法：首先，保证两个节点时间保持同步，ORACLE 10g RAC10down 机，或者节点不断重启。然后执行如下操作：oraclerac1 $ $ORA_CRS_HOME/bin/crs_stop Attempting to stop ora.rac1.vip on member rac1 Attempting to stop ora.rac2.vip on member rac2 Stop of ora.rac2.vip on member rac2 succeeded.Stop of ora.r

15、ac1.vip on member rac1 succeeded. oraclerac1 $ $ORA_CRS_HOME/bin/crs_stat -t Name Type Target State Hostora.CL1.srv application ONLINE UNKNOWN rac1 ora.CL2.srv application ONLINE UNKNOWN rac2 ora.TEST.cs application ONLINE UNKNOWN rac2 ora.L1.inst application OFFLINE OFFLINE ora.L2.inst application

16、OFFLINE OFFLINE ora.ORCL.db application OFFLINE UNKNOWN rac1ora.SM1.asm application OFFLINE UNKNOWN rac1 ora.C1.lsnr application OFFLINE UNKNOWN rac1 ora.rac1.gsd application ONLINE UNKNOWN rac1 ora.rac1.ons application ONLINE UNKNOWN rac1 ora.rac1.vip application OFFLINE OFFLINE ora.SM2.asm applica

17、tion OFFLINE UNKNOWN rac2 ora.C2.lsnr application OFFLINE UNKNOWN rac2 ora.rac2.gsd application ONLINE UNKNOWN rac2 ora.rac2.ons application ONLINE UNKNOWN rac2 ora.rac2.vip application OFFLINE OFFLINEoraclerac1 $ $ORA_CRS_HOME/bin/crs_stat （此命令可以查看各个资源的完整服务名称）NAME=ora.ORCL.ORATEST.ORCL1.srvTYPE=app

18、lication TARGET=OFFLINE STATE=OFFLINENAME=ora.ORCL.ORATEST.ORCL2.srvTYPE=application TARGET=OFFLINE STATE=OFFLINE NAME=ora.ORCL.ORATEST.csTYPE=application TARGET=ONLINE STATE=UNKNOWN on rac2 NAME=ora.ORCL.ORCL1.instTYPE=application TARGET=OFFLINE STATE=OFFLINE NAME=ora.ORCL.ORCL2.instTYPE=applicatio

19、n TARGET=OFFLINE STATE=OFFLINENAME=ora.ORCL.db TYPE=application TARGET=OFFLINE STATE=OFFLINENAME=ora.rac1.ASM1.asm TYPE=application TARGET=OFFLINE STATE=UNKNOWN on rac1NAME=ora.rac1.LISTENER_RAC1.lsnr TYPE=applicationTARGET=OFFLINE STATE=UNKNOWN on rac1NAME=ora.rac1.gsd TYPE=applicationTARGET=ONLINE

20、 STATE=UNKNOWN on NAME=ora.rac1.ons TYPE=application TARGET=ONLINE STATE=UNKNOWN on NAME=ora.rac1.vip TYPE=application TARGET=ONLINE STATE=UNKNOWN on NAME=ora.rac2.ASM2.asm TYPE=application TARGET=OFFLINE STATE=OFFLINENAME=ora.rac2.LISTENER_RAC2.lsnr TYPE=applicationTARGET=OFFLINE STATE=OFFLINENAME=

21、ora.rac2.gsd TYPE=application TARGET=ONLINE STATE=UNKNOWN on NAME=ora.rac2.ons TYPE=application TARGET=ONLINE STATE=UNKNOWN on NAME=ora.rac2.vip TYPE=application TARGET=OFFLINE STATE=OFFLINE$ORA_CRS_HOME/bin/crs_stop all State ONLINE UNKNOWN 的资源不能通过这个命令关闭，因此可以通过$ORA_CRS_HOME/bin/crs_stop UNKNOWN 资源。

22、下面是通过$ORA_CRS_HOME/bin/crs_stop State UNKNOWN 的服务。oraclerac1 $ $ORA_CRS_HOME/bin/crs_stop ora.ORCL.ORATEST.cs Attempting to stop ora.ORCL.ORATEST.cs on member rac2Stop of ora.ORCL.ORATEST.cs on member rac2 succeeded. oraclerac1 $ $ORA_CRS_HOME/bin/crs_stop ora.rac1.ASM1.asm Attempting to stop ora.ra

23、c1.ASM1.asm on member rac1Stop of ora.rac1.ASM1.asm on member rac1 succeeded.oraclerac1 $ $ORA_CRS_HOME/bin/crs_stop ora.rac1.LISTENER_RAC1.lsnr Attempting to stop ora.rac1.LISTENER_RAC1.lsnr on member rac1Stop of ora.rac1.LISTENER_RAC1.lsnr on member rac1 succeeded. oraclerac1 $ $ORA_CRS_HOME/bin/c

24、rs_stop ora.rac1.onsAttempting to stop ora.rac1.ons on member rac1 Stop of ora.rac1.ons on member rac1succeeded.oraclerac1 $ $ORA_CRS_HOME/bin/crs_stop Attempting to stop ora.rac1.vip on member rac1Stop of ora.rac1.vip on member rac1 succeeded. oraclerac1 $ $ORA_CRS_HOME/bin/crs_stop Attempting to s

25、top ora.rac2.gsd on member rac2Stop of ora.rac2.gsd on member rac2 succeeded. oraclerac1 $ $ORA_CRS_HOME/bin/crs_stop Attempting to stop ora.rac2.ons on member rac2Stop of ora.rac2.ons on member rac2 succeeded. oraclerac1 $ $ORA_CRS_HOME/bin/crs_stop Attempting to stop ora.rac1.gsd on member rac1Sto

26、p of ora.rac1.gsd on member rac1 succeeded.UNKNOWN oraclerac1 $ $ORA_CRS_HOME/bin/crs_stat -tName Type Target State Hostora.CL1.srv application OFFLINE OFFLINE ora.CL2.srv application OFFLINE OFFLINE ora.TEST.cs application OFFLINE OFFLINE ora.L1.inst application OFFLINE OFFLINE ora.L2.inst applicat

27、ion OFFLINE OFFLINE ora.ORCL.db application OFFLINE OFFLINE ora.SM1.asm application OFFLINE OFFLINE ora.C1.lsnr application OFFLINE OFFLINE ora.rac1.gsd application OFFLINE OFFLINE ora.rac1.ons application OFFLINE OFFLINE ora.rac1.vip application OFFLINE OFFLINE ora.SM2.asm application OFFLINE OFFLI

28、NE ora.C2.lsnr application OFFLINE OFFLINE ora.rac2.gsd application OFFLINE OFFLINE ora.rac2.ons application OFFLINE OFFLINE ora.rac2.vip application OFFLINE OFFLINE此时可以重启所有 crs 资源了oraclerac1 $ $ORA_CRS_HOME/bin/crs_startall（oracle 下操作）Attempting to start ora.rac1.vip on member rac1Attempting to sta

29、rt ora.rac2.vip on member rac2 Start of ora.rac2.vip on member rac2succeeded.Attempting to start ora.rac2.ASM2.asm on member Start of ora.rac1.vip on member rac1 succeeded.Attempting to start ora.rac1.ASM1.asm on member rac1 Start of ora.rac2.ASM2.asm on member rac2 succeeded. Attempting to start or

30、a.ORCL.ORCL2.inst on member rac2Start of ora.rac1.ASM1.asm on member rac1 succeeded. Attempting to start ora.ORCL.ORCL1.inst on member rac1 Start of ora.ORCL.ORCL2.inst on member rac2succeeded.Attempting to start ora.rac2.LISTENER_RAC2.lsnr on member rac2 Start of ora.rac2.LISTENER_RAC2.lsnr on memb

31、er rac2 succeeded. Start of ora.ORCL.ORCL1.inst on member rac1 succeeded.Attempting to start ora.rac1.LISTENER_RAC1.lsnr on member rac1 Start of ora.rac1.LISTENER_RAC1.lsnr on member rac1 succeeded. Attempting to start ora.ORCL.ORATEST.ORCL1.srv on member CRS-1002: Resource ora.rac1.ons is already r

32、unning on member rac1 CRS-1002: Resource ora.ORCL.db is already running on member rac1 CRS-1002: Resource ora.rac2.ons is already running on member rac2 Attempting to start ora.ORCL.ORATEST.ORCL2.srv on member Attempting to start ora.ORCL.ORATEST.cs on member rac2 Attempting to start ora.rac1.gsd on

33、 member rac1Attempting to start ora.rac2.gsd on member rac2Start of ora.ORCL.ORATEST.cs on member rac2 succeeded. Start of ora.rac2.gsd on member rac2 succeeded.Start of ora.ORCL.ORATEST.ORCL2.srv on member rac2 succeeded. Start of ora.rac1.gsd on member rac1 succeeded.Start of ora.ORCL.ORATEST.ORCL

34、1.srv on member rac1 succeeded. CRS-0223: Resource ora.ORCL.db has placement error.CRS-0223: Resource ora.rac1.ons has placement error. CRS-0223: Resource ora.rac2.ons has placement error. oraclerac1 $ crs_stat -tName Type Target State Hostora.CL1.srv application ONLINE ONLINE rac1 ora.CL2.srv appli

35、cation ONLINE ONLINE rac2 ora.TEST.cs application ONLINE ONLINE rac2 ora.L1.inst application ONLINE ONLINE rac1 ora.L2.inst application ONLINE ONLINE rac2 ora.ORCL.db application ONLINE ONLINE rac1 ora.SM1.asm application ONLINE ONLINE rac1 ora.C1.lsnr application ONLINE ONLINE rac1 ora.rac1.gsd app

36、lication ONLINE ONLINE rac1 ora.rac1.ons application ONLINE ONLINE rac1 ora.rac1.vip application ONLINE ONLINE rac1 ora.SM2.asm application ONLINE ONLINE rac2 ora.C2.lsnr application ONLINE ONLINE rac2 ora.rac2.gsd application ONLINE ONLINE rac2 ora.rac2.ons application ONLINE ONLINE rac2 ora.rac2.v

37、ip application ONLINE ONLINE rac2crs 其它一些常用命令：$ORA_CRS_HOME/bin/crsctl check crs 用于检查后台进程状态$ORA_CRS_HOME/bin/crsctl start resources 启动 crs 资源$ORA_CRS_HOME/bin/crsctl start crscrs，需要超级用户操作。$ORA_CRS_HOME/bin/crsctl stop crscrs，需要超级用户操作。$ORA_CRS_HOME/bin/crs_unregister 取消注册 crs$ORA_CRS_HOME/bin/ocrcheck 检查 ocr 设置信息用 ocrcheck$ORA_CRS_HOME/bin/crsctl query css votedisk 检查表决磁盘信息举例：oraclerac2 css$ ocrcheckStatus of Oracle Clust