千家信息网

RAC 手工关闭启动过程

发表于:2024-12-01 作者:千家信息网编辑
千家信息网最后更新 2024年12月01日,[oracle@rac2 ~]$ srvctl stop database -d RAC[oracle@rac2 ~]$ exitlogout[root@rac2 ~]# /u01/app/11.2.
千家信息网最后更新 2024年12月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 ~]$ 
0