RAC 手工关闭启动过程
发表于:2025-02-01 作者:千家信息网编辑
千家信息网最后更新 2025年02月01日,[oracle@rac2 ~]$ srvctl stop database -d RAC[oracle@rac2 ~]$ exitlogout[root@rac2 ~]# /u01/app/11.2.
千家信息网最后更新 2025年02月01日RAC 手工关闭启动过程
[oracle@rac2 ~]$ srvctl stop database -d RAC[oracle@rac2 ~]$ exitlogout[root@rac2 ~]# /u01/app/11.2.0.3/grid/bin/crsctl stop cluster -all 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.DATA.dg' on 'rac2'CRS-2673: Attempting to stop 'ora.cvu' on 'rac2'CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac2'CRS-2673: Attempting to stop 'ora.oc4j' on 'rac2'CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac2'CRS-2677: Stop of 'ora.cvu' on 'rac2' succeededCRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac2' succeededCRS-2673: Attempting to stop 'ora.rac2.vip' on 'rac2'CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rac2' succeededCRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac2'CRS-2677: Stop of 'ora.rac2.vip' on 'rac2' succeededCRS-2677: Stop of 'ora.scan1.vip' on 'rac2' succeededCRS-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.DATA.dg' on 'rac1'CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac1'CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.rac1.vip' on 'rac1'CRS-2677: Stop of 'ora.rac1.vip' on 'rac1' succeededCRS-2677: Stop of 'ora.oc4j' on 'rac2' succeededCRS-2677: Stop of 'ora.DATA.dg' on 'rac2' succeededCRS-2673: Attempting to stop 'ora.asm' on 'rac2'CRS-2677: Stop of 'ora.asm' on 'rac2' succeededCRS-2677: Stop of 'ora.DATA.dg' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.asm' on 'rac1'CRS-2677: Stop of 'ora.asm' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.ons' on 'rac1'CRS-2677: Stop of 'ora.ons' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.net1.network' on 'rac1'CRS-2677: Stop of 'ora.net1.network' on 'rac1' succeededCRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac1' has completedCRS-2673: Attempting to stop 'ora.ons' on 'rac2'CRS-2677: Stop of 'ora.ons' on 'rac2' succeededCRS-2673: Attempting to stop 'ora.net1.network' on 'rac2'CRS-2677: Stop of 'ora.net1.network' on 'rac2' succeededCRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac2' has completedCRS-2677: Stop of 'ora.crsd' on 'rac1' succeededCRS-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.crsd' on 'rac2' succeededCRS-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.evmd' on 'rac2' succeededCRS-2677: Stop of 'ora.ctssd' on 'rac1' succeededCRS-2677: Stop of 'ora.evmd' on 'rac1' succeededCRS-2677: Stop of 'ora.ctssd' on 'rac2' succeededCRS-2677: Stop of 'ora.asm' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac1'CRS-2677: Stop of 'ora.asm' on 'rac2' succeededCRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac2'CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac2' succeededCRS-2673: Attempting to stop 'ora.cssd' on 'rac2'CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.cssd' on 'rac1'CRS-2677: Stop of 'ora.cssd' on 'rac2' succeededCRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded[root@rac2 ~]# su - oracle[oracle@rac2 ~]$ source grid_env [oracle@rac2 ~]$ crs_stacrs_start crs_start.bin crs_stat crs_stat.bin [oracle@rac2 ~]$ crs_stat -t -vCRS-0184: Cannot communicate with the CRS daemon.[oracle@rac2 ~]$ exitlogout[root@rac2 ~]# /u01/app/11.2.0.3/grid/bin/crsctl stop has -fCRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac2'CRS-2673: Attempting to stop 'ora.crf' on 'rac2'CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac2'CRS-2677: Stop of 'ora.crf' on 'rac2' succeededCRS-2673: Attempting to stop 'ora.gipcd' on 'rac2'CRS-2677: Stop of 'ora.mdnsd' on 'rac2' succeededCRS-2677: Stop of 'ora.gipcd' on 'rac2' succeededCRS-2673: Attempting to stop 'ora.gpnpd' on 'rac2'CRS-2677: Stop of 'ora.gpnpd' on 'rac2' succeededCRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac2' has completedCRS-4133: Oracle High Availability Services has been stopped.[root@rac2 ~]# ssh rac1The authenticity of host 'rac1 (192.168.56.9)' can't be established.RSA key fingerprint is ce:d0:7b:fc:79:49:bc:73:35:30:b8:04:8c:1a:13:9a.Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added 'rac1,192.168.56.9' (RSA) to the list of known hosts.root@rac1's password: Last login: Thu Jul 11 09:28:34 2019 from 192.168.56.1[root@rac1 ~]# /u01/app/11.2.0.3/grid/bin/crsctl stop has -fCRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac1'CRS-2673: Attempting to stop 'ora.crf' on 'rac1'CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac1'CRS-2677: Stop of 'ora.crf' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.gipcd' on 'rac1'CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeededCRS-2677: Stop of 'ora.gipcd' on 'rac1' succeededCRS-2673: Attempting to stop 'ora.gpnpd' on 'rac1'CRS-2677: Stop of 'ora.gpnpd' on 'rac1' succeededCRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac1' has completedCRS-4133: Oracle High Availability Services has been stopped.[root@rac1 ~]# /u01/app/11.2.0.3/grid/bin/crsctl start has CRS-4123: Oracle High Availability Services has been started.[root@rac1 ~]# exitlogoutConnection to rac1 closed.[root@rac2 ~]# /u01/app/11.2.0.3/grid/bin/crsctl start hasCRS-4123: Oracle High Availability Services has been started.[root@rac2 ~]# /u01/app/11.2.0.3/grid/bin/crsctl start cluster -allCRS-5702: Resource 'ora.evmd' is already running on 'rac2'CRS-5702: Resource 'ora.crsd' is already running on 'rac2'CRS-4690: Oracle Clusterware is already running on 'rac1'CRS-4000: Command Start failed, or completed with errors.[root@rac2 ~]# su - oracle[oracle@rac2 ~]$ srvctl start database -d RAC[oracle@rac2 ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 11 10:05:59 2019Copyright (c) 1982, 2011, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,Data Mining and Real Application Testing optionsSQL> SELECT inst_name FROM v$active_instances;INST_NAME--------------------------------------------------------------------------------rac1:RAC1rac2:RAC2SQL> exitDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,Data Mining and Real Application Testing options [oracle@rac2 ~]$ crs_stat -t -vName Type R/RA F/FT Target State Host ----------------------------------------------------------------------ora.DATA.dg ora....up.type 0/5 0/ ONLINE ONLINE rac1 ora....ER.lsnr ora....er.type 0/5 0/ ONLINE ONLINE rac1 ora....N1.lsnr ora....er.type 0/5 0/0 ONLINE ONLINE rac1 ora.asm ora.asm.type 0/5 0/ ONLINE ONLINE rac1 ora.cvu ora.cvu.type 0/5 0/0 ONLINE ONLINE rac1 ora.gsd ora.gsd.type 0/5 0/ OFFLINE OFFLINE ora....network ora....rk.type 0/5 0/ ONLINE ONLINE rac1 ora.oc4j ora.oc4j.type 0/1 0/2 ONLINE ONLINE rac1 ora.ons ora.ons.type 0/3 0/ ONLINE ONLINE rac1 ora.rac.db ora....se.type 0/2 0/1 ONLINE ONLINE rac1 ora....SM1.asm application 0/5 0/0 ONLINE ONLINE rac1 ora....C1.lsnr application 0/5 0/0 ONLINE ONLINE rac1 ora.rac1.gsd application 0/5 0/0 OFFLINE OFFLINE ora.rac1.ons application 0/3 0/0 ONLINE ONLINE rac1 ora.rac1.vip ora....t1.type 0/0 0/0 ONLINE ONLINE rac1 ora....SM2.asm application 0/5 0/0 ONLINE ONLINE rac2 ora....C2.lsnr application 0/5 0/0 ONLINE ONLINE rac2 ora.rac2.gsd application 0/5 0/0 OFFLINE OFFLINE ora.rac2.ons application 0/3 0/0 ONLINE ONLINE rac2 ora.rac2.vip ora....t1.type 0/0 0/0 ONLINE ONLINE rac2 ora.scan1.vip ora....ip.type 0/0 0/0 ONLINE ONLINE rac1 [oracle@rac2 ~]$
手工
过程
数据库的安全要保护哪些东西
数据库安全各自的含义是什么
生产安全数据库录入
数据库的安全性及管理
数据库安全策略包含哪些
海淀数据库安全审计系统
建立农村房屋安全信息数据库
易用的数据库客户端支持安全管理
连接数据库失败ssl安全错误
数据库的锁怎样保障安全
网信吉林网络安全培训会
软件开发世界级大佬
公司企业软件开发
教育局网络安全工作汇报材料
沈阳安卓软件开发怎么收费
软件开发违法吗
铁路网络安全事件分
软件开发项目经理需要什么证书
如何把网页放到服务器
软件开发过程中存在哪些浪费
网易版休闲服务器推荐
大数据应用网络安全
创造中心服务器
美团这个软件开发
wow最新的服务器
头歌mysql数据库答案
怎么让名师云课堂连接服务器
java软件开发真正工作
酒店从业人员网络安全培训方案
防范网络安全行为的技术措施
软件开发学web吗
我的世界服务器回城雪球无范围
csgo匹配日本服务器
苏州仓库管理软件开发
计算机网络技术有哪些话题
新浪接口查询股票数据库
河北使用软件开发要多少钱
2021网络安全心得
自己怎么做一元夺宝软件开发
网络安全ppt 宣传