【kingsql分享】RAC節點命令
[root@rac1 ~]# /u01/app/11.2.3/grid/bin/crsctl stop cluster -all
[root@rac1 ~]# /u01/app/11.2.3/grid/bin/crsctl start cluster -all
[grid@rac1 ~]$ crs_stop -all
[grid@rac1 ~]$ crs_start -all
//後來就壞了,重啟作業系統之後部分能起來,部分起不來,rac2就全都起不來
執行下面的命令刷了一遍
[root@rac1 ~]# /u01/app/11.2.3/grid/bin/crsctl stop cluster -all
[root@rac1 ~]# /u01/app/11.2.3/grid/bin/crsctl start cluster -all
rac1,rac2,rac3只有叢集的服務起來了,但是vip,listener,db等服務都沒有起來
註釋:
有的時候,叢集服務起來了,但是vip和監聽和db沒有起來,這個時候執行[grid@rac1 ~]$ crs_start -all
[root@rac1 ~]# /u01/app/11.2.3/grid/bin/crsctl start cluster -all
[grid@rac1 ~]$ crs_stop -all
[grid@rac1 ~]$ crs_start -all
[root@rac1 ~]# /u01/app/11.2.3/grid/bin/crsctl stop cluster -all CRS-2673: Attempting to stop 'ora.crsd' on 'rac1' CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac1' CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac1' CRS-2673: Attempting to stop 'ora.CRS.dg' on 'rac1' CRS-2673: Attempting to stop 'ora.kingsql.db' on 'rac1' CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.rac1.vip' on 'rac1' CRS-2677: Stop of 'ora.rac1.vip' on 'rac1' succeeded CRS-2677: Stop of 'ora.kingsql.db' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac1' CRS-2673: Attempting to stop 'ora.crsd' on 'rac3' CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac3' CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac3' CRS-2673: Attempting to stop 'ora.cvu' on 'rac3' CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac3' CRS-2673: Attempting to stop 'ora.CRS.dg' on 'rac3' CRS-2673: Attempting to stop 'ora.kingsql.db' on 'rac3' CRS-2673: Attempting to stop 'ora.oc4j' on 'rac3' CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rac3' succeeded CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac3' CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac3' succeeded CRS-2673: Attempting to stop 'ora.rac3.vip' on 'rac3' CRS-2677: Stop of 'ora.cvu' on 'rac3' succeeded CRS-2677: Stop of 'ora.rac3.vip' on 'rac3' succeeded CRS-2677: Stop of 'ora.scan1.vip' on 'rac3' succeeded CRS-2677: Stop of 'ora.DATA.dg' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.crsd' on 'rac2' CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac2' CRS-2673: Attempting to stop 'ora.CRS.dg' on 'rac2' CRS-2673: Attempting to stop 'ora.kingsql.db' on 'rac2' CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac2' CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.rac2.vip' on 'rac2' CRS-2677: Stop of 'ora.rac2.vip' on 'rac2' succeeded CRS-2677: Stop of 'ora.kingsql.db' on 'rac3' succeeded CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac3' CRS-2677: Stop of 'ora.kingsql.db' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac2' CRS-2677: Stop of 'ora.DATA.dg' on 'rac2' succeeded CRS-2677: Stop of 'ora.DATA.dg' on 'rac3' succeeded CRS-2677: Stop of 'ora.oc4j' on 'rac3' succeeded CRS-2677: Stop of 'ora.CRS.dg' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'rac1' CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded CRS-2677: Stop of 'ora.CRS.dg' on 'rac3' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'rac3' CRS-2677: Stop of 'ora.asm' on 'rac3' succeeded CRS-2673: Attempting to stop 'ora.ons' on 'rac3' CRS-2677: Stop of 'ora.ons' on 'rac3' succeeded CRS-2673: Attempting to stop 'ora.net1.network' on 'rac3' CRS-2677: Stop of 'ora.net1.network' on 'rac3' succeeded CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac3' has completed CRS-2677: Stop of 'ora.CRS.dg' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'rac2' CRS-2677: Stop of 'ora.crsd' on 'rac3' succeeded CRS-2673: Attempting to stop 'ora.ctssd' on 'rac3' CRS-2673: Attempting to stop 'ora.evmd' on 'rac3' CRS-2673: Attempting to stop 'ora.asm' on 'rac3' CRS-2677: Stop of 'ora.asm' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.ons' on 'rac2' CRS-2677: Stop of 'ora.evmd' on 'rac3' succeeded CRS-2677: Stop of 'ora.ons' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.net1.network' on 'rac2' CRS-2677: Stop of 'ora.net1.network' on 'rac2' succeeded CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac2' has completed CRS-2673: Attempting to stop 'ora.ons' on 'rac1' CRS-2677: Stop of 'ora.ons' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.net1.network' on 'rac1' CRS-2677: Stop of 'ora.net1.network' on 'rac1' succeeded CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac1' has completed CRS-2677: Stop of 'ora.ctssd' on 'rac3' succeeded CRS-2677: Stop of 'ora.crsd' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.ctssd' on 'rac2' CRS-2673: Attempting to stop 'ora.evmd' on 'rac2' CRS-2673: Attempting to stop 'ora.asm' on 'rac2' CRS-2677: Stop of 'ora.crsd' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.ctssd' on 'rac1' CRS-2673: Attempting to stop 'ora.evmd' on 'rac1' CRS-2673: Attempting to stop 'ora.asm' on 'rac1' CRS-2677: Stop of 'ora.evmd' on 'rac2' succeeded CRS-2677: Stop of 'ora.evmd' on 'rac1' succeeded CRS-2677: Stop of 'ora.asm' on 'rac3' succeeded CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac3' CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac3' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'rac3' CRS-2677: Stop of 'ora.cssd' on 'rac3' succeeded CRS-2677: Stop of 'ora.ctssd' on 'rac2' succeeded CRS-2677: Stop of 'ora.asm' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac2' CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeeded CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac1' CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac2' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'rac2' CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'rac1' CRS-2677: Stop of 'ora.cssd' on 'rac2' succeeded CRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded |
[root@rac1 ~]# /u01/app/11.2.3/grid/bin/crsctl start cluster -all CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac2' CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac3' CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac1' CRS-2676: Start of 'ora.cssdmonitor' on 'rac2' succeeded CRS-2672: Attempting to start 'ora.cssd' on 'rac2' CRS-2672: Attempting to start 'ora.diskmon' on 'rac2' CRS-2676: Start of 'ora.diskmon' on 'rac2' succeeded CRS-2676: Start of 'ora.cssdmonitor' on 'rac3' succeeded CRS-2672: Attempting to start 'ora.cssd' on 'rac3' CRS-2672: Attempting to start 'ora.diskmon' on 'rac3' CRS-2676: Start of 'ora.diskmon' on 'rac3' succeeded CRS-2676: Start of 'ora.cssdmonitor' on 'rac1' succeeded CRS-2672: Attempting to start 'ora.cssd' on 'rac1' CRS-2672: Attempting to start 'ora.diskmon' on 'rac1' CRS-2676: Start of 'ora.diskmon' on 'rac1' succeeded CRS-2676: Start of 'ora.cssd' on 'rac3' succeeded CRS-2672: Attempting to start 'ora.ctssd' on 'rac3' CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'rac3' CRS-2676: Start of 'ora.cssd' on 'rac1' succeeded CRS-2672: Attempting to start 'ora.ctssd' on 'rac1' CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'rac1' CRS-2676: Start of 'ora.cssd' on 'rac2' succeeded CRS-2672: Attempting to start 'ora.ctssd' on 'rac2' CRS-2676: Start of 'ora.ctssd' on 'rac3' succeeded CRS-2672: Attempting to start 'ora.evmd' on 'rac3' CRS-2676: Start of 'ora.ctssd' on 'rac1' succeeded CRS-2672: Attempting to start 'ora.evmd' on 'rac1' CRS-2676: Start of 'ora.ctssd' on 'rac2' succeeded CRS-2672: Attempting to start 'ora.evmd' on 'rac2' CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'rac2' CRS-2676: Start of 'ora.evmd' on 'rac3' succeeded CRS-2676: Start of 'ora.evmd' on 'rac1' succeeded CRS-2676: Start of 'ora.evmd' on 'rac2' succeeded CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'rac1' succeeded CRS-2672: Attempting to start 'ora.asm' on 'rac1' CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'rac2' succeeded CRS-2672: Attempting to start 'ora.asm' on 'rac2' CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'rac3' succeeded CRS-2672: Attempting to start 'ora.asm' on 'rac3' CRS-2676: Start of 'ora.asm' on 'rac2' succeeded CRS-2672: Attempting to start 'ora.crsd' on 'rac2' CRS-2676: Start of 'ora.crsd' on 'rac2' succeeded CRS-2676: Start of 'ora.asm' on 'rac3' succeeded CRS-2672: Attempting to start 'ora.crsd' on 'rac3' CRS-2676: Start of 'ora.asm' on 'rac1' succeeded CRS-2672: Attempting to start 'ora.crsd' on 'rac1' CRS-2676: Start of 'ora.crsd' on 'rac3' succeeded CRS-2676: Start of 'ora.crsd' on 'rac1' succeeded |
[grid@rac1 ~]$ crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora.CRS.dg ora....up.type ONLINE ONLINE rac1 ora.DATA.dg ora....up.type ONLINE ONLINE rac1 ora....ER.lsnr ora....er.type ONLINE ONLINE rac1 ora....N1.lsnr ora....er.type ONLINE ONLINE rac1 ora.asm ora.asm.type ONLINE ONLINE rac1 ora.cvu ora.cvu.type ONLINE ONLINE rac1 ora.gsd ora.gsd.type OFFLINE OFFLINE ora.kingsql.db ora....se.type ONLINE ONLINE rac3 ora....network ora....rk.type ONLINE ONLINE rac1 ora.oc4j ora.oc4j.type ONLINE ONLINE rac1 ora.ons ora.ons.type ONLINE ONLINE rac1 ora....SM1.asm application ONLINE ONLINE rac1 ora....C1.lsnr application ONLINE ONLINE rac1 ora.rac1.gsd application OFFLINE OFFLINE ora.rac1.ons application ONLINE ONLINE rac1 ora.rac1.vip ora....t1.type ONLINE ONLINE rac1 ora....SM2.asm application ONLINE ONLINE rac2 ora....C2.lsnr application ONLINE ONLINE rac2 ora.rac2.gsd application OFFLINE OFFLINE ora.rac2.ons application ONLINE ONLINE rac2 ora.rac2.vip ora....t1.type ONLINE ONLINE rac2 ora....SM3.asm application ONLINE ONLINE rac3 ora....C3.lsnr application ONLINE ONLINE rac3 ora.rac3.gsd application OFFLINE OFFLINE ora.rac3.ons application ONLINE ONLINE rac3 ora.rac3.vip ora....t1.type ONLINE ONLINE rac3 ora.scan1.vip ora....ip.type ONLINE ONLINE rac1 |
[grid@rac1 ~]$ crsctl status res -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.CRS.dg ONLINE ONLINE rac1 ONLINE ONLINE rac2 ONLINE ONLINE rac3 ora.DATA.dg ONLINE ONLINE rac1 ONLINE ONLINE rac2 ONLINE ONLINE rac3 ora.LISTENER.lsnr ONLINE ONLINE rac1 ONLINE ONLINE rac2 ONLINE ONLINE rac3 ora.asm ONLINE ONLINE rac1 Started ONLINE ONLINE rac2 Started ONLINE ONLINE rac3 Started ora.gsd OFFLINE OFFLINE rac1 OFFLINE OFFLINE rac2 OFFLINE OFFLINE rac3 ora.net1.network ONLINE ONLINE rac1 ONLINE ONLINE rac2 ONLINE ONLINE rac3 ora.ons ONLINE ONLINE rac1 ONLINE ONLINE rac2 ONLINE ONLINE rac3 -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE rac1 ora.cvu 1 ONLINE ONLINE rac1 ora.kingsql.db 1 ONLINE ONLINE rac3 Open 2 ONLINE ONLINE rac2 Open 3 ONLINE ONLINE rac1 Open ora.oc4j 1 ONLINE ONLINE rac1 ora.rac1.vip 1 ONLINE ONLINE rac1 ora.rac2.vip 1 ONLINE ONLINE rac2 ora.rac3.vip 1 ONLINE ONLINE rac3 ora.scan1.vip 1 ONLINE ONLINE rac1 |
[grid@rac1 ~]$ crs_stop -all CRS-2500: Cannot stop resource 'ora.gsd' as it is not running CRS-2789: Cannot stop resource 'ora.gsd' as it is not running on server 'rac2' Attempting to stop `ora.ons` on member `rac2` Attempting to stop `ora.LISTENER.lsnr` on member `rac2` Attempting to stop `ora.ons` on member `rac3` Attempting to stop `ora.LISTENER.lsnr` on member `rac3` Attempting to stop `ora.CRS.dg` on member `rac1` Attempting to stop `ora.DATA.dg` on member `rac1` Attempting to stop `ora.kingsql.db` on member `rac1` Attempting to stop `ora.CRS.dg` on member `rac2` Attempting to stop `ora.DATA.dg` on member `rac2` Attempting to stop `ora.kingsql.db` on member `rac2` Attempting to stop `ora.CRS.dg` on member `rac3` Attempting to stop `ora.DATA.dg` on member `rac3` Attempting to stop `ora.kingsql.db` on member `rac3` CRS-2789: Cannot stop resource 'ora.gsd' as it is not running on server 'rac1' Attempting to stop `ora.cvu` on member `rac1` Attempting to stop `ora.ons` on member `rac1` Attempting to stop `ora.LISTENER.lsnr` on member `rac1` Attempting to stop `ora.LISTENER_SCAN1.lsnr` on member `rac1` CRS-2789: Cannot stop resource 'ora.gsd' as it is not running on server 'rac3' Attempting to stop `ora.oc4j` on member `rac1` Stop of `ora.ons` on member `rac3` succeeded. CRS-2789: Cannot stop resource 'ora.ons' as it is not running on server 'rac3' Stop of `ora.LISTENER.lsnr` on member `rac3` succeeded. Attempting to stop `ora.rac3.vip` on member `rac3` CRS-2789: Cannot stop resource 'ora.LISTENER.lsnr' as it is not running on server 'rac3' Stop of `ora.LISTENER.lsnr` on member `rac2` succeeded. Attempting to stop `ora.rac2.vip` on member `rac2` CRS-2789: Cannot stop resource 'ora.LISTENER.lsnr' as it is not running on server 'rac2' Stop of `ora.cvu` on member `rac1` succeeded. Stop of `ora.rac3.vip` on member `rac3` succeeded. Attempting to stop `ora.net1.network` on member `rac3` Stop of `ora.rac2.vip` on member `rac2` succeeded. Stop of `ora.LISTENER.lsnr` on member `rac1` succeeded. Attempting to stop `ora.rac1.vip` on member `rac1` CRS-2789: Cannot stop resource 'ora.LISTENER.lsnr' as it is not running on server 'rac1' Stop of `ora.LISTENER_SCAN1.lsnr` on member `rac1` succeeded. Attempting to stop `ora.scan1.vip` on member `rac1` Stop of `ora.net1.network` on member `rac3` succeeded. Stop of `ora.ons` on member `rac2` succeeded. Attempting to stop `ora.net1.network` on member `rac2` CRS-2789: Cannot stop resource 'ora.ons' as it is not running on server 'rac2' Stop of `ora.net1.network` on member `rac2` succeeded. Stop of `ora.rac1.vip` on member `rac1` succeeded. Stop of `ora.scan1.vip` on member `rac1` succeeded. Stop of `ora.ons` on member `rac1` succeeded. Attempting to stop `ora.net1.network` on member `rac1` CRS-2789: Cannot stop resource 'ora.ons' as it is not running on server 'rac1' Stop of `ora.net1.network` on member `rac1` succeeded. Stop of `ora.oc4j` on member `rac1` succeeded. Stop of `ora.kingsql.db` on member `rac3` succeeded. Stop of `ora.DATA.dg` on member `rac2` succeeded. Stop of `ora.DATA.dg` on member `rac3` succeeded. Stop of `ora.DATA.dg` on member `rac1` succeeded. Stop of `ora.kingsql.db` on member `rac1` succeeded. Stop of `ora.kingsql.db` on member `rac2` succeeded. Stop of `ora.CRS.dg` on member `rac2` succeeded. Attempting to stop `ora.asm` on member `rac2` Stop of `ora.CRS.dg` on member `rac3` succeeded. Attempting to stop `ora.asm` on member `rac3` Stop of `ora.CRS.dg` on member `rac1` succeeded. Attempting to stop `ora.asm` on member `rac1` //卡在這裡很久很久不能釋懷的感覺 |
//後來就壞了,重啟作業系統之後部分能起來,部分起不來,rac2就全都起不來
執行下面的命令刷了一遍
[root@rac1 ~]# /u01/app/11.2.3/grid/bin/crsctl stop cluster -all
[root@rac1 ~]# /u01/app/11.2.3/grid/bin/crsctl start cluster -all
rac1,rac2,rac3只有叢集的服務起來了,但是vip,listener,db等服務都沒有起來
註釋:
有的時候,叢集服務起來了,但是vip和監聽和db沒有起來,這個時候執行[grid@rac1 ~]$ crs_start -all
[grid@rac1 ~]$ crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora.CRS.dg ora....up.type ONLINE ONLINE rac1 ora.DATA.dg ora....up.type ONLINE ONLINE rac1 ora....ER.lsnr ora....er.type OFFLINE OFFLINE ora....N1.lsnr ora....er.type OFFLINE OFFLINE ora.asm ora.asm.type ONLINE ONLINE rac1 ora.cvu ora.cvu.type OFFLINE OFFLINE ora.gsd ora.gsd.type OFFLINE OFFLINE ora.kingsql.db ora....se.type OFFLINE OFFLINE ora....network ora....rk.type ONLINE ONLINE rac1 ora.oc4j ora.oc4j.type OFFLINE OFFLINE ora.ons ora.ons.type ONLINE ONLINE rac1 ora....SM1.asm application ONLINE ONLINE rac1 ora....C1.lsnr application OFFLINE OFFLINE ora.rac1.gsd application OFFLINE OFFLINE ora.rac1.ons application ONLINE ONLINE rac1 ora.rac1.vip ora....t1.type OFFLINE OFFLINE ora....SM2.asm application ONLINE ONLINE rac2 ora....C2.lsnr application OFFLINE OFFLINE ora.rac2.gsd application OFFLINE OFFLINE ora.rac2.ons application ONLINE ONLINE rac2 ora.rac2.vip ora....t1.type OFFLINE OFFLINE ora....SM3.asm application ONLINE ONLINE rac3 ora....C3.lsnr application OFFLINE OFFLINE ora.rac3.gsd application OFFLINE OFFLINE ora.rac3.ons application ONLINE ONLINE rac3 ora.rac3.vip ora....t1.type OFFLINE OFFLINE ora.scan1.vip ora....ip.type OFFLINE OFFLINE |
[grid@rac1 ~]$ crs_start -all CRS-5702: Resource 'ora.CRS.dg' is already running on 'rac1' CRS-5702: Resource 'ora.DATA.dg' is already running on 'rac1' CRS-5702: Resource 'ora.asm' is already running on 'rac1' CRS-2501: Resource 'ora.gsd' is disabled CRS-5702: Resource 'ora.net1.network' is already running on 'rac1' CRS-5702: Resource 'ora.ons' is already running on 'rac1' CRS-5702: Resource 'ora.asm' is already running on 'rac1' CRS-2501: Resource 'ora.gsd' is disabled CRS-5702: Resource 'ora.ons' is already running on 'rac1' CRS-5702: Resource 'ora.asm' is already running on 'rac2' CRS-2501: Resource 'ora.gsd' is disabled CRS-5702: Resource 'ora.ons' is already running on 'rac2' CRS-5702: Resource 'ora.asm' is already running on 'rac3' CRS-2501: Resource 'ora.gsd' is disabled CRS-5702: Resource 'ora.ons' is already running on 'rac3' Attempting to start `ora.oc4j` on member `rac1` Attempting to start `ora.rac2.vip` on member `rac2` Attempting to start `ora.rac1.vip` on member `rac1` Attempting to start `ora.cvu` on member `rac2` Start of `ora.cvu` on member `rac2` succeeded. Start of `ora.rac1.vip` on member `rac1` succeeded. Attempting to start `ora.LISTENER.lsnr` on member `rac1` Start of `ora.rac2.vip` on member `rac2` succeeded. Attempting to start `ora.LISTENER.lsnr` on member `rac2` Start of `ora.LISTENER.lsnr` on member `rac2` succeeded. Attempting to start `ora.scan1.vip` on member `rac1` Start of `ora.LISTENER.lsnr` on member `rac1` succeeded. Start of `ora.scan1.vip` on member `rac1` succeeded. Attempting to start `ora.LISTENER_SCAN1.lsnr` on member `rac1` Start of `ora.LISTENER_SCAN1.lsnr` on member `rac1` succeeded. Attempting to start `ora.kingsql.db` on member `rac2` Start of `ora.oc4j` on member `rac1` succeeded. Start of `ora.kingsql.db` on member `rac2` succeeded. Attempting to start `ora.rac3.vip` on member `rac3` Attempting to start `ora.kingsql.db` on member `rac1` Start of `ora.rac3.vip` on member `rac3` succeeded. Attempting to start `ora.LISTENER.lsnr` on member `rac3` Start of `ora.LISTENER.lsnr` on member `rac3` succeeded. Attempting to start `ora.kingsql.db` on member `rac3` Start of `ora.kingsql.db` on member `rac1` succeeded. Start of `ora.kingsql.db` on member `rac3` succeeded. CRS-0223: Resource 'ora.CRS.dg' has placement error. CRS-0223: Resource 'ora.DATA.dg' has placement error. CRS-0223: Resource 'ora.asm' has placement error. CRS-2660: Resource 'ora.gsd' or all of its instances are disabled CRS-0223: Resource 'ora.net1.network' has placement error. CRS-0223: Resource 'ora.ons' has placement error. CRS-0223: Resource 'ora.rac1.ASM1.asm' has placement error. CRS-2660: Resource 'ora.rac1.gsd' or all of its instances are disabled CRS-0223: Resource 'ora.rac1.ons' has placement error. CRS-0223: Resource 'ora.rac2.ASM2.asm' has placement error. CRS-2660: Resource 'ora.rac2.gsd' or all of its instances are disabled CRS-0223: Resource 'ora.rac2.ons' has placement error. CRS-0223: Resource 'ora.rac3.ASM3.asm' has placement error. CRS-2660: Resource 'ora.rac3.gsd' or all of its instances are disabled CRS-0223: Resource 'ora.rac3.ons' has placement error. |
[grid@rac1 ~]$ crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora.CRS.dg ora....up.type ONLINE ONLINE rac1 ora.DATA.dg ora....up.type ONLINE ONLINE rac1 ora....ER.lsnr ora....er.type ONLINE ONLINE rac1 ora....N1.lsnr ora....er.type ONLINE ONLINE rac1 ora.asm ora.asm.type ONLINE ONLINE rac1 ora.cvu ora.cvu.type ONLINE ONLINE rac2 ora.gsd ora.gsd.type OFFLINE OFFLINE ora.kingsql.db ora....se.type ONLINE ONLINE rac1 ora....network ora....rk.type ONLINE ONLINE rac1 ora.oc4j ora.oc4j.type ONLINE ONLINE rac1 ora.ons ora.ons.type ONLINE ONLINE rac1 ora....SM1.asm application ONLINE ONLINE rac1 ora....C1.lsnr application ONLINE ONLINE rac1 ora.rac1.gsd application OFFLINE OFFLINE ora.rac1.ons application ONLINE ONLINE rac1 ora.rac1.vip ora....t1.type ONLINE ONLINE rac1 ora....SM2.asm application ONLINE ONLINE rac2 ora....C2.lsnr application ONLINE ONLINE rac2 ora.rac2.gsd application OFFLINE OFFLINE ora.rac2.ons application ONLINE ONLINE rac2 ora.rac2.vip ora....t1.type ONLINE ONLINE rac2 ora....SM3.asm application ONLINE ONLINE rac3 ora....C3.lsnr application ONLINE ONLINE rac3 ora.rac3.gsd application OFFLINE OFFLINE ora.rac3.ons application ONLINE ONLINE rac3 ora.rac3.vip ora....t1.type ONLINE ONLINE rac3 ora.scan1.vip ora....ip.type ONLINE ONLINE rac1 |
[grid@rac1 ~]$ crsctl status res -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.CRS.dg ONLINE ONLINE rac1 ONLINE ONLINE rac2 ONLINE ONLINE rac3 ora.DATA.dg ONLINE ONLINE rac1 ONLINE ONLINE rac2 ONLINE ONLINE rac3 ora.LISTENER.lsnr ONLINE ONLINE rac1 ONLINE ONLINE rac2 ONLINE ONLINE rac3 ora.asm ONLINE ONLINE rac1 Started ONLINE ONLINE rac2 Started ONLINE ONLINE rac3 Started ora.gsd OFFLINE OFFLINE rac1 OFFLINE OFFLINE rac2 OFFLINE OFFLINE rac3 ora.net1.network ONLINE ONLINE rac1 ONLINE ONLINE rac2 ONLINE ONLINE rac3 ora.ons ONLINE ONLINE rac1 ONLINE ONLINE rac2 ONLINE ONLINE rac3 -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE rac1 ora.cvu 1 ONLINE ONLINE rac2 ora.kingsql.db 1 ONLINE ONLINE rac1 Open 2 ONLINE ONLINE rac2 Open 3 ONLINE ONLINE rac3 Open ora.oc4j 1 ONLINE ONLINE rac1 ora.rac1.vip 1 ONLINE ONLINE rac1 ora.rac2.vip 1 ONLINE ONLINE rac2 ora.rac3.vip 1 ONLINE ONLINE rac3 ora.scan1.vip 1 ONLINE ONLINE rac1 |
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28389881/viewspace-2109692/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【kingsql分享】RAC11G 新增節點SQL
- 【kingsql分享】RAC節點故障修復一例SQL
- 【kingsql分享】RAC11G 恢復OCRSQL
- 【RAC】Oracle10g rac新增刪除節點命令參考Oracle
- 【kingsql分享】RAC擴大online日誌組大小SQL
- RAC 雙節點 轉單節點流程
- Oracle RAC新增節點Oracle
- Oracle RAC 新增節點Oracle
- 【kingsql分享】Oracle 18c RAC補丁升級實戰【DBRU】SQLOracle
- RAC節點之間通訊問題 兩節點 11g RAC
- 2節點RAC安裝
- Oracle Rac 刪除節點Oracle
- 【kingsql分享】將RAC資料庫異機恢復到單例項(Ⅰ)SQL資料庫單例
- [網摘] Oracle RAC新增節點Oracle
- 檢視oracle rac的節點Oracle
- RAC中跨節點並行並行
- 【kingsql分享】表空間加密SQL加密
- 【RAC】Oracle10g RAC 節點重配的方式Oracle
- oracle 11g rac新增節點前之清除節點資訊Oracle
- 刪除oracle10g rac(rhel4)節點_節點Oracle
- 【kingsql分享】解決RAC大量UNKNOWN和CRS-0216: Could not stop resourceSQL
- oracle11g RAC新增節點Oracle
- 雙節點RAC 修改PROCESS程式數
- Oracle10g RAC 加節點Oracle
- rac中控制節點間並行並行
- 規劃單節點遷移到rac
- 【kingsql分享】ASH的研究和分析SQL
- 【kingsql分享】關於PGA的研究SQL
- oracle 10g rac,刪除故障節點並新增新節點Oracle 10g
- 【RAC】節點2上不能完全識別節點1上的asmdiskASM
- oracle 10g rac 新增節點與刪除節點步驟Oracle 10g
- 【RAC】部署安裝RAC時確保主節點的時間小於其他節點時間
- Windows 11.2.0.4 RAC安裝配置以及RAC新增節點Windows
- 【kingsql分享】Oracle18c RAC ADVM卷OFFLINE修復一例SQLOracle
- DRM特性引起的RAC節點當機
- rac 11.2R版本新增節點
- ORACLE RAC環境下刪除節點Oracle
- 官方文件學習:RAC刪除節點