Oracle Exadata 一体机关机过程(虚拟机环境)

34r2312

编辑好cell，db节点信息文件all_group,dbs_group,cell_group
[iyunv@idc-dns1 exatest]# pwd
/root/exatest
[iyunv@idc-dns1 exatest]# cat all_group
exadb1
exadb2
cell1
cell2
cell3
[iyunv@idc-dns1 exatest]# cat dbs_group
exadb1
exadb2
[iyunv@idc-dns1 exatest]# cat cell_group
cell1
cell2
cell3
[iyunv@idc-dns1 exatest]#
添加所有服务器的ssh信任，实现远程登陆免输入密码
[iyunv@idc-dns1 exatest]# dcli -k -g all_group -l root
The authenticity of host 'cell1 (172.16.218.61)' can't be established.
RSA key fingerprint is 30:db:e2:c3:a9:69:71:58:48:51:3b:59:41:16:9c:71.
Are you sure you want to continue connecting (yes/no)? yes
root@cell1's password:
The authenticity of host 'exadb1 (172.16.218.171)' can't be established.
RSA key fingerprint is 30:db:e2:c3:a9:69:71:58:48:51:3b:59:41:16:9c:71.
Are you sure you want to continue connecting (yes/no)? yes
root@exadb1's password:
The authenticity of host 'cell2 (172.16.218.62)' can't be established.
RSA key fingerprint is 30:db:e2:c3:a9:69:71:58:48:51:3b:59:41:16:9c:71.
Are you sure you want to continue connecting (yes/no)? yes
root@cell2's password:
The authenticity of host 'exadb2 (172.16.218.172)' can't be established.
RSA key fingerprint is 30:db:e2:c3:a9:69:71:58:48:51:3b:59:41:16:9c:71.
Are you sure you want to continue connecting (yes/no)? yes
root@exadb2's password:
The authenticity of host 'cell3 (172.16.218.63)' can't be established.
RSA key fingerprint is 30:db:e2:c3:a9:69:71:58:48:51:3b:59:41:16:9c:71.
Are you sure you want to continue connecting (yes/no)? yes
root@cell3's password:
exadb1: ssh key added
exadb2: ssh key added
cell1: ssh key added
cell2: ssh key added
cell3: ssh key added
[iyunv@idc-dns1 exatest]#
[iyunv@idc-dns1 exatest]#
[iyunv@idc-dns1 exatest]#
测试一下dcli获取所有主机的hostname
[iyunv@idc-dns1 exatest]# dcli -g all_group -l root hostname
exadb1: exadb1
exadb2: exadb2
cell1: cell1
cell2: cell2
cell3: cell3
检查一下db主机的集群配置是否开机启动
[iyunv@idc-dns1 exatest]# dcli -g dbs_group -l root /u01/app/11.2.0/grid/bin/crsctl config crs
exadb1: CRS-4622: Oracle High Availability Services autostart is enabled.
exadb2: CRS-4622: Oracle High Availability Services autostart is enabled.
禁用开机启动
[iyunv@idc-dns1 exatest]# dcli -g dbs_group -l root /u01/app/11.2.0/grid/bin/crsctl disable crs
exadb1: CRS-4621: Oracle High Availability Services autostart is disabled.
exadb2: CRS-4621: Oracle High Availability Services autostart is disabled.
db节点停Oracle数据库集群
[iyunv@idc-dns1 exatest]# dcli -g dbs_group -l root /u01/app/11.2.0/grid/bin/crsctl stop crs
exadb1: CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'exadb1'
exadb1: CRS-2673: Attempting to stop 'ora.crsd' on 'exadb1'
exadb1: CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'exadb1'
exadb1: CRS-2673: Attempting to stop 'ora.cvu' on 'exadb1'
exadb1: CRS-2673: Attempting to stop 'ora.registry.acfs' on 'exadb1'
exadb1: CRS-2673: Attempting to stop 'ora.mfy.db' on 'exadb1'
exadb1: CRS-2673: Attempting to stop 'ora.oc4j' on 'exadb1'
exadb1: CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'exadb1'
exadb1: CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'exadb1'
exadb1: CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'exadb1' succeeded
exadb1: CRS-2673: Attempting to stop 'ora.scan1.vip' on 'exadb1'
exadb1: CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'exadb1' succeeded
exadb1: CRS-2673: Attempting to stop 'ora.exadb1.vip' on 'exadb1'
exadb1: CRS-2677: Stop of 'ora.cvu' on 'exadb1' succeeded
exadb1: CRS-2677: Stop of 'ora.mfy.db' on 'exadb1' succeeded
exadb1: CRS-2673: Attempting to stop 'ora.DATA.dg' on 'exadb1'
exadb1: CRS-2673: Attempting to stop 'ora.RECO.dg' on 'exadb1'
exadb1: CRS-2677: Stop of 'ora.registry.acfs' on 'exadb1' succeeded
exadb1: CRS-2677: Stop of 'ora.RECO.dg' on 'exadb1' succeeded
exadb1: CRS-2677: Stop of 'ora.scan1.vip' on 'exadb1' succeeded
exadb1: CRS-2677: Stop of 'ora.exadb1.vip' on 'exadb1' succeeded
exadb1: CRS-2677: Stop of 'ora.oc4j' on 'exadb1' succeeded
exadb1: CRS-2677: Stop of 'ora.DATA.dg' on 'exadb1' succeeded
exadb1: CRS-2673: Attempting to stop 'ora.asm' on 'exadb1'
exadb1: CRS-2677: Stop of 'ora.asm' on 'exadb1' succeeded
exadb1: CRS-2673: Attempting to stop 'ora.ons' on 'exadb1'
exadb1: CRS-2677: Stop of 'ora.ons' on 'exadb1' succeeded
exadb1: CRS-2673: Attempting to stop 'ora.net1.network' on 'exadb1'
exadb1: CRS-2677: Stop of 'ora.net1.network' on 'exadb1' succeeded
exadb1: CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'exadb1' has completed
exadb1: CRS-2677: Stop of 'ora.crsd' on 'exadb1' succeeded
exadb1: CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'exadb1'
exadb1: CRS-2673: Attempting to stop 'ora.ctssd' on 'exadb1'
exadb1: CRS-2673: Attempting to stop 'ora.evmd' on 'exadb1'
exadb1: CRS-2673: Attempting to stop 'ora.asm' on 'exadb1'
exadb1: CRS-2673: Attempting to stop 'ora.mdnsd' on 'exadb1'
exadb1: CRS-2677: Stop of 'ora.evmd' on 'exadb1' succeeded
exadb1: CRS-2677: Stop of 'ora.mdnsd' on 'exadb1' succeeded
exadb1: CRS-2677: Stop of 'ora.ctssd' on 'exadb1' succeeded
exadb1: CRS-2677: Stop of 'ora.drivers.acfs' on 'exadb1' succeeded
exadb1: CRS-2677: Stop of 'ora.asm' on 'exadb1' succeeded
exadb1: CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'exadb1'
exadb1: CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'exadb1' succeeded
exadb1: CRS-2673: Attempting to stop 'ora.cssd' on 'exadb1'
exadb1: CRS-2677: Stop of 'ora.cssd' on 'exadb1' succeeded
exadb1: CRS-2673: Attempting to stop 'ora.diskmon' on 'exadb1'
exadb1: CRS-2673: Attempting to stop 'ora.crf' on 'exadb1'
exadb1: CRS-2677: Stop of 'ora.crf' on 'exadb1' succeeded
exadb1: CRS-2673: Attempting to stop 'ora.gipcd' on 'exadb1'
exadb1: CRS-2677: Stop of 'ora.diskmon' on 'exadb1' succeeded
exadb1: CRS-2677: Stop of 'ora.gipcd' on 'exadb1' succeeded
exadb1: CRS-2673: Attempting to stop 'ora.gpnpd' on 'exadb1'
exadb1: CRS-2677: Stop of 'ora.gpnpd' on 'exadb1' succeeded
exadb1: CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'exadb1' has completed
exadb1: CRS-4133: Oracle High Availability Services has been stopped.
exadb2: CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'exadb2'
exadb2: CRS-2673: Attempting to stop 'ora.crsd' on 'exadb2'
exadb2: CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'exadb2'
exadb2: CRS-2673: Attempting to stop 'ora.registry.acfs' on 'exadb2'
exadb2: CRS-2673: Attempting to stop 'ora.mfy.db' on 'exadb2'
exadb2: CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'exadb2'
exadb2: CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'exadb2' succeeded
exadb2: CRS-2673: Attempting to stop 'ora.exadb2.vip' on 'exadb2'
exadb2: CRS-2677: Stop of 'ora.registry.acfs' on 'exadb2' succeeded
exadb2: CRS-2677: Stop of 'ora.exadb2.vip' on 'exadb2' succeeded
exadb2: CRS-2677: Stop of 'ora.mfy.db' on 'exadb2' succeeded
exadb2: CRS-2673: Attempting to stop 'ora.DATA.dg' on 'exadb2'
exadb2: CRS-2673: Attempting to stop 'ora.RECO.dg' on 'exadb2'
exadb2: CRS-2677: Stop of 'ora.RECO.dg' on 'exadb2' succeeded
exadb2: CRS-2677: Stop of 'ora.DATA.dg' on 'exadb2' succeeded
exadb2: CRS-2673: Attempting to stop 'ora.asm' on 'exadb2'
exadb2: CRS-2677: Stop of 'ora.asm' on 'exadb2' succeeded
exadb2: CRS-2673: Attempting to stop 'ora.ons' on 'exadb2'
exadb2: CRS-2677: Stop of 'ora.ons' on 'exadb2' succeeded
exadb2: CRS-2673: Attempting to stop 'ora.net1.network' on 'exadb2'
exadb2: CRS-2677: Stop of 'ora.net1.network' on 'exadb2' succeeded
exadb2: CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'exadb2' has completed
exadb2: CRS-2677: Stop of 'ora.crsd' on 'exadb2' succeeded
exadb2: CRS-2673: Attempting to stop 'ora.ctssd' on 'exadb2'
exadb2: CRS-2673: Attempting to stop 'ora.evmd' on 'exadb2'
exadb2: CRS-2673: Attempting to stop 'ora.asm' on 'exadb2'
exadb2: CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'exadb2'
exadb2: CRS-2673: Attempting to stop 'ora.mdnsd' on 'exadb2'
exadb2: CRS-2677: Stop of 'ora.evmd' on 'exadb2' succeeded
exadb2: CRS-2677: Stop of 'ora.mdnsd' on 'exadb2' succeeded
exadb2: CRS-2677: Stop of 'ora.ctssd' on 'exadb2' succeeded
exadb2: CRS-2677: Stop of 'ora.asm' on 'exadb2' succeeded
exadb2: CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'exadb2'
exadb2: CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'exadb2' succeeded
exadb2: CRS-2673: Attempting to stop 'ora.cssd' on 'exadb2'
exadb2: CRS-2677: Stop of 'ora.drivers.acfs' on 'exadb2' succeeded
exadb2: CRS-2677: Stop of 'ora.cssd' on 'exadb2' succeeded
exadb2: CRS-2673: Attempting to stop 'ora.diskmon' on 'exadb2'
exadb2: CRS-2673: Attempting to stop 'ora.crf' on 'exadb2'
exadb2: CRS-2677: Stop of 'ora.crf' on 'exadb2' succeeded
exadb2: CRS-2673: Attempting to stop 'ora.gipcd' on 'exadb2'
exadb2: CRS-2677: Stop of 'ora.diskmon' on 'exadb2' succeeded
exadb2: CRS-2677: Stop of 'ora.gipcd' on 'exadb2' succeeded
exadb2: CRS-2673: Attempting to stop 'ora.gpnpd' on 'exadb2'
exadb2: CRS-2677: Stop of 'ora.gpnpd' on 'exadb2' succeeded
exadb2: CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'exadb2' has completed
exadb2: CRS-4133: Oracle High Availability Services has been stopped.
[iyunv@idc-dns1 exatest]#
检查db节点上是否还存在集群进程
[iyunv@idc-dns1 exatest]# dcli -g dbs_group -l root "ps -ef | grep diskmo[n]"

检查cell自动报警通知
[iyunv@idc-dns1 exatest]# dcli -g cell_group -l root "su - celladmin -c \"cellcli -e list cell attributes name,notificationMethod\""
cell1: cell1
cell2: cell2
cell3: cell3
[iyunv@idc-dns1 exatest]#
[iyunv@idc-dns1 exatest]#
[iyunv@idc-dns1 exatest]#
禁用Cell报警通知
[iyunv@idc-dns1 exatest]# dcli -g cell_group -l root "su - celladmin -c \"cellcli -e alter cell notificationMethod=none\""
cell1: Cell cell1 successfully altered
cell2: Cell cell2 successfully altered
cell3: Cell cell3 successfully altered
[iyunv@idc-dns1 exatest]#
[iyunv@idc-dns1 exatest]#
[iyunv@idc-dns1 exatest]#
关闭Cell服务
[iyunv@idc-dns1 exatest]# dcli -g cell_group -l root "su - celladmin -c \"cellcli -e alter cell shutdown services all \""
cell1:
cell1: Stopping the RS, CELLSRV, and MS services...
cell1: The SHUTDOWN of services was successful.
cell2:
cell2: Stopping the RS, CELLSRV, and MS services...
cell2: The SHUTDOWN of services was successful.
cell3:
cell3: Stopping the RS, CELLSRV, and MS services...
cell3: The SHUTDOWN of services was successful.
[iyunv@idc-dns1 exatest]#
[iyunv@idc-dns1 exatest]#
[iyunv@idc-dns1 exatest]#
[iyunv@idc-dns1 exatest]#
cell关机
[iyunv@idc-dns1 exatest]# dcli -g cell_group -l root poweroff
db关机
[iyunv@idc-dns1 exatest]# dcli -g dbs_group -l root poweroff           
[iyunv@idc-dns1 exatest]#
[iyunv@idc-dns1 exatest]#
[iyunv@idc-dns1 exatest]#
参考Oracle Note ID 1093890.1

Steps To Shutdown/Startup The Exadata & RDBMS Services and Cell/Compute Nodes On An Exadata Configuration. (文档 ID 1093890.1)