Linux 红帽系统Oracle Rac维护指令
lsnrctl status 查看监听状态 srvctl start listener 启动监听 lsnrctl status srvctl start database -d mydbrac crs_stat -v -t
停止数据库服务
srvctl stop database -d mydbrac 停止数据库实例 grid crs_stat -v -t 【查看ora.DATA.dg -> ora.mydbrac.db 的 State 【ONLINE / OFFLINE】 grid srvctl stop listener 停止数据库监听 grid crs_stat -v -t 查看数据库监听状态【查看ora.DATA.dg -> ora.mydbrac.lsnr 的 State 【ONLINE / OFFLINE】 grid crsctl stop crs 停止crs服务 root init 0 关机
启动Oracle Rac
lsnrctl status 查看监听状态 grid crsctl start crs 启动CRS服务 root srvctl start listener 启动监听服务 grid srvctl start databse -d mydbrac 启动数据库实例 grid srvctl start listener -n mydbrac1
CRS状态查看(crs_stat -v -t)
[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
查看磁盘环境配置
[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"