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

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 eth1  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"，共同学习，共同成长！！！