查看数据库版本
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
查看资源状态
[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
查看DNS解析
[root@rac01 bin]# nslookup rac-scan.cjc.com
查看SCAN VIP状态
[root@rac01 bin]# ./srvctl status scan
显示SCAN监听器的状态
[root@rac01 bin]# ./srvctl status scan_listener
查看服务器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
更多数据库相关学习资料，可以查看我的ITPUB博客，网名chenoracle：
http://blog.itpub.net/29785807/
