9、所有 Oracle 实例 —(数据库状态)
[oracle@rac1 ~]$ srvctl status database -d racdb
Instance racdb1 is running on node rac1
Instance racdb2 is running on node rac2
10、单个 Oracle 实例 —(特定实例的状态)
[oracle@rac1 ~]$ srvctl status instance -d racdb -i racdb1
Instance racdb1 is running on node rac1
[oracle@rac1 ~]$ srvctl status instance -d racdb -i racdb2
Instance racdb1 is running on node rac2
11、节点应用程序 —(状态)
[oracle@rac1 ~]$ srvctl status nodeapps
VIP rac1-vip is enabled
VIP rac1-vip is running on node: rac1
VIP rac2-vip is enabled
VIP rac2-vip is running on node: rac2
Network is enabled
Network is running on node: rac1
Network is running on node: rac2
GSD is disabled
GSD is not running on node: rac1
GSD is not running on node: rac2
ONS is enabled
ONS daemon is running on node: rac1
ONS daemon is running on node: rac2
eONS is enabled
eONS daemon is running on node: rac1
eONS daemon is running on node: rac2
12、节点应用程序 —(配置)
[oracle@rac1 ~]$ srvctl config nodeapps
VIP exists.:rac1
VIP exists.: /rac1-vip/192.168.44.78/255.255.255.0/eth0
VIP exists.:rac2
VIP exists.: /rac2-vip/192.168.44.79/255.255.255.0/eth0
GSD exists.
ONS daemon exists. Local port 6100, remote port 6200
eONS daemon exists. Multicast port 22492, multicast IP address 234.236.221.152, listening port 2016
13、列出配置的所有数据库
[oracle@rac1 ~]$ srvctl config database
racdb
14、数据库 —(配置)
[oracle@rac1 ~]$ srvctl config database -d racdb -a
Database unique name: racdb
Database name: racdb
Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +RACDB_DATA/racdb/spfileracdb.ora
Domain: idevelopment.info
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: racdb
Database instances: racdb1,racdb2
Disk Groups: RACDB_DATA,FRA
Services:
Database is enabled
Database is administrator managed
15、ASM —(状态)
[oracle@rac1 ~]$ srvctl status asm
ASM is running on rac1,rac2
16、ASM —(配置)
[oracle@rac1 ~]$ srvctl config asm -a
ASM home: /u01/app/11.2.0/grid
ASM listener: LISTENER
ASM is enabled.
17、TNS 监听器 —(状态)
[oracle@rac1 ~]$ srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): rac1,rac2
18、TNS 监听器 —(配置)
[oracle@rac1 ~]$ srvctl config listener -a
Name: LISTENER
Network: 1, Owner: grid
Home:
/u01/app/11.2.0/grid on node(s) rac2,rac1
End points: TCP:1521
19、SCAN —(状态)
[oracle@rac1 ~]$ srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node rac2
20、SCAN —(配置)
[oracle@rac1 ~]$ srvctl config scan
SCAN name: rac-cluster-scan, Network: 1/192.168.44.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /rac-cluster-scan/192.168.44.177
21、VIP —(特定节点的状态)
[oracle@rac1 ~]$ srvctl status vip -n rac1
VIP rac1-vip is enabled
VIP rac1-vip is running on node: rac1
[oracle@rac1 ~]$ srvctl config vip -n rac2
VIP exists.:rac2
VIP exists.: /rac2-vip/192.168.44.79/255.255.255.0/eth0
22、VIP —(特定节点的配置)
[oracle@rac1 ~]$ srvctl config vip -n rac1
VIP exists.:rac1
VIP exists.: /rac1-vip/192.168.44.78/255.255.255.0/eth0
[oracle@rac1 ~]$ srvctl config vip -n rac2
VIP exists.:rac2
VIP exists.: /rac2-vip/192.168.44.79/255.255.255.0/eth0
23、节点应用程序配置 —(VIP、GSD、ONS、监听器)
[oracle@rac1 ~]$ srvctl config nodeapps -a -g -s -l
-l option has been deprecated and will be ignored.
VIP exists.:rac1
VIP exists.: /rac1-vip/192.168.44.78/255.255.255.0/eth0
VIP exists.:rac2
VIP exists.: /rac2-vip/192.168.44.79/255.255.255.0/eth0
GSD exists.
ONS daemon exists. Local port 6100, remote port 6200
Name: LISTENER
Network: 1, Owner: grid
Home:
/u01/app/11.2.0/grid on node(s) rac2,rac1
End points: TCP:1521
24、验证所有集群节点间的时钟同步
[oracle@rac1 ~]$ cluvfy comp clocksync -verbose
[@more@]来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25837813/viewspace-1052001/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25837813/viewspace-1052001/