Linux 红帽系统Oracle Rac维护指令

雨点打透心脏的1/2处 2023-10-03 09:13 17阅读 0赞

**Linux 红帽系统Oracle Rac维护指令**

<table> 
 <thead> 
  <tr> 
   <th></th> 
   <th></th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td></td> 
   <td></td> 
  </tr> 
  <tr> 
   <td>lsnrctl status</td> 
   <td>查看监听状态</td> 
  </tr> 
  <tr> 
   <td>srvctl start listener</td> 
   <td>启动监听</td> 
  </tr> 
  <tr> 
   <td>lsnrctl status</td> 
   <td></td> 
  </tr> 
  <tr> 
   <td>srvctl start database -d mydbrac</td> 
   <td></td> 
  </tr> 
  <tr> 
   <td>crs_stat -v -t</td> 
   <td></td> 
  </tr> 
  <tr> 
   <td></td> 
   <td></td> 
  </tr> 
 </tbody> 
</table>

### 停止数据库服务 ###

<table> 
 <thead> 
  <tr> 
   <th></th> 
   <th></th> 
   <th></th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>srvctl stop database -d mydbrac</td> 
   <td>停止数据库实例</td> 
   <td>grid</td> 
  </tr> 
  <tr> 
   <td>crs_stat -v -t</td> 
   <td>【查看ora.DATA.dg -&gt; ora.mydbrac.db 的 State 【ONLINE / OFFLINE】</td> 
   <td>grid</td> 
  </tr> 
  <tr> 
   <td>srvctl stop listener</td> 
   <td>停止数据库监听</td> 
   <td>grid</td> 
  </tr> 
  <tr> 
   <td>crs_stat -v -t</td> 
   <td>查看数据库监听状态【查看ora.DATA.dg -&gt; ora.mydbrac.lsnr 的 State 【ONLINE / OFFLINE】</td> 
   <td>grid</td> 
  </tr> 
  <tr> 
   <td>crsctl stop crs</td> 
   <td>停止crs服务</td> 
   <td>root</td> 
  </tr> 
  <tr> 
   <td>init 0</td> 
   <td>关机</td> 
   <td></td> 
  </tr> 
 </tbody> 
</table>

## 启动Oracle Rac ##

<table> 
 <thead> 
  <tr> 
   <th></th> 
   <th></th> 
   <th></th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>lsnrctl status</td> 
   <td>查看监听状态</td> 
   <td>grid</td> 
  </tr> 
  <tr> 
   <td>crsctl start crs</td> 
   <td>启动CRS服务</td> 
   <td>root</td> 
  </tr> 
  <tr> 
   <td>srvctl start listener</td> 
   <td>启动监听服务</td> 
   <td>grid</td> 
  </tr> 
  <tr> 
   <td>srvctl start databse -d mydbrac</td> 
   <td>启动数据库实例</td> 
   <td>grid</td> 
  </tr> 
  <tr> 
   <td>srvctl start listener -n mydbrac1</td> 
   <td></td> 
   <td></td> 
  </tr> 
 </tbody> 
</table>

### CRS状态查看（crs\_stat -v -t） ###

### 查看磁盘环境配置 ###

[grid@mydbrac1 ~]$ cd /dev/mapper/
    [grid@mydbrac1 mapper]$ ls -l
    total 0
    crw-rw---- 1 root root 10, 58 Jun 15 11:37 control
    lrwxrwxrwx 1 root root      7 Jun 15 11:37 mpathc -> ../dm-0
    lrwxrwxrwx 1 root root      7 Jun 15 11:37 mpathcp1 -> ../dm-1
    lrwxrwxrwx 1 root root      8 Jun 15 11:37 mpathcp10 -> ../dm-10
    lrwxrwxrwx 1 root root      8 Jun 15 11:37 mpathcp11 -> ../dm-11
    lrwxrwxrwx 1 root root      8 Jun 15 11:37 mpathcp12 -> ../dm-12
    lrwxrwxrwx 1 root root      8 Jun 15 11:37 mpathcp13 -> ../dm-13
    lrwxrwxrwx 1 root root      8 Jun 15 11:37 mpathcp14 -> ../dm-14
    lrwxrwxrwx 1 root root      8 Jun 15 11:37 mpathcp15 -> ../dm-15
    lrwxrwxrwx 1 root root      7 Jun 15 11:37 mpathcp2 -> ../dm-2
    lrwxrwxrwx 1 root root      7 Jun 15 11:37 mpathcp3 -> ../dm-3
    lrwxrwxrwx 1 root root      7 Jun 15 11:37 mpathcp4 -> ../dm-4
    lrwxrwxrwx 1 root root      7 Jun 15 11:37 mpathcp5 -> ../dm-5
    lrwxrwxrwx 1 root root      7 Jun 15 11:37 mpathcp6 -> ../dm-6
    lrwxrwxrwx 1 root root      7 Jun 15 11:37 mpathcp7 -> ../dm-7
    lrwxrwxrwx 1 root root      7 Jun 15 11:37 mpathcp8 -> ../dm-8
    lrwxrwxrwx 1 root root      7 Jun 15 11:37 mpathcp9 -> ../dm-9

### 查看ASM日志 ###

[grid@mydbrac1 ~]$ cd $ORACLE_BASE/d   [Tab键]
    [grid@mydbrac1 ~]$ cd /u01/app/grid/diag/
    [grid@mydbrac1 diag]$ cd /u01/app/grid/diag/
    asm/     tnslsnr/ 
    [grid@mydbrac1 diag]$ cd /u01/app/grid/diag/asm/+asm/+ASM1/trace/
    [grid@mydbrac1 trace]$ tail -200f alert_+ASM1.log

### 查看监听环境 ###

[root@mydbrac1 ~]# crs_stat  -v -t
    Name           Type           R/RA   F/FT   Target    State     Host        
    ----------------------------------------------------------------------
    ora.DATA.dg    ora....up.type 0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora....ER.lsnr ora....er.type 0/5    0/     OFFLINE   OFFLINE               
    ora....N1.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    mydbrac1    
    ora.OCR.dg     ora....up.type 0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora.asm        ora.asm.type   0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora.cvu        ora.cvu.type   0/5    0/0    ONLINE    ONLINE    mydbrac2    
    ora.gsd        ora.gsd.type   0/5    0/     OFFLINE   OFFLINE               
    ora....network ora....rk.type 0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora.oc4j       ora.oc4j.type  0/1    0/2    ONLINE    ONLINE    mydbrac2    
    ora.ons        ora.ons.type   0/3    0/     ONLINE    ONLINE    mydbrac1    
    ora....ry.acfs ora....fs.type 0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora.scan1.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    mydbrac1    
    ora.mydbrac.db ora....se.type 0/2    0/1    OFFLINE   OFFLINE               
    ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    mydbrac1    
    ora....C1.lsnr application    0/5    0/0    OFFLINE   OFFLINE               
    ora....ac1.gsd application    0/5    0/0    OFFLINE   OFFLINE               
    ora....ac1.ons application    0/3    0/0    ONLINE    ONLINE    mydbrac1    
    ora....ac1.vip ora....t1.type 0/0    0/0    ONLINE    ONLINE    mydbrac1    
    ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    mydbrac2    
    ora....C2.lsnr application    0/5    0/0    OFFLINE   OFFLINE         ------------------<--      
    ora....ac2.gsd application    0/5    0/0    OFFLINE   OFFLINE               
    ora....ac2.ons application    0/3    0/0    ONLINE    ONLINE    mydbrac2    
    ora....ac2.vip ora....t1.type 0/0    0/0    ONLINE    ONLINE    mydbrac2    
    [root@mydbrac1 ~]# su - grid
    [grid@mydbrac1 ~]$ lsnrctl status                    --查看监听状态
    
    LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 15-JUN-2021 13:00:05
    
    Copyright (c) 1991, 2013, Oracle.  All rights reserved.
    
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
    TNS-12541: TNS:no listener
     TNS-12560: TNS:protocol adapter error
      TNS-00511: No listener
       Linux Error: 2: No such file or directory
    [grid@mydbrac1 ~]$ 
    [grid@mydbrac1 ~]$ 
    [grid@mydbrac1 ~]$ srvctl start listener     --启动监听
    [grid@mydbrac1 ~]$ 
    [grid@mydbrac1 ~]$ lsnrctl status
    
    LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 15-JUN-2021 13:04:32
    
    Copyright (c) 1991, 2013, Oracle.  All rights reserved.
    
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
    STATUS of the LISTENER
    ------------------------
    Alias                     LISTENER
    Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
    Start Date                15-JUN-2021 13:00:36
    Uptime                    0 days 0 hr. 3 min. 56 sec
    Trace Level               off
    Security                  ON: Local OS Authentication
    SNMP                      OFF
    Listener Parameter File   /u01/app/11.2.0.4/grid/network/admin/listener.ora
    Listener Log File         /u01/app/grid/diag/tnslsnr/mydbrac1/listener/alert/log.xml
    Listening Endpoints Summary...
      (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.125.101)(PORT=1521)))
      (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.125.103)(PORT=1521)))
    Services Summary...
    Service "+ASM" has 1 instance(s).
      Instance "+ASM1", status READY, has 1 handler(s) for this service...
    The command completed successfully

### 停止、启动数据库实例 ###

[grid@mydbrac2 ~]$ srvctl stop database  -d mydbrac     --停止数据库服务
    [grid@mydbrac2 ~]$ crs_stat -v -t
    Name           Type           R/RA   F/FT   Target    State     Host        
    ----------------------------------------------------------------------
    ora.DATA.dg    ora....up.type 0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora....ER.lsnr ora....er.type 0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora....N1.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    mydbrac1    
    ora.OCR.dg     ora....up.type 0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora.asm        ora.asm.type   0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora.cvu        ora.cvu.type   0/5    0/0    ONLINE    ONLINE    mydbrac2    
    ora.gsd        ora.gsd.type   0/5    0/     OFFLINE   OFFLINE               
    ora....network ora....rk.type 0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora.oc4j       ora.oc4j.type  0/1    0/2    ONLINE    ONLINE    mydbrac2    
    ora.ons        ora.ons.type   0/3    0/     ONLINE    ONLINE    mydbrac1    
    ora....ry.acfs ora....fs.type 0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora.scan1.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    mydbrac1    
    ora.mydbrac.db ora....se.type 0/2    0/1    OFFLINE   OFFLINE               
    ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    mydbrac1    
    ora....C1.lsnr application    0/5    0/0    ONLINE    ONLINE    mydbrac1    
    ora....ac1.gsd application    0/5    0/0    OFFLINE   OFFLINE               
    ora....ac1.ons application    0/3    0/0    ONLINE    ONLINE    mydbrac1    
    ora....ac1.vip ora....t1.type 0/0    0/0    ONLINE    ONLINE    mydbrac1    
    ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    mydbrac2    
    ora....C2.lsnr application    0/5    0/0    ONLINE    ONLINE    mydbrac2    
    ora....ac2.gsd application    0/5    0/0    OFFLINE   OFFLINE               
    ora....ac2.ons application    0/3    0/0    ONLINE    ONLINE    mydbrac2    
    ora....ac2.vip ora....t1.type 0/0    0/0    ONLINE    ONLINE    mydbrac2    
    [grid@mydbrac2 ~]$ srvctl start database -d mydbrac
    [grid@mydbrac2 ~]$ crs_stat -v -t
    Name           Type           R/RA   F/FT   Target    State     Host        
    ----------------------------------------------------------------------
    ora.DATA.dg    ora....up.type 0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora....ER.lsnr ora....er.type 0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora....N1.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    mydbrac1    
    ora.OCR.dg     ora....up.type 0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora.asm        ora.asm.type   0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora.cvu        ora.cvu.type   0/5    0/0    ONLINE    ONLINE    mydbrac2    
    ora.gsd        ora.gsd.type   0/5    0/     OFFLINE   OFFLINE               
    ora....network ora....rk.type 0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora.oc4j       ora.oc4j.type  0/1    0/2    ONLINE    ONLINE    mydbrac2    
    ora.ons        ora.ons.type   0/3    0/     ONLINE    ONLINE    mydbrac1    
    ora....ry.acfs ora....fs.type 0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora.scan1.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    mydbrac1    
    ora.mydbrac.db ora....se.type 0/2    0/1    ONLINE    ONLINE    mydbrac1    
    ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    mydbrac1    
    ora....C1.lsnr application    0/5    0/0    ONLINE    ONLINE    mydbrac1    
    ora....ac1.gsd application    0/5    0/0    OFFLINE   OFFLINE               
    ora....ac1.ons application    0/3    0/0    ONLINE    ONLINE    mydbrac1    
    ora....ac1.vip ora....t1.type 0/0    0/0    ONLINE    ONLINE    mydbrac1    
    ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    mydbrac2    
    ora....C2.lsnr application    0/5    0/0    ONLINE    ONLINE    mydbrac2    
    ora....ac2.gsd application    0/5    0/0    OFFLINE   OFFLINE               
    ora....ac2.ons application    0/3    0/0    ONLINE    ONLINE    mydbrac2    
    ora....ac2.vip ora....t1.type 0/0    0/0    ONLINE    ONLINE    mydbrac2

### 关闭数据库，完整流程 ###

Xshell 6 (Build 0204)
    Copyright (c) 2002 NetSarang Computer, Inc. All rights reserved.
    
    Type `help' to learn how to use Xshell prompt.
    [D:\~]$ 
    
    Connecting to 192.168.125.101:22...
    Connection established.
    To escape to local shell, press 'Ctrl+Alt+]'.
    
    Last login: Wed Jun 16 09:58:29 2021 from 192.168.125.10189
    [root@mydbrac1 ~]# srvctl stop database  -d mydbrac
    PRCC-1016 : mydbrac was already stopped
    [root@mydbrac1 ~]# crs_stat -v -t
    Name           Type           R/RA   F/FT   Target    State     Host        
    ----------------------------------------------------------------------
    ora.DATA.dg    ora....up.type 0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora....ER.lsnr ora....er.type 0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora....N1.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    mydbrac2    
    ora.OCR.dg     ora....up.type 0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora.asm        ora.asm.type   0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora.cvu        ora.cvu.type   0/5    0/0    ONLINE    ONLINE    mydbrac1    
    ora.gsd        ora.gsd.type   0/5    0/     OFFLINE   OFFLINE               
    ora....network ora....rk.type 0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora.oc4j       ora.oc4j.type  0/1    0/2    ONLINE    ONLINE    mydbrac1    
    ora.ons        ora.ons.type   0/3    0/     ONLINE    ONLINE    mydbrac1    
    ora....ry.acfs ora....fs.type 0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora.scan1.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    mydbrac2    
    ora.mydbrac.db ora....se.type 0/2    0/1    OFFLINE   OFFLINE               
    ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    mydbrac1    
    ora....C1.lsnr application    0/5    0/0    ONLINE    ONLINE    mydbrac1    
    ora....ac1.gsd application    0/5    0/0    OFFLINE   OFFLINE               
    ora....ac1.ons application    0/3    0/0    ONLINE    ONLINE    mydbrac1    
    ora....ac1.vip ora....t1.type 0/0    0/0    ONLINE    ONLINE    mydbrac1    
    ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    mydbrac2    
    ora....C2.lsnr application    0/5    0/0    ONLINE    ONLINE    mydbrac2    
    ora....ac2.gsd application    0/5    0/0    OFFLINE   OFFLINE               
    ora....ac2.ons application    0/3    0/0    ONLINE    ONLINE    mydbrac2    
    ora....ac2.vip ora....t1.type 0/0    0/0    ONLINE    ONLINE    mydbrac2    
    [root@mydbrac1 ~]# srvctl start database  -d mydbrac
    PRCC-1014 : mydbrac was already running
    PRCR-1004 : Resource ora.mydbrac.db is already running
    PRCR-1079 : Failed to start resource ora.mydbrac.db
    CRS-5702: Resource 'ora.mydbrac.db' is already running on 'mydbrac1'
    CRS-5702: Resource 'ora.mydbrac.db' is already running on 'mydbrac2'
    [root@mydbrac1 ~]# crs_stat -v -t
    Name           Type           R/RA   F/FT   Target    State     Host        
    ----------------------------------------------------------------------
    ora.DATA.dg    ora....up.type 0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora....ER.lsnr ora....er.type 0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora....N1.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    mydbrac2    
    ora.OCR.dg     ora....up.type 0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora.asm        ora.asm.type   0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora.cvu        ora.cvu.type   0/5    0/0    ONLINE    ONLINE    mydbrac1    
    ora.gsd        ora.gsd.type   0/5    0/     OFFLINE   OFFLINE               
    ora....network ora....rk.type 0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora.oc4j       ora.oc4j.type  0/1    0/2    ONLINE    ONLINE    mydbrac1    
    ora.ons        ora.ons.type   0/3    0/     ONLINE    ONLINE    mydbrac1    
    ora....ry.acfs ora....fs.type 0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora.scan1.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    mydbrac2    
    ora.mydbrac.db ora....se.type 0/2    0/1    ONLINE    ONLINE    mydbrac1    
    ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    mydbrac1    
    ora....C1.lsnr application    0/5    0/0    ONLINE    ONLINE    mydbrac1    
    ora....ac1.gsd application    0/5    0/0    OFFLINE   OFFLINE               
    ora....ac1.ons application    0/3    0/0    ONLINE    ONLINE    mydbrac1    
    ora....ac1.vip ora....t1.type 0/0    0/0    ONLINE    ONLINE    mydbrac1    
    ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    mydbrac2    
    ora....C2.lsnr application    0/5    0/0    ONLINE    ONLINE    mydbrac2    
    ora....ac2.gsd application    0/5    0/0    OFFLINE   OFFLINE               
    ora....ac2.ons application    0/3    0/0    ONLINE    ONLINE    mydbrac2    
    ora....ac2.vip ora....t1.type 0/0    0/0    ONLINE    ONLINE    mydbrac2    
    [root@mydbrac1 ~]# srvctl stop database  -d mydbrac
    [root@mydbrac1 ~]# crs_stat -v -t
    Name           Type           R/RA   F/FT   Target    State     Host        
    ----------------------------------------------------------------------
    ora.DATA.dg    ora....up.type 0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora....ER.lsnr ora....er.type 0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora....N1.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    mydbrac2    
    ora.OCR.dg     ora....up.type 0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora.asm        ora.asm.type   0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora.cvu        ora.cvu.type   0/5    0/0    ONLINE    ONLINE    mydbrac1    
    ora.gsd        ora.gsd.type   0/5    0/     OFFLINE   OFFLINE               
    ora....network ora....rk.type 0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora.oc4j       ora.oc4j.type  0/1    0/2    ONLINE    ONLINE    mydbrac1    
    ora.ons        ora.ons.type   0/3    0/     ONLINE    ONLINE    mydbrac1    
    ora....ry.acfs ora....fs.type 0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora.scan1.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    mydbrac2    
    ora.mydbrac.db ora....se.type 0/2    0/1    OFFLINE   OFFLINE               
    ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    mydbrac1    
    ora....C1.lsnr application    0/5    0/0    ONLINE    ONLINE    mydbrac1    
    ora....ac1.gsd application    0/5    0/0    OFFLINE   OFFLINE               
    ora....ac1.ons application    0/3    0/0    ONLINE    ONLINE    mydbrac1    
    ora....ac1.vip ora....t1.type 0/0    0/0    ONLINE    ONLINE    mydbrac1    
    ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    mydbrac2    
    ora....C2.lsnr application    0/5    0/0    ONLINE    ONLINE    mydbrac2    
    ora....ac2.gsd application    0/5    0/0    OFFLINE   OFFLINE               
    ora....ac2.ons application    0/3    0/0    ONLINE    ONLINE    mydbrac2    
    ora....ac2.vip ora....t1.type 0/0    0/0    ONLINE    ONLINE    mydbrac2    
    [root@mydbrac1 ~]# srvctl stop listener
    [root@mydbrac1 ~]# crs_stat -v -t
    Name           Type           R/RA   F/FT   Target    State     Host        
    ----------------------------------------------------------------------
    ora.DATA.dg    ora....up.type 0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora....ER.lsnr ora....er.type 0/5    0/     OFFLINE   OFFLINE               
    ora....N1.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    mydbrac2    
    ora.OCR.dg     ora....up.type 0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora.asm        ora.asm.type   0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora.cvu        ora.cvu.type   0/5    0/0    ONLINE    ONLINE    mydbrac1    
    ora.gsd        ora.gsd.type   0/5    0/     OFFLINE   OFFLINE               
    ora....network ora....rk.type 0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora.oc4j       ora.oc4j.type  0/1    0/2    ONLINE    ONLINE    mydbrac1    
    ora.ons        ora.ons.type   0/3    0/     ONLINE    ONLINE    mydbrac1    
    ora....ry.acfs ora....fs.type 0/5    0/     ONLINE    ONLINE    mydbrac1    
    ora.scan1.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    mydbrac2    
    ora.mydbrac.db ora....se.type 0/2    0/1    OFFLINE   OFFLINE               
    ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    mydbrac1    
    ora....C1.lsnr application    0/5    0/0    OFFLINE   OFFLINE               
    ora....ac1.gsd application    0/5    0/0    OFFLINE   OFFLINE               
    ora....ac1.ons application    0/3    0/0    ONLINE    ONLINE    mydbrac1    
    ora....ac1.vip ora....t1.type 0/0    0/0    ONLINE    ONLINE    mydbrac1    
    ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    mydbrac2    
    ora....C2.lsnr application    0/5    0/0    OFFLINE   OFFLINE               
    ora....ac2.gsd application    0/5    0/0    OFFLINE   OFFLINE               
    ora....ac2.ons application    0/3    0/0    ONLINE    ONLINE    mydbrac2    
    ora....ac2.vip ora....t1.type 0/0    0/0    ONLINE    ONLINE    mydbrac2    
    [root@mydbrac1 ~]# crsctl stop crs
    CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'mydbrac1'
    CRS-2673: Attempting to stop 'ora.crsd' on 'mydbrac1'
    CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'mydbrac1'
    CRS-2673: Attempting to stop 'ora.cvu' on 'mydbrac1'
    CRS-2673: Attempting to stop 'ora.mydbrac1.vip' on 'mydbrac1'
    CRS-2673: Attempting to stop 'ora.oc4j' on 'mydbrac1'
    CRS-2673: Attempting to stop 'ora.OCR.dg' on 'mydbrac1'
    CRS-2673: Attempting to stop 'ora.registry.acfs' on 'mydbrac1'
    CRS-2673: Attempting to stop 'ora.DATA.dg' on 'mydbrac1'
    CRS-2677: Stop of 'ora.cvu' on 'mydbrac1' succeeded
    CRS-2672: Attempting to start 'ora.cvu' on 'mydbrac2'
    CRS-2676: Start of 'ora.cvu' on 'mydbrac2' succeeded
    CRS-2677: Stop of 'ora.registry.acfs' on 'mydbrac1' succeeded
    CRS-2677: Stop of 'ora.mydbrac1.vip' on 'mydbrac1' succeeded
    CRS-2672: Attempting to start 'ora.mydbrac1.vip' on 'mydbrac2'
    CRS-2676: Start of 'ora.mydbrac1.vip' on 'mydbrac2' succeeded
    CRS-2677: Stop of 'ora.oc4j' on 'mydbrac1' succeeded
    CRS-2672: Attempting to start 'ora.oc4j' on 'mydbrac2'
    CRS-2677: Stop of 'ora.OCR.dg' on 'mydbrac1' succeeded
    CRS-2676: Start of 'ora.oc4j' on 'mydbrac2' succeeded
    CRS-2677: Stop of 'ora.DATA.dg' on 'mydbrac1' succeeded
    CRS-2679: Attempting to clean 'ora.DATA.dg' on 'mydbrac1'
    CRS-2681: Clean of 'ora.DATA.dg' on 'mydbrac1' succeeded
    CRS-2673: Attempting to stop 'ora.asm' on 'mydbrac1'
    CRS-2677: Stop of 'ora.asm' on 'mydbrac1' succeeded
    CRS-2673: Attempting to stop 'ora.ons' on 'mydbrac1'
    CRS-2677: Stop of 'ora.ons' on 'mydbrac1' succeeded
    CRS-2673: Attempting to stop 'ora.net1.network' on 'mydbrac1'
    CRS-2677: Stop of 'ora.net1.network' on 'mydbrac1' succeeded
    CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'mydbrac1' has completed
    CRS-2677: Stop of 'ora.crsd' on 'mydbrac1' succeeded
    CRS-2673: Attempting to stop 'ora.mdnsd' on 'mydbrac1'
    CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'mydbrac1'
    CRS-2673: Attempting to stop 'ora.ctssd' on 'mydbrac1'
    CRS-2673: Attempting to stop 'ora.evmd' on 'mydbrac1'
    CRS-2673: Attempting to stop 'ora.asm' on 'mydbrac1'
    CRS-2677: Stop of 'ora.mdnsd' on 'mydbrac1' succeeded
    CRS-2677: Stop of 'ora.evmd' on 'mydbrac1' succeeded
    CRS-2677: Stop of 'ora.asm' on 'mydbrac1' succeeded
    CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'mydbrac1'
    CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'mydbrac1' succeeded
    CRS-2677: Stop of 'ora.ctssd' on 'mydbrac1' succeeded
    CRS-2673: Attempting to stop 'ora.cssd' on 'mydbrac1'
    CRS-2677: Stop of 'ora.cssd' on 'mydbrac1' succeeded
    CRS-2673: Attempting to stop 'ora.crf' on 'mydbrac1'
    CRS-2677: Stop of 'ora.drivers.acfs' on 'mydbrac1' succeeded
    CRS-2677: Stop of 'ora.crf' on 'mydbrac1' succeeded
    CRS-2673: Attempting to stop 'ora.gipcd' on 'mydbrac1'
    CRS-2677: Stop of 'ora.gipcd' on 'mydbrac1' succeeded
    CRS-2673: Attempting to stop 'ora.gpnpd' on 'mydbrac1'
    CRS-2677: Stop of 'ora.gpnpd' on 'mydbrac1' succeeded
    CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'mydbrac1' has completed
    CRS-4133: Oracle High Availability Services has been stopped.
    [root@mydbrac1 ~]# crs_stat -v -t
    CRS-0184: Cannot communicate with the CRS daemon.
    
    [root@mydbrac1 ~]#

### 查看服务器设备信息 ###

[root@mydbrac1 ~]# ls /dev
    asm      cpu              full       lp2                 ram12   sdb11     tgt    tty3   tty52    vcs
    asm-n1   cpu_dma_latency  fuse       lp3                 ram13   sdb12     tty    tty30  tty53    vcs1
    asm-n10  crash            hidraw0    lpfcmgmt            ram14   sdb13     tty0   tty31  tty54    vcs2
    asm-n11  disk             hidraw1    MAKEDEV             ram15   sdb14     tty1   tty32  tty55    vcs3
    asm-n12  dm-0             hidraw2    mapper              ram2    sdb15     tty10  tty33  tty56    vcs4
    asm-n13  dm-1             hidraw3    mcelog              ram3    sdb2      tty11  tty34  tty57    vcs5
    asm-n14  dm-10            hidraw4    mem                 ram4    sdb3      tty12  tty35  tty58    vcs6
    asm-n15  dm-11            hidraw5    net                 ram5    sdb4      tty13  tty36  tty59    vcsa
    asm-n2   dm-12            hidraw6    network_latency     ram6    sdb5      tty14  tty37  tty6     vcsa1
    asm-n3   dm-13            hpet       network_throughput  ram7    sdb6      tty15  tty38  tty60    vcsa2
    asm-n4   dm-14            hugepages  null                ram8    sdb7      tty16  tty39  tty61    vcsa3
    asm-n5   dm-15            hvc0       nvram               ram9    sdb8      tty17  tty4   tty62    vcsa4
    asm-n6   dm-2             input      ofsctl              random  sdb9      tty18  tty40  tty63    vcsa5
    asm-n7   dm-3             kmsg       oldmem              raw     sdc       tty19  tty41  tty7     vcsa6
    asm-n8   dm-4             log        port                root    sg0       tty2   tty42  tty8     vga_arbiter
    asm-n9   dm-5             loop0      ppp                 rtc     sg1       tty20  tty43  tty9     zero
    autofs   dm-6             loop1      ptmx                rtc0    sg2       tty21  tty44  ttyS0
    block    dm-7             loop2      ptp0                scd0    sg3       tty22  tty45  ttyS1
    bsg      dm-8             loop3      ptp1                sda     shm       tty23  tty46  ttyS2
    bus      dm-9             loop4      ptp2                sda1    snapshot  tty24  tty47  ttyS3
    cdrom    dvd              loop5      pts                 sda2    sr0       tty25  tty48  uinput
    cdrw     dvdrw            loop6      ram0                sda3    stderr    tty26  tty49  urandom
    char     fb               loop7      ram1                sdb     stdin     tty27  tty5   usbmon0
    console  fb0              lp0        ram10               sdb1    stdout    tty28  tty50  usbmon1
    core     fd               lp1        ram11               sdb10   systty    tty29  tty51  usbmon2

### 编辑主机名配置 ###

[root@mydbrac1 ~]# vi /etc/hosts
    
    127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
    ::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
    
    # public ip
    192.168.125.101 mydbrac1
    192.168.125.102 mydbrac2
    
    #priv ip
    10.10.10.1    mydbrac1-priv
    10.10.10.2    mydbrac2-priv
    
    #vip ip
    192.168.125.103 mydbrac1-vip
    192.168.125.104 mydbrac2-vip
    
    #scan ip
    192.168.125.108 mydbrac-scan

### 查看ip配置 ###

[root@mydbrac1 ~]# ifconfig
    eth0      Link encap:Ethernet  HWaddr F8:0F:41:F3:54:AA  
              inet addr:192.168.125.101  Bcast:192.168.125.10255  Mask:255.255.255.0
              inet6 addr: fe80::fa0f:41ff:fef3:54aa/64 Scope:Link
              UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
              RX packets:24172 errors:0 dropped:0 overruns:0 frame:0
              TX packets:1382 errors:0 dropped:0 overruns:0 carrier:0
              collisions:0 txqueuelen:1000 
              RX bytes:2261713 (2.1 MiB)  TX bytes:192723 (188.2 KiB)
              Memory:dfa20000-dfa40000 
    
    eth0:3    Link encap:Ethernet  HWaddr F8:0F:41:F3:54:AA  
              inet addr:192.168.125.103  Bcast:192.168.125.10255  Mask:255.255.255.0
              UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
              Memory:dfa20000-dfa40000 
    
    eth1      Link encap:Ethernet  HWaddr F8:0F:41:F3:54:AB  
              inet addr:10.10.10.1  Bcast:10.10.10.255  Mask:255.255.255.0
              inet6 addr: fe80::fa0f:41ff:fef3:54ab/64 Scope:Link
              UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
              RX packets:121269 errors:0 dropped:0 overruns:0 frame:0
              TX packets:81340 errors:0 dropped:0 overruns:0 carrier:0
              collisions:0 txqueuelen:1000 
              RX bytes:90735989 (86.5 MiB)  TX bytes:60360139 (57.5 MiB)
              Memory:dfa00000-dfa20000 
    
    eth1:1    Link encap:Ethernet  HWaddr F8:0F:41:F3:54:AB  
              inet addr:169.254.5.4  Bcast:169.254.255.255  Mask:255.255.0.0
              UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
              Memory:dfa00000-dfa20000 
    
    eth2      Link encap:Ethernet  HWaddr F8:0F:41:F3:54:A9  
              inet6 addr: fe80::fa0f:41ff:fef3:54a9/64 Scope:Link
              UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
              RX packets:33504 errors:0 dropped:0 overruns:0 frame:0
              TX packets:3 errors:0 dropped:0 overruns:0 carrier:0
              collisions:0 txqueuelen:1000 
              RX bytes:3161008 (3.0 MiB)  TX bytes:258 (258.0 b)
              Interrupt:16 Memory:df900000-df920000 
    
    lo        Link encap:Local Loopback  
              inet addr:127.0.0.1  Mask:255.0.0.0
              inet6 addr: ::1/128 Scope:Host
              UP LOOPBACK RUNNING  MTU:16436  Metric:1
              RX packets:15409 errors:0 dropped:0 overruns:0 frame:0
              TX packets:15409 errors:0 dropped:0 overruns:0 carrier:0
              collisions:0 txqueuelen:0 
              RX bytes:8724809 (8.3 MiB)  TX bytes:8724809 (8.3 MiB)

### 查看当前机器ASM相关进程 ###

[root@mydbrac1 ~]# ps -ef|grep ASM
    grid      4662     1  0 10:27 ?        00:00:00 asm_pmon_+ASM1
    grid      4664     1  0 10:27 ?        00:00:00 asm_psp0_+ASM1
    grid      4666     1  0 10:27 ?        00:00:22 asm_vktm_+ASM1
    grid      4670     1  0 10:27 ?        00:00:00 asm_gen0_+ASM1
    grid      4672     1  0 10:27 ?        00:00:02 asm_diag_+ASM1
    grid      4674     1  0 10:27 ?        00:00:00 asm_ping_+ASM1
    grid      4676     1  0 10:27 ?        00:00:22 asm_dia0_+ASM1
    grid      4678     1  0 10:27 ?        00:00:08 asm_lmon_+ASM1
    grid      4680     1  0 10:27 ?        00:00:05 asm_lmd0_+ASM1
    grid      4682     1  0 10:27 ?        00:00:10 asm_lms0_+ASM1
    grid      4686     1  0 10:27 ?        00:00:00 asm_lmhb_+ASM1
    grid      4688     1  0 10:27 ?        00:00:00 asm_mman_+ASM1
    grid      4690     1  0 10:27 ?        00:00:00 asm_dbw0_+ASM1
    grid      4692     1  0 10:27 ?        00:00:00 asm_lgwr_+ASM1
    grid      4694     1  0 10:27 ?        00:00:00 asm_ckpt_+ASM1
    grid      4696     1  0 10:27 ?        00:00:00 asm_smon_+ASM1
    grid      4698     1  0 10:27 ?        00:00:01 asm_rbal_+ASM1
    grid      4700     1  0 10:27 ?        00:00:00 asm_gmon_+ASM1
    grid      4702     1  0 10:27 ?        00:00:00 asm_mmon_+ASM1
    grid      4704     1  0 10:27 ?        00:00:02 asm_mmnl_+ASM1
    grid      4706     1  0 10:27 ?        00:00:00 asm_lck0_+ASM1
    grid      4797     1  0 10:27 ?        00:00:00 oracle+ASM1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
    grid      4810     1  0 10:27 ?        00:00:00 oracle+ASM1_ocr (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
    grid      4812     1  0 10:27 ?        00:00:00 asm_asmb_+ASM1
    grid      4814     1  0 10:27 ?        00:00:00 oracle+ASM1_asmb_+asm1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
    grid      4971     1  0 10:27 ?        00:00:00 oracle+ASM1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
    grid      4973     1  0 10:27 ?        00:00:00 oracle+ASM1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
    root     10307  9458  0 11:43 pts/3    00:00:00 grep ASM

### 检查OGI安装，运行状态 ###

[root@mydbrac1 ~]# srvctl status nodeapps
    VIP mydbrac1-vip is enabled
    VIP mydbrac1-vip is running on node: mydbrac1
    VIP mydbrac2-vip is enabled
    VIP mydbrac2-vip is running on node: mydbrac2
    Network is enabled
    Network is running on node: mydbrac1
    Network is running on node: mydbrac2
    GSD is disabled
    GSD is not running on node: mydbrac1
    GSD is not running on node: mydbrac2
    ONS is enabled
    ONS daemon is running on node: mydbrac1
    ONS daemon is running on node: mydbrac2

### 连接oracle数据库 ###

[grid@mydbrac1 ~]$ su - oracle
    Password: 
    [oracle@mydbrac1 ~]$ sqlplus / as sysdba
    SQL*Plus: Release 11.2.0.4.0 Production on Thu Jun 17 13:00:43 2021
    Copyright (c) 1982, 2013, Oracle.  All rights reserved.
    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
    With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
    Data Mining and Real Application Testing options
    
    SQL> conn satbase / satbase
    Connected.
    SQL>

[oracle@mydbrac1 ~]$ sqlplus satbase/satbase @mydbrac
    
    SQL*Plus: Release 11.2.0.4.0 Production on Thu Jun 17 13:04:17 2021
    
    Copyright (c) 1982, 2013, Oracle.  All rights reserved.
    
    
    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
    With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
    Data Mining and Real Application Testing options
    
    SP2-0310: unable to open file "mydbrac.sql"