【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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【RAC】Oracle10g rac新增刪除節點命令參考Oracle
- 【kingsql分享】Oracle 18c RAC補丁升級實戰【DBRU】SQLOracle
- 【kingsql分享】Oracle18c RAC ADVM卷OFFLINE修復一例SQLOracle
- Oracle RAC新增節點Oracle
- 2節點RAC安裝
- rac新增節點前之清除節點資訊
- Windows 11.2.0.4 RAC安裝配置以及RAC新增節點Windows
- oracle11g RAC新增節點Oracle
- RAC二節點啟動異常
- oracle 11g rac新增節點前之清除節點資訊Oracle
- rac新增節點步驟(11g)
- rac新增節點容易遇到的問題
- DRM特性引起的RAC節點當機
- 【kingsql分享】Linux平臺判斷大小端SQLLinux
- 11gR2 RAC新增節點步驟
- oracle11g_RAC新增刪除節點Oracle
- Oracle 11g RAC重新新增節點Oracle
- 3節點RAC資料庫夯故障分析資料庫
- [重慶思莊每日技術分享]-RAC 一節點Listener狀態為Not All Endpoints Registered
- 11.2.0.4 RAC生產環境刪除故障節點與增加新服務節點
- Oracle優化案例-新增RAC節點(二十九)Oracle優化
- 【RAC】作業系統重灌後RAC11g節點重置注意事項作業系統
- rac新增節點容易遇到的問題(11g)
- RAC節點啟動失敗--ASM無法連線ASM
- 11g rac新增節點步驟(11g)
- 11g rac新增節點容易遇到的問題
- oracle兩節點RAC,由於gipc導致某節點crs無法啟動問題分析Oracle
- oracle 11.2.0.4 rac節點異常當機之ORA-07445Oracle
- Oracle RAC某一節點異常,你該怎麼辦?Oracle
- rac二節點例項redo故障無法啟動修復
- DM8 配置DMDSC主備環境(rac到單節點 )
- [重慶思莊每日技術分享]-11g rac scan ip 如何手動切換到其他節點上
- 關於Oracle 11G RAC雙節點之間存在防火牆導致只能一個節點執行Oracle防火牆
- 【kingsql分享】OEL7.6安裝Oracle18c RPM新玩法SQLOracle
- 【kingsql分享】使用BBED修改Oracle資料檔案頭推進SCNSQLOracle
- 【kingsql分享】Oracle Database 19c的各種新特性介紹SQLOracleDatabase
- 【kingsql分享】 多租戶細粒度資源模型 - New Resource Modeling SchemeSQL模型Scheme
- Vmware linux redhat6.4 安裝11g(11.2.0.1) 雙節點RACLinuxRedhat
- 模擬oracle rac節點異常時如何保持ogg正常執行Oracle