Oracle Exadata 一体机关机过程(虚拟机环境)
admin
2023-05-11 09:01:54
0次

编辑好cell,db节点信息文件all_group,dbs_group,cell_group
[root@idc-dns1 exatest]# pwd
/root/exatest
[root@idc-dns1 exatest]# cat all_group
exadb1
exadb2
cell1
cell2
cell3
[root@idc-dns1 exatest]# cat dbs_group
exadb1
exadb2
[root@idc-dns1 exatest]# cat cell_group
cell1
cell2
cell3
[root@idc-dns1 exatest]#

添加所有服务器的ssh信任,实现远程登陆免输入密码

[root@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
[root@idc-dns1 exatest]#
[root@idc-dns1 exatest]#
[root@idc-dns1 exatest]#
测试一下dcli获取所有主机的hostname
[root@idc-dns1 exatest]# dcli -g all_group -l root hostname
exadb1: exadb1
exadb2: exadb2
cell1: cell1
cell2: cell2
cell3: cell3
检查一下db主机的集群配置是否开机启动
[root@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.

禁用开机启动
[root@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数据库集群
[root@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.
[root@idc-dns1 exatest]#

检查db节点上是否还存在集群进程
[root@idc-dns1 exatest]# dcli -g dbs_group -l root "ps -ef | grep diskmo[n]"
 

检查cell自动报警通知
[root@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
[root@idc-dns1 exatest]#
[root@idc-dns1 exatest]#
[root@idc-dns1 exatest]#

禁用Cell报警通知
[root@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
[root@idc-dns1 exatest]#
[root@idc-dns1 exatest]#
[root@idc-dns1 exatest]#

关闭Cell服务
[root@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.
[root@idc-dns1 exatest]#
[root@idc-dns1 exatest]#
[root@idc-dns1 exatest]#
[root@idc-dns1 exatest]#

cell关机
[root@idc-dns1 exatest]# dcli -g cell_group -l root poweroff

db关机
[root@idc-dns1 exatest]# dcli -g dbs_group -l root poweroff          
[root@idc-dns1 exatest]#
[root@idc-dns1 exatest]#
[root@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)

相关内容

热门资讯

空调连续工作多久需要停机休息 空调连续工作的时间取决于多个因素,包括空调的型号、功率、使用环境和维护情况等。一般来说,空调可以连续...
空调哪个符号是除湿的 空调除湿功能通常用一个水滴形状的符号表示。不同品牌和型号的空调遥控器可能会有所差异,但一般来说,除湿...
格力空调多长时间加一次氟利昂 1、一般情况下,空调对氟利昂的使用量是非常小的,所以在空调使用了四年左右的时候再考虑加也没问题。2、...
空调用多长时间需要加氟一次 一般情况下是五年。当出现以下这几种情况时,空调才需要加氟。1、空调的室内机和室外机各有两个接口,当接...
格调生活·C标思享荟:卡萨帝在... 9月12日的郑州龙湖金融岛,夜风轻拂,灯光璀璨。“C标时刻共传奇——卡萨帝思享荟暨20周年品牌盛典郑...
品牌价值破千亿、高端份额持续领... 9月12日,“C标时刻共传奇——卡萨帝思享荟暨20周年品牌盛典郑州站”在郑州龙湖金融岛举办。2026...
空调主板坏了修800还是换新的 空调主板坏了是修还是换新,需要考虑多个因素,以下是一些建议:1. 维修成本:如果维修费用较低,比如 ...
空调开多久需要休息多长时间 问题:空调开多久需要休息多长时间回答:1、在使用空调的过程中,一般空调开7~8个小时左右需要休息2~...
中央空调多长时间清洗一次 1、一般空调开机前清洗一次即可,空调开机中间时段再清洗一次,空调关机时清洗一次,这样比较合理。2、空...
中央空调氟利昂多久加一次 看空调制热和制冷程度,很多人的观点认为氟利昂必须一年放一次,其实这个观点是错误的,理解上面有点偏差,...