Oracle RAC 实施方案详细说明 - 安装后的检查 06
查看数据库版本
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: <CRS 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
欢迎关注我的微信公众号"IT小Chen"，共同学习，共同成长！！！
