Oracle RAC 实施方案详细说明 - 安装后的检查 06

成都创新互联长期为近1000家客户提供的网站建设服务，团队从业经验10年，关注不同地域、不同群体，并针对不同对象提供差异化的产品和服务；打造开放共赢平台，与合作伙伴共同营造健康的互联网生态环境。为来宾企业提供专业的做网站、成都网站设计，来宾网站改版等技术服务。拥有10余年丰富建站经验和众多成功案例,为您定制开发。

查看数据库版本

SQL> select * from v$version;

查看集群名称

[root@rac01 bin]# ./cemutlo --help

[root@rac01 bin]# ./cemutlo -n

rac-cluster

[root@rac01 bin]# ./cemutlo -w

2:1:

查看集群状态

[root@rac01 ~]# cd /u01/app/11.2.0/grid/bin/

[root@rac01 bin]# ./crsctl check cluster -all

**************************************************************

rac01:

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

**************************************************************

rac02:

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

**************************************************************

查看资源状态

[root@rac01 bin]# ./crsctl stat res -t

查看 CRS 状态

[root@rac01 bin]# ./crsctl check crs

CRS-4638: Oracle High Availability Services is online

CRS-4537: Cluster Ready Services is online

CRS-4529: Cluster Synchronization Services is online

CRS-4533: Event Manager is online

查看OHASD 状态

[root@rac01 bin]# ./crsctl check has

CRS-4638: Oracle High Availability Services is online

禁用crs 自启动

[root@rac01 bin]# ./crsctl disable crs

CRS-4621: Oracle High Availability Services autostart is disabled.

[root@rac02 bin]# ./crsctl disable crs

CRS-4621: Oracle High Availability Services autostart is disabled.

查看 节点 信息

[root@rac01 bin]# ./olsnodes --help

[root@rac01 bin]# ./olsnodes

rac01

rac02

[root@rac01 bin]# ./olsnodes -c

rac-cluster

查看网络接口信息

[root@rac01 bin]# ./oifcfg --help

[root@rac01 bin]# ./oifcfg getif

eth0  192.168.31.0  global  public

eth2  10.10.10.0  global  cluster_interconnect

查看OCR 信息

[root@rac01 bin]# ./ocrcheck -config

Oracle Cluster Registry configuration is :

 Device/File Name         :       +OCR

[root@rac01 bin]# ./ocrcheck

查看olr 信息

[root@rac01 bin]# ./ocrcheck -local

检查OCR 完整性

[grid@rac01 ~]$ cluvfy comp ocr -n all -verbose

查看votedisk 信息

[root@rac01 bin]# ./crsctl query css votedisk

查看数据库信息

[root@rac01 bin]# ./srvctl config database

cjcdb

[root@rac01 bin]# ./srvctl config database -d cjcdb -a

[root@rac01 bin]# ./srvctl status database -d cjcdb

Instance cjcdb1 is running on node rac01

Instance cjcdb2 is running on node rac02

[root@rac01 bin]# ./srvctl status database -d cjcdb -v

Instance cjcdb1 is running on node rac01. Instance status: Open.

Instance cjcdb2 is running on node rac02. Instance status: Open.

查看SCAN 配置

[root@rac01 bin]# ./srvctl config scan

SCAN name: rac-scan.cjc.com, Network: 1/192.168.31.0/255.255.255.0/eth0

SCAN VIP name: scan1, IP: /rac-scan.cjc.com/192.168.31.60

SCAN VIP name: scan2, IP: /rac-scan.cjc.com/192.168.31.70

SCAN VIP name: scan3, IP: /rac-scan.cjc.com/192.168.31.50

查看DNS 解析

[root@rac01 bin]# nslookup rac-scan.cjc.com

Server:   192.168.31.90

Address: 192.168.31.90#53

Name: rac-scan.cjc.com

Address: 192.168.31.70

Name: rac-scan.cjc.com

Address: 192.168.31.50

Name: rac-scan.cjc.com

Address: 192.168.31.60

查看SCAN VIP 状态

[root@rac01 bin]# ./srvctl status scan

SCAN VIP scan1 is enabled

SCAN VIP scan1 is running on node rac02

SCAN VIP scan2 is enabled

SCAN VIP scan2 is running on node rac01

SCAN VIP scan3 is enabled

SCAN VIP scan3 is running on node rac01

显示SCAN 监听器的状态

[root@rac01 bin]# ./srvctl status scan_listener

SCAN Listener LISTENER_SCAN1 is enabled

SCAN listener LISTENER_SCAN1 is running on node rac02

SCAN Listener LISTENER_SCAN2 is enabled

SCAN listener LISTENER_SCAN2 is running on node rac01

SCAN Listener LISTENER_SCAN3 is enabled

SCAN listener LISTENER_SCAN3 is running on node rac01

查看服务器IP

[root@rac01 bin]# ifconfig 

查看ASM 配置

[root@rac01 bin]# ./srvctl config asm

ASM home: /u01/app/11.2.0/grid

ASM listener: LISTENER

查看监听配置

[root@rac01 bin]# ./srvctl config listener

Name: LISTENER

Network: 1, Owner: grid

Home:

End points: TCP:1521

查看节点状态

[root@rac01 bin]# ./srvctl status nodeapps -n rac01

VIP rac01-vip is enabled

VIP rac01-vip is running on node: rac01

Network is enabled

Network is running on node: rac01

GSD is disabled

GSD is not running on node: rac01

ONS is enabled

ONS daemon is running on node: rac01

[root@rac01 bin]# ./srvctl status nodeapps -n rac02

VIP rac02-vip is enabled

VIP rac02-vip is running on node: rac02

Network is enabled

Network is running on node: rac02

GSD is disabled

GSD is not running on node: rac02

ONS is enabled

ONS daemon is running on node: rac02