<pre name="code" class="sql">[grid@devrac1 ~]$ crsctl status res -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.DATA.dg ONLINE ONLINE devrac1 ONLINE ONLINE devrac2 ora.LISTENER.lsnr ONLINE ONLINE devrac1 ONLINE ONLINE devrac2 ora.OCRVOT.dg ONLINE ONLINE devrac1 ONLINE ONLINE devrac2 ora.asm ONLINE ONLINE devrac1 Started ONLINE ONLINE devrac2 Started ora.gsd OFFLINE OFFLINE devrac1 OFFLINE OFFLINE devrac2 ora.net1.network ONLINE ONLINE devrac1 ONLINE ONLINE devrac2 ora.ons ONLINE ONLINE devrac1 ONLINE ONLINE devrac2 -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE devrac2 ora.cvu 1 ONLINE ONLINE devrac2 ora.devrac.db 1 ONLINE ONLINE devrac1 Open 2 ONLINE ONLINE devrac2 Open ora.devrac.devrun1.svc 1 ONLINE ONLINE devrac1 ora.devrac.devrun2.svc 1 ONLINE ONLINE devrac2 ora.devrac1.vip 1 ONLINE ONLINE devrac1 ora.devrac2.vip 1 ONLINE ONLINE devrac2 ora.oc4j 1 ONLINE ONLINE devrac2 ora.scan1.vip 1 ONLINE ONLINE devrac2 ###################################################################################################################################################################### [grid@devrac2 ~]$ crsctl status res -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.DATA.dg ONLINE ONLINE devrac1 ONLINE ONLINE devrac2 ora.LISTENER.lsnr ONLINE ONLINE devrac1 ONLINE ONLINE devrac2 ora.OCRVOT.dg ONLINE ONLINE devrac1 ONLINE ONLINE devrac2 ora.asm ONLINE ONLINE devrac1 Started ONLINE ONLINE devrac2 Started ora.gsd OFFLINE OFFLINE devrac1 OFFLINE OFFLINE devrac2 ora.net1.network ONLINE ONLINE devrac1 ONLINE ONLINE devrac2 ora.ons ONLINE ONLINE devrac1 ONLINE ONLINE devrac2 -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE devrac2 ora.cvu 1 ONLINE ONLINE devrac2 ora.devrac.db 1 ONLINE ONLINE devrac1 Open 2 ONLINE ONLINE devrac2 Open ora.devrac.devrun1.svc 1 ONLINE ONLINE devrac1 ora.devrac.devrun2.svc 1 ONLINE ONLINE devrac2 ora.devrac1.vip 1 ONLINE ONLINE devrac1 ora.devrac2.vip 1 ONLINE ONLINE devrac2 ora.oc4j 1 ONLINE ONLINE devrac2 ora.scan1.vip 1 ONLINE ONLINE devrac2 ----开始连在devrac1节点上 SQL> select distinct username from v$session; USERNAME ------------------------------ HZMCASSET CZCIS SYS CBSRUN [grid@devrac1 ~]$ crsctl stop crs CRS-4563: Insufficient user privileges. CRS-4000: Command Stop failed, or completed with errors. [grid@devrac1 ~]$ exit logout [root@devrac1 grid]# crsctl stop crs CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'devrac1' CRS-2673: Attempting to stop 'ora.crsd' on 'devrac1' CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'devrac1' CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'devrac1' CRS-2673: Attempting to stop 'ora.devrac.devrun1.svc' on 'devrac1' CRS-2677: Stop of 'ora.devrac.devrun1.svc' on 'devrac1' succeeded CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'devrac1' succeeded CRS-2673: Attempting to stop 'ora.devrac1.vip' on 'devrac1' CRS-2677: Stop of 'ora.devrac1.vip' on 'devrac1' succeeded CRS-2672: Attempting to start 'ora.devrac1.vip' on 'devrac2' CRS-2676: Start of 'ora.devrac1.vip' on 'devrac2' succeeded CRS-2672: Attempting to start 'ora.devrac.devrun1.svc' on 'devrac2' CRS-2676: Start of 'ora.devrac.devrun1.svc' on 'devrac2' succeeded CRS-2673: Attempting to stop 'ora.OCRVOT.dg' on 'devrac1' CRS-2673: Attempting to stop 'ora.devrac.db' on 'devrac1' CRS-2677: Stop of 'ora.devrac.db' on 'devrac1' succeeded CRS-2673: Attempting to stop 'ora.DATA.dg' on 'devrac1' CRS-2677: Stop of 'ora.DATA.dg' on 'devrac1' succeeded CRS-2677: Stop of 'ora.OCRVOT.dg' on 'devrac1' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'devrac1' CRS-2677: Stop of 'ora.asm' on 'devrac1' succeeded CRS-2673: Attempting to stop 'ora.ons' on 'devrac1' CRS-2677: Stop of 'ora.ons' on 'devrac1' succeeded CRS-2673: Attempting to stop 'ora.net1.network' on 'devrac1' CRS-2677: Stop of 'ora.net1.network' on 'devrac1' succeeded CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'devrac1' has completed CRS-2677: Stop of 'ora.crsd' on 'devrac1' succeeded CRS-2673: Attempting to stop 'ora.mdnsd' on 'devrac1' CRS-2673: Attempting to stop 'ora.ctssd' on 'devrac1' CRS-2673: Attempting to stop 'ora.evmd' on 'devrac1' CRS-2673: Attempting to stop 'ora.asm' on 'devrac1' CRS-2677: Stop of 'ora.evmd' on 'devrac1' succeeded CRS-2677: Stop of 'ora.mdnsd' on 'devrac1' succeeded CRS-2677: Stop of 'ora.asm' on 'devrac1' succeeded CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'devrac1' CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'devrac1' succeeded CRS-2677: Stop of 'ora.ctssd' on 'devrac1' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'devrac1' CRS-2677: Stop of 'ora.cssd' on 'devrac1' succeeded CRS-2673: Attempting to stop 'ora.crf' on 'devrac1' CRS-2677: Stop of 'ora.crf' on 'devrac1' succeeded CRS-2673: Attempting to stop 'ora.gipcd' on 'devrac1' CRS-2677: Stop of 'ora.gipcd' on 'devrac1' succeeded CRS-2673: Attempting to stop 'ora.gpnpd' on 'devrac1' CRS-2677: Stop of 'ora.gpnpd' on 'devrac1' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'devrac1' has completed CRS-4133: Oracle High Availability Services has been stopped. [grid@devrac2 ~]$ crsctl status res -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.DATA.dg ONLINE OFFLINE devrac1 ONLINE ONLINE devrac2 ora.LISTENER.lsnr ONLINE OFFLINE devrac1 ONLINE ONLINE devrac2 ora.OCRVOT.dg ONLINE OFFLINE devrac1 ONLINE ONLINE devrac2 ora.asm ONLINE OFFLINE devrac1 ONLINE ONLINE devrac2 Started ora.gsd OFFLINE OFFLINE devrac1 OFFLINE OFFLINE devrac2 ora.net1.network ONLINE OFFLINE devrac1 ONLINE ONLINE devrac2 ora.ons ONLINE OFFLINE devrac1 ONLINE ONLINE devrac2 -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE devrac2 ora.cvu 1 ONLINE ONLINE devrac2 ora.devrac.db 1 ONLINE OFFLINE Instance Shutdown 2 ONLINE ONLINE devrac2 Open ora.devrac.devrun1.svc 1 ONLINE ONLINE devrac2 ora.devrac.devrun2.svc 1 ONLINE ONLINE devrac2 ora.devrac1.vip 1 ONLINE INTERMEDIATE devrac2 FAILED OVER ora.devrac2.vip 1 ONLINE ONLINE devrac2 ora.oc4j 1 ONLINE ONLINE devrac2 ora.scan1.vip 1 ONLINE ONLINE devrac2 启动CRS: [grid@devrac1 ~]$ crsctl status res -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.DATA.dg ONLINE ONLINE devrac1 ONLINE ONLINE devrac2 ora.LISTENER.lsnr ONLINE ONLINE devrac1 ONLINE ONLINE devrac2 ora.OCRVOT.dg ONLINE ONLINE devrac1 ONLINE ONLINE devrac2 ora.asm ONLINE ONLINE devrac1 Started ONLINE ONLINE devrac2 Started ora.gsd OFFLINE OFFLINE devrac1 OFFLINE OFFLINE devrac2 ora.net1.network ONLINE ONLINE devrac1 ONLINE ONLINE devrac2 ora.ons ONLINE ONLINE devrac1 ONLINE ONLINE devrac2 -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE devrac2 ora.cvu 1 ONLINE ONLINE devrac2 ora.devrac.db 1 ONLINE ONLINE devrac1 Open 2 ONLINE ONLINE devrac2 Open ora.devrac.devrun1.svc 1 ONLINE ONLINE devrac2 ora.devrac.devrun2.svc 1 ONLINE ONLINE devrac2 ora.devrac1.vip 1 ONLINE ONLINE devrac1 ora.devrac2.vip 1 ONLINE ONLINE devrac2 ora.oc4j 1 ONLINE ONLINE devrac2 ora.scan1.vip 1 ONLINE ONLINE devrac2 crsctl stop crs 方式停止数据库,启动后数据库会自动打开
11g Rac 切换
转载本文章为转载内容,我们尊重原作者对文章享有的著作权。如有内容错误或侵权问题,欢迎原作者联系我们进行内容更正或删除文章。
上一篇:Unix 主机认证配置
下一篇:Buffer lock
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
centos7.8搭建Oracle11g RAC
centos7.8搭建Oracle11g RAC
oracle VMware bc -
11G RAC 安装
一、修改系统相关参数 1.修改主机名 vi /etc/hostname 临时方
linux 主机名 ip地址 -
Oracle集群(RAC)11g
集群是把Oracle 实例(运行在服务器上的真来访问数据的进程和内存结构)与Oracle数据库(在存储设备上的实际数据的物理结构
Oracle SQL SQL Server 应用服务器 JDBC