设为首页 加入收藏

TOP

Oracle11g启动、停止实例和RAC数据库操作实例(二)
2018-04-20 06:06:15 】 浏览:361
Tags:Oracle11g 启动 停止 实例 RAC 数据库 操作
cation 0/5 0/0 OFFLINE OFFLINE ora....E1.lsnr application 0/5 0/0 ONLINE ONLINE node1 ora.node1.gsd application 0/5 0/0 OFFLINE OFFLINE ora.node1.ons application 0/3 0/0 ONLINE ONLINE node1 ora.node1.vip ora....t1.type 0/0 0/0 ONLINE ONLINE node1 ora....SM2.asm application 0/5 0/0 OFFLINE OFFLINE ora....E2.lsnr application 0/5 0/0 ONLINE ONLINE node2 ora.node2.gsd application 0/5 0/0 OFFLINE OFFLINE ora.node2.ons application 0/3 0/0 ONLINE ONLINE node2 ora.node2.vip ora....t1.type 0/0 0/0 ONLINE ONLINE node2 ora.oc4j ora.oc4j.type 0/1 0/2 ONLINE ONLINE node2 ora.ons ora.ons.type 0/3 0/ ONLINE ONLINE node1 ora.orcl.db ora....se.type 0/2 0/1 OFFLINE OFFLINE ora.scan1.vip ora....ip.type 0/0 0/0 ONLINE ONLINE node1 ora.scan2.vip ora....ip.type 0/0 0/0 ONLINE ONLINE node2 ora.scan3.vip ora....ip.type 0/0 0/0 ONLINE ONLINE node1 [grid@node1 ~]$

4、启动ASM实例

[grid@node1 ~]$ sqlplus / as sysasm

SQL*Plus: Release 11.2.0.4.0 Production on Wed Apr 18 21:24:25 2018

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ASM instance started

Total System Global Area 1135747072 bytes
Fixed Size		    2260728 bytes
Variable Size		 1108320520 bytes
ASM Cache		   25165824 bytes
ASM diskgroups mounted
SQL> 
[grid@node1 ~]$ srvctl status asm
ASM is running on node2,node1

5、启动数据库

--查看数据库状态
[grid@node1 ~]$ srvctl status database -d orcl
Instance orcl1 is not running on node node1
Instance orcl2 is not running on node node2
--启动数据库
[grid@node1 ~]$ srvctl start database -d orcl
--查看数据库状态
[grid@node1 ~]$ srvctl status database -d orcl
Instance orcl1 is running on node node1
Instance orcl2 is running on node node2
[grid@node1 ~]$ 

6、查看监听器状态

[grid@node1 ~]$ srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): node2,node1

7、查看集群状态

[grid@node1 ~]$ crs_stat -t -v
Name           Type           R/RA   F/FT   Target    State     Host        
----------------------------------------------------------------------
ora.DATA.dg    ora....up.type 0/5    0/     ONLINE    ONLINE    node1       
ora.FRA.dg     ora....up.type 0/5    0/     ONLINE    ONLINE    node1       
ora....ER.lsnr ora....er.type 0/5    0/     ONLINE    ONLINE    node1       
ora....N1.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    node1       
ora....N2.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    node2       
ora....N3.lsnr ora....er.type 0/5    0/0    ONLINE    ONLINE    node1       
ora.asm        ora.asm.type   0/5    0/     ONLINE    ONLINE    node1       
ora.cvu        ora.cvu.type   0/5    0/0    ONLINE    ONLINE    node2       
ora.gsd        ora.gsd.type   0/5    0/     OFFLINE   OFFLINE               
ora....network ora....rk.type 0/5    0/     ONLINE    ONLINE    node1       
ora....SM1.asm application    0/5    0/0    ONLINE    ONLINE    node1       
ora....E1.lsnr application    0/5    0/0    ONLINE    ONLINE    node1       
ora.node1.gsd  application    0/5    0/0    OFFLINE   OFFLINE               
ora.node1.ons  application    0/3    0/0    ONLINE    ONLINE    node1       
ora.node1.vip  ora....t1.type 0/0    0/0    ONLINE    ONLINE    node1       
ora....SM2.asm application    0/5    0/0    ONLINE    ONLINE    node2       
ora....E2.lsnr application    0/5    0/0    ONLINE    ONLINE    node2       
ora.node2.gsd  application    0/5    0/0    OFFLINE   OFFLINE               
ora.node2.ons  application    0/3    0/0    ONLINE    ONLINE    node2       
ora.node2.vip  ora....t1.type 0/0    0/0    ONLINE    ONLINE    node2       
ora.oc4j       ora.oc4j.type  0/1    0/2    ONLINE    ONLINE    node2       
ora.ons        ora.ons.type   0/3    0/     ONLINE    ONLINE    node1       
ora.orcl.db    ora....se.type 0/2    0/1    ONLINE    ONLINE    node1       
ora.scan1.vip  ora....ip.type 0/0    0/0    ONLINE    ONLINE    node1       
ora.scan2.vip  ora....ip.ty
首页 上一页 1 2 3 下一页 尾页 2/3/3
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
上一篇NO_DATA_FOUND和%NOTFOUND的区别.. 下一篇MySQL查询之max()和min()函数与索..

最新文章

热门文章

Hot 文章

Python

C 语言

C++基础

大数据基础

linux编程基础

C/C++面试题目