第八章 如何开启&关闭12c R2 RAC DB

关闭顺序：

1、关闭数据库,oracle用户执行srvctl命令：

 [oracle@paycore01 ~]$ srvctl stop database -d paidit ---停止所有节点上的实例

或者每个节点登录数据库后执行SQL>shutdown immediate

2，停止HAS(High Availability Services)，必须以root用户

[root@paycore01 oracle]# cd /oracle/app/11.2.0/grid/bin

[root@paycore01 bin]# ./crsctl stop has -f

3，停止集群服务，必须以root用户：

[root@paycore01 oracle]# cd /oracle/app/11.2.0/grid/bin

 [root@paycore01 bin]# ./crsctl stop cluster -all  ----停止所有节点服务

或[root@paycore01 bin]# ./crsctl stop cluster        ----停止本节点集群服务，每个节点分别执行 

[root@paycore01 bin]# pwd

/oracle/app/11.2.0/grid/bin

[root@paycore01 bin]# ./crsctl stop cluster

CRS-2673: Attempting to stop 'ora.crsd' on 'paycore01'

CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on server 'paycore01'

CRS-2673: Attempting to stop 'ora.DATA01.dg' on 'paycore01'

CRS-2673: Attempting to stop 'ora.LISTENER_SCAN3.lsnr' on 'paycore01'

CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'paycore01'

CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'paycore01'

CRS-2673: Attempting to stop 'ora.chad' on 'paycore01'

CRS-2673: Attempting to stop 'ora.chad' on 'paycore02'

CRS-2673: Attempting to stop 'ora.cvu' on 'paycore01'

CRS-2673: Attempting to stop 'ora.qosmserver' on 'paycore01'

CRS-2677: Stop of 'ora.DATA01.dg' on 'paycore01' succeeded

CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'paycore01' succeeded

CRS-2677: Stop of 'ora.LISTENER_SCAN3.lsnr' on 'paycore01' succeeded

CRS-2673: Attempting to stop 'ora.scan3.vip' on 'paycore01'

CRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'paycore01' succeeded

CRS-2673: Attempting to stop 'ora.scan2.vip' on 'paycore01'

CRS-2673: Attempting to stop 'ora.OCRVOTE.dg' on 'paycore01'

CRS-2673: Attempting to stop 'ora.MGMT.dg' on 'paycore01'

CRS-2677: Stop of 'ora.OCRVOTE.dg' on 'paycore01' succeeded

CRS-2677: Stop of 'ora.MGMT.dg' on 'paycore01' succeeded

CRS-2673: Attempting to stop 'ora.asm' on 'paycore01'

CRS-2677: Stop of 'ora.asm' on 'paycore01' succeeded

CRS-2673: Attempting to stop 'ora.ASMNET1LSNR_ASM.lsnr' on 'paycore01'

CRS-2677: Stop of 'ora.cvu' on 'paycore01' succeeded

CRS-2677: Stop of 'ora.scan3.vip' on 'paycore01' succeeded

CRS-2677: Stop of 'ora.scan2.vip' on 'paycore01' succeeded

CRS-2677: Stop of 'ora.qosmserver' on 'paycore01' succeeded

CRS-2677: Stop of 'ora.ASMNET1LSNR_ASM.lsnr' on 'paycore01' succeeded

CRS-2677: Stop of 'ora.chad' on 'paycore01' succeeded

CRS-2677: Stop of 'ora.chad' on 'paycore02' succeeded

CRS-2673: Attempting to stop 'ora.mgmtdb' on 'paycore01'

CRS-2677: Stop of 'ora.mgmtdb' on 'paycore01' succeeded

CRS-2673: Attempting to stop 'ora.MGMTLSNR' on 'paycore01'

CRS-2677: Stop of 'ora.MGMTLSNR' on 'paycore01' succeeded

CRS-2673: Attempting to stop 'ora.paycore01.vip' on 'paycore01'

CRS-2672: Attempting to start 'ora.MGMTLSNR' on 'paycore02'

CRS-2677: Stop of 'ora.paycore01.vip' on 'paycore01' succeeded

CRS-2676: Start of 'ora.MGMTLSNR' on 'paycore02' succeeded

CRS-2672: Attempting to start 'ora.mgmtdb' on 'paycore02'

CRS-2676: Start of 'ora.mgmtdb' on 'paycore02' succeeded

CRS-2672: Attempting to start 'ora.chad' on 'paycore02'

CRS-2676: Start of 'ora.chad' on 'paycore02' succeeded

CRS-2672: Attempting to start 'ora.qosmserver' on 'paycore02'

CRS-2672: Attempting to start 'ora.scan2.vip' on 'paycore02'

CRS-2672: Attempting to start 'ora.scan3.vip' on 'paycore02'

CRS-2672: Attempting to start 'ora.cvu' on 'paycore02'

CRS-2672: Attempting to start 'ora.paycore01.vip' on 'paycore02'

CRS-2676: Start of 'ora.scan3.vip' on 'paycore02' succeeded

CRS-2676: Start of 'ora.scan2.vip' on 'paycore02' succeeded

CRS-2676: Start of 'ora.paycore01.vip' on 'paycore02' succeeded

CRS-2676: Start of 'ora.cvu' on 'paycore02' succeeded

CRS-2672: Attempting to start 'ora.LISTENER_SCAN3.lsnr' on 'paycore02'

CRS-2672: Attempting to start 'ora.LISTENER_SCAN2.lsnr' on 'paycore02'

CRS-2676: Start of 'ora.qosmserver' on 'paycore02' succeeded

CRS-2676: Start of 'ora.LISTENER_SCAN2.lsnr' on 'paycore02' succeeded

CRS-2676: Start of 'ora.LISTENER_SCAN3.lsnr' on 'paycore02' succeeded

CRS-2673: Attempting to stop 'ora.ons' on 'paycore01'

CRS-2677: Stop of 'ora.ons' on 'paycore01' succeeded

CRS-2673: Attempting to stop 'ora.net1.network' on 'paycore01'

CRS-2677: Stop of 'ora.net1.network' on 'paycore01' succeeded

CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'paycore01' has completed

CRS-2677: Stop of 'ora.crsd' on 'paycore01' succeeded

CRS-2673: Attempting to stop 'ora.ctssd' on 'paycore01'

CRS-2673: Attempting to stop 'ora.evmd' on 'paycore01'

CRS-2673: Attempting to stop 'ora.storage' on 'paycore01'

CRS-2677: Stop of 'ora.storage' on 'paycore01' succeeded

CRS-2673: Attempting to stop 'ora.asm' on 'paycore01'

CRS-2677: Stop of 'ora.ctssd' on 'paycore01' succeeded

CRS-2677: Stop of 'ora.evmd' on 'paycore01' succeeded

CRS-2677: Stop of 'ora.asm' on 'paycore01' succeeded

CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'paycore01'

CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'paycore01' succeeded

CRS-2673: Attempting to stop 'ora.cssd' on 'paycore01'

CRS-2677: Stop of 'ora.cssd' on 'paycore01' succeeded

[root@paycore01 bin]#

[root@paycore02 ~]# cd /oracle/app/11.2.0/grid/bin

[root@paycore02 bin]# ./crsctl stop cluster

CRS-2673: Attempting to stop 'ora.crsd' on 'paycore02'

CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on server 'paycore02'

CRS-2673: Attempting to stop 'ora.LISTENER_SCAN3.lsnr' on 'paycore02'

CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'paycore02'

CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'paycore02'

CRS-2673: Attempting to stop 'ora.paycore02.vip' on 'paycore02'

CRS-2673: Attempting to stop 'ora.cvu' on 'paycore02'

CRS-2673: Attempting to stop 'ora.DATA01.dg' on 'paycore02'

CRS-2673: Attempting to stop 'ora.OCRVOTE.dg' on 'paycore02'

CRS-2673: Attempting to stop 'ora.chad' on 'paycore02'

CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'paycore02'

CRS-2673: Attempting to stop 'ora.qosmserver' on 'paycore02'

CRS-2677: Stop of 'ora.OCRVOTE.dg' on 'paycore02' succeeded

CRS-2677: Stop of 'ora.DATA01.dg' on 'paycore02' succeeded

CRS-2677: Stop of 'ora.LISTENER_SCAN3.lsnr' on 'paycore02' succeeded

CRS-2673: Attempting to stop 'ora.scan3.vip' on 'paycore02'

CRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'paycore02' succeeded

CRS-2673: Attempting to stop 'ora.scan2.vip' on 'paycore02'

CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'paycore02' succeeded

CRS-2673: Attempting to stop 'ora.scan1.vip' on 'paycore02'

CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'paycore02' succeeded

CRS-2677: Stop of 'ora.paycore02.vip' on 'paycore02' succeeded

CRS-2677: Stop of 'ora.chad' on 'paycore02' succeeded

CRS-2673: Attempting to stop 'ora.mgmtdb' on 'paycore02'

CRS-2677: Stop of 'ora.cvu' on 'paycore02' succeeded

CRS-2677: Stop of 'ora.scan1.vip' on 'paycore02' succeeded

CRS-2677: Stop of 'ora.mgmtdb' on 'paycore02' succeeded

CRS-2673: Attempting to stop 'ora.MGMT.dg' on 'paycore02'

CRS-2673: Attempting to stop 'ora.MGMTLSNR' on 'paycore02'

CRS-2677: Stop of 'ora.qosmserver' on 'paycore02' succeeded

CRS-2677: Stop of 'ora.MGMT.dg' on 'paycore02' succeeded

CRS-2673: Attempting to stop 'ora.asm' on 'paycore02'

CRS-2677: Stop of 'ora.scan3.vip' on 'paycore02' succeeded

CRS-2677: Stop of 'ora.asm' on 'paycore02' succeeded

CRS-2673: Attempting to stop 'ora.ASMNET1LSNR_ASM.lsnr' on 'paycore02'

CRS-2677: Stop of 'ora.scan2.vip' on 'paycore02' succeeded

CRS-2677: Stop of 'ora.ASMNET1LSNR_ASM.lsnr' on 'paycore02' succeeded

CRS-2677: Stop of 'ora.MGMTLSNR' on 'paycore02' succeeded

CRS-2673: Attempting to stop 'ora.paycore01.vip' on 'paycore02'

CRS-2677: Stop of 'ora.paycore01.vip' on 'paycore02' succeeded

CRS-2673: Attempting to stop 'ora.ons' on 'paycore02'

CRS-2677: Stop of 'ora.ons' on 'paycore02' succeeded

CRS-2673: Attempting to stop 'ora.net1.network' on 'paycore02'

CRS-2677: Stop of 'ora.net1.network' on 'paycore02' succeeded

CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'paycore02' has completed

CRS-2677: Stop of 'ora.crsd' on 'paycore02' succeeded

CRS-2673: Attempting to stop 'ora.ctssd' on 'paycore02'

CRS-2673: Attempting to stop 'ora.evmd' on 'paycore02'

CRS-2673: Attempting to stop 'ora.storage' on 'paycore02'

CRS-2677: Stop of 'ora.storage' on 'paycore02' succeeded

CRS-2673: Attempting to stop 'ora.asm' on 'paycore02'

CRS-2677: Stop of 'ora.evmd' on 'paycore02' succeeded

CRS-2677: Stop of 'ora.ctssd' on 'paycore02' succeeded

CRS-2677: Stop of 'ora.asm' on 'paycore02' succeeded

CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'paycore02'

CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'paycore02' succeeded

CRS-2673: Attempting to stop 'ora.cssd' on 'paycore02'

CRS-2677: Stop of 'ora.cssd' on 'paycore02' succeeded

[root@paycore02 bin]#

也可以如下控制所停节点：

[root@paycore01 bin]#  ./crsctl stop cluster -n rac1 rac2

如果在一个节点停止其他所有节点的，而不一一执行命令，则也可以采用：

[root@paycore01 bin]# ./crsctl stop cluster –all

启动顺序：

12c R2的RAC默认开机会自启动，当然如果需要手工启动。手工启动按照cluster, HAS, database的顺序启动即可，具体命令如下：

1、启动集群（cluster）

[root@ paycore01 ~]# ./crsctl start cluster -all  --所有节点同时启动

或者只启动指定节点的

[root@ paycore01 ~]# ./crsctl start cluster -n rac1 rac2  --两个节点同时启动

[root@paycore01 bin]# ./crsctl start cluster

CRS-2672: Attempting to start 'ora.cssdmonitor' on 'paycore01'

CRS-2672: Attempting to start 'ora.evmd' on 'paycore01'

CRS-2676: Start of 'ora.cssdmonitor' on 'paycore01' succeeded

CRS-2672: Attempting to start 'ora.cssd' on 'paycore01'

CRS-2672: Attempting to start 'ora.diskmon' on 'paycore01'

CRS-2676: Start of 'ora.diskmon' on 'paycore01' succeeded

CRS-2676: Start of 'ora.evmd' on 'paycore01' succeeded

CRS-2676: Start of 'ora.cssd' on 'paycore01' succeeded

CRS-2672: Attempting to start 'ora.ctssd' on 'paycore01'

CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'paycore01'

CRS-2676: Start of 'ora.ctssd' on 'paycore01' succeeded

CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'paycore01' succeeded

CRS-2672: Attempting to start 'ora.asm' on 'paycore01'

CRS-2676: Start of 'ora.asm' on 'paycore01' succeeded

CRS-2672: Attempting to start 'ora.storage' on 'paycore01'

CRS-2676: Start of 'ora.storage' on 'paycore01' succeeded

CRS-2672: Attempting to start 'ora.crsd' on 'paycore01'

CRS-2676: Start of 'ora.crsd' on 'paycore01' succeeded

[root@paycore02 bin]# ./crsctl start cluster

CRS-2672: Attempting to start 'ora.evmd' on 'paycore02'

CRS-2672: Attempting to start 'ora.cssdmonitor' on 'paycore02'

CRS-2676: Start of 'ora.cssdmonitor' on 'paycore02' succeeded

CRS-2672: Attempting to start 'ora.cssd' on 'paycore02'

CRS-2672: Attempting to start 'ora.diskmon' on 'paycore02'

CRS-2676: Start of 'ora.diskmon' on 'paycore02' succeeded

CRS-2676: Start of 'ora.evmd' on 'paycore02' succeeded

CRS-2676: Start of 'ora.cssd' on 'paycore02' succeeded

CRS-2672: Attempting to start 'ora.ctssd' on 'paycore02'

CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'paycore02'

CRS-2676: Start of 'ora.ctssd' on 'paycore02' succeeded

CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'paycore02' succeeded

CRS-2672: Attempting to start 'ora.asm' on 'paycore02'

CRS-2676: Start of 'ora.asm' on 'paycore02' succeeded

CRS-2672: Attempting to start 'ora.storage' on 'paycore02'

CRS-2676: Start of 'ora.storage' on 'paycore02' succeeded

CRS-2672: Attempting to start 'ora.crsd' on 'paycore02'

CRS-2676: Start of 'ora.crsd' on 'paycore02' succeeded

[root@paycore02 bin]#

2、启动HAS(High Availability Services)，必须以root用户

[root@ paycore01 bin]# ./crsctl start has 

以上has启动命令需要在每个节点分别执行

3、启动数据库,oracle用户执行srvctl命令（假设数据库名为paidit）：

 [oracle@ paycore01 ~]$ srvctl start database -d paidit ---停止所有节点上的实例

或者每个节点登录数据库后执行SQL>startup