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

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磁盘组配置。

阅读(2219) | 评论(0) | 转发(0) |