牛刀小试Oracle之ORACLE 11GR2 RAC安装配置--检测GI软件是否正常(三)-阿里云开发者社区

开发者社区> 数据库> 正文
登录阅读全文

牛刀小试Oracle之ORACLE 11GR2 RAC安装配置--检测GI软件是否正常(三)

简介: 1. 切换至grid用户 [root@Zracnode1 ~]# su - grid2.查看CRS状态(目前Oracle11GR2官方文档,不建议用如下命令检测了,等我有时间在整理补充) [grid@Zracnode1 ~]$ crs_stat -t Name         ...
1. 切换至grid用户
[root@Zracnode1 ~]# su - grid

2.查看CRS状态(目前Oracle11GR2官方文档,不建议用如下命令检测了,等我有时间在整理补充)
[grid@Zracnode1 ~]$ crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.CRS.dg     ora....up.type ONLINE    ONLINE    zracnode1   
ora.DATA.dg    ora....up.type ONLINE    ONLINE    zracnode1   
ora....ER.lsnr ora....er.type ONLINE    ONLINE    zracnode1   
ora....N1.lsnr ora....er.type ONLINE    ONLINE    zracnode2   
ora....N2.lsnr ora....er.type ONLINE    ONLINE    zracnode1   
ora....N3.lsnr ora....er.type ONLINE    ONLINE    zracnode1   
ora.REC.dg     ora....up.type ONLINE    ONLINE    zracnode1   
ora.arpdb.db   ora....se.type ONLINE    ONLINE    zracnode1   
ora.asm        ora.asm.type   ONLINE    ONLINE    zracnode1   
ora.cvu        ora.cvu.type   ONLINE    ONLINE    zracnode1   
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               
ora....network ora....rk.type ONLINE    ONLINE    zracnode1   
ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    zracnode1   
ora.ons        ora.ons.type   ONLINE    ONLINE    zracnode1   
ora....ry.acfs ora....fs.type ONLINE    ONLINE    zracnode1   
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    zracnode2   
ora.scan2.vip  ora....ip.type ONLINE    ONLINE    zracnode1   
ora.scan3.vip  ora....ip.type ONLINE    ONLINE    zracnode1   
ora....SM1.asm application    ONLINE    ONLINE    zracnode1   
ora....E1.lsnr application    ONLINE    ONLINE    zracnode1   
ora....de1.gsd application    OFFLINE   OFFLINE               
ora....de1.ons application    ONLINE    ONLINE    zracnode1   
ora....de1.vip ora....t1.type ONLINE    ONLINE    zracnode1   
ora....SM2.asm application    ONLINE    ONLINE    zracnode2   
ora....E2.lsnr application    ONLINE    ONLINE    zracnode2   
ora....de2.gsd application    OFFLINE   OFFLINE               
ora....de2.ons application    ONLINE    ONLINE    zracnode2   
ora....de2.vip ora....t1.type ONLINE    ONLINE    zracnode2   

3.查看voting disk状态

[grid@Zracnode1 ~]$ crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   037fa1b3947b4f69bffeaa7849962d93 (ORCL:CRS1) [CRS]
 2. ONLINE   03d84e4b0c5f4fb6bf23f7efc3343772 (ORCL:CRS2) [CRS]
 3. ONLINE   144aecbd6d974fd3bf82a6cc92dab079 (ORCL:CRS3) [CRS]
Located 3 voting disk(s).

4.查看OCR状态

[grid@Zracnode1 ~]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          3
         Total space (kbytes)     :     262120
         Used space (kbytes)      :       3180
         Available space (kbytes) :     258940
         ID                       :  158462834
         Device/File Name         :       +CRS
                                    Device/File integrity check succeeded
                                    Device/File not configured
                                    Device/File not configured
                                    Device/File not configured
                                    Device/File not configured
         Cluster registry integrity check succeeded
         Logical corruption check bypassed due to non-privileged user

5.查看asm磁盘组监听状态(Zracnode1用户)

[grid@Zracnode1 ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 07-APR-2016 16:10:21
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                25-MAR-2016 15:40:29
Uptime                    13 days 0 hr. 29 min. 52 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/Zracnode1/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.2.13.80)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.2.13.82)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "arpdb.arp.cn" has 1 instance(s).
  Instance "arpdb1", status READY, has 1 handler(s) for this service...
Service "arpdbXDB.arp.cn" has 1 instance(s).
  Instance "arpdb1", status READY, has 1 handler(s) for this service...
The command completed successfully

6.查看asm磁盘组监听状态(Zracnode2用户)

[grid@Zracnode2 ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 07-APR-2016 16:14:37
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                25-MAR-2016 15:40:31
Uptime                    13 days 0 hr. 34 min. 7 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/Zracnode2/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.2.13.81)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.2.13.83)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "arpdb.arp.cn" has 1 instance(s).
  Instance "arpdb2", status READY, has 1 handler(s) for this service...
Service "arpdbXDB.arp.cn" has 1 instance(s).
  Instance "arpdb2", status READY, has 1 handler(s) for this service...
The command completed successfully

以上检测,验证GI软件安装正常,下一章讲述asm磁盘组配置。

版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

分享:
数据库
使用钉钉扫一扫加入圈子
+ 订阅

分享数据库前沿,解构实战干货,推动数据库技术变革

其他文章