Status of all instances and services $ srvctl status database -d orcl Instance orcl1 is running on node linux1 Instance orcl2 is running on node linux2 Status of a single instance $ srvctl status instance -d orcl -i orcl2 Instance orcl2 is running on node linux2 Status of a named service globally across the database $ srvctl status service -d orcl -s orcltest Service orcltest is running on instance(s) orcl2, orcl1 Status of node applications on a particular node $ srvctl status nodeapps -n linux1 VIP is running on node: linux1 GSD is running on node: linux1 Listener is running on node: linux1 ONS daemon is running on node: linux1 Status of an ASM instance $ srvctl status asm -n linux1 ASM instance +ASM1 is running on node linux1. List all configured databases $ srvctl config database orcl Display configuration for our RAC database $ srvctl config database -d orcl linux1 orcl1 /u01/app/oracle/product/10.2.0/db_1 linux2 orcl2 /u01/app/oracle/product/10.2.0/db_1 Display all services for the specified cluster database $ srvctl config service -d orcl orcltest PREF: orcl2 orcl1 AVAIL: isplay the configuration for node applications - (VIP, GSD, ONS, Listener) $ srvctl config nodeapps -n linux1 -a -g -s -l VIP exists.: /vip-linux1/192.168.1.200/255.255.255.0/eth0:eth1 GSD exists. ONS daemon exists. Listener exists. Display the configuration for the ASM instance(s) $ srvctl config asm -n linux1 +ASM1 /u01/app/oracle/product/10.2.0/db_1 All running instances in the cluster SQL> SELECT inst_id , instance_number inst_no , instance_name inst_name , parallel , status , database_status db_status , active_state state , host_name host FROM gv$instance ORDER BY inst_id;
The following two tabs change content below.