Common oracle 11g RAC commands

1) Check the cluster status:
[Grid @ rac02 ~] $ Crsctl check cluster
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online.

2) All Oracle instances (Database status ):
[Grid @ rac02 ~] $ Srvctl status database-d racdb
Instance racdb1 is running on node rac01
Instance racdb2 is running on node rac02

3) Check the status of a single instance:
[Grid @ rac02 ~] $ Srvctl status instance-d racdb-I racdb1
Instance racdb1 is running on node rac01

4) node Application Status:
[Grid @ rac02 ~] $ Srvctl status nodeapps
VIP rac01-vip is enabled
The VIP rac01-vip is running on node: rac01
VIP rac02-vip is enabled
The VIP rac02-vip is running on node: rac02
Network is enabled
Network is running on node: rac01
Network is running on node: rac02
GSD is disabled
GSD is not running on node: rac01
GSD is not running on node: rac02
ONS is enabled
ONS daemon is running on node: rac01
ONS daemon is running on node: rac02
EONS is enabled
EONS daemon is running on node: rac01
EONS daemon is running on node: rac02

5) list all configuration databases:
[Grid @ rac02 ~] $ Srvctl config database
Racdb

6) Database Configuration:
[Grid @ rac02 ~] $ Srvctl config database-d racdb-
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: xzxj.edu.cn
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

7). ASM status and ASM Configuration:
[Grid @ rac02 ~] $ Srvctl status asm
ASM is running on rac01, rac02
[Grid @ rac02 ~] $ Srvctl config asm-
ASM home:/u01/app/11.2.0/grid
ASM listener: LISTENER
ASM is enabled.

8). TNS Listener status and Configuration:
[Grid @ rac02 ~] $ Srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node (s): rac01, rac02
[Grid @ rac02 ~] $ Srvctl config listener-
Name: LISTENER
Network: 1, Owner: grid
Home: <CRS home>
/U01/app/11.2.0/grid on node (s) rac02, rac01
End points: TCP: 1521

9) SCAN status and Configuration:
[Grid @ rac02 ~] $ Srvctl status scan
Scan vip scan1 is enabled
Scan vip scan1 is running on node rac02
[Grid @ rac02 ~] $ Srvctl config scan
SCAN name: rac-scan.xzxj.edu.cn, Network: 1/192. 168.1.0/255.255.255.0/eth0
Scan vip name: scan1, IP:/rac-scan.xzxj.edu.cn/192.168.1.55

10) status and configuration of each VIP node:
[Grid @ rac02 ~] $ Srvctl status vip-n rac01
VIP rac01-vip is enabled
The VIP rac01-vip is running on node: rac01
[Grid @ rac02 ~] $ Srvctl status vip-n rac02
VIP rac02-vip is enabled
The VIP rac02-vip is running on node: rac02
[Grid @ rac02 ~] $ Srvctl config vip-n rac01
VIP exists.: rac01
VIP exists.:/rac01-vip/192.168.1.53/255.255.255.0/eth0
[Grid @ rac02 ~] $ Srvctl config vip-n rac02
VIP exists.: rac02
VIP exists.:/rac02-vip/192.168.1.54/255.255.255.0/eth0

11) node application configuration-(VIP, GSD, ONS, listener)
[Grid @ rac02 ~] $ Srvctl config nodeapps-a-g-s-l
-L option has been deprecated and will be ignored.
VIP exists.: rac01
VIP exists.:/rac01-vip/192.168.1.53/255.255.255.0/eth0
VIP exists.: rac02
VIP exists.:/rac02-vip/192.168.1.54/255.255.255.0/eth0
GSD exists.
ONS daemon exists. Local port 6100, remote port 6200
Name: LISTENER
Network: 1, Owner: grid
Home: <CRS home>
/U01/app/11.2.0/grid on node (s) rac02, rac01
End points: TCP: 1521

12) Verify the clock synchronization between all cluster nodes:
[Grid @ rac02 ~] $ Cluvfy comp clocksync-verbose
Verifying Clock Synchronization into ss the cluster nodes
Checking if Clusterware is installed on all nodes...
Check of Clusterware install passed
Checking if CTSS Resource is running on all nodes...
Check: CTSS Resource running on all nodes
Node Name Status
------------------------------------------------------------
Rac02 passed
Result: CTSS resource check passed
Querying CTSS for time offset on all nodes...
Result: Query of CTSS for time offset passed
Check CTSS state started...
Check: CTSS state
Node Name State
------------------------------------------------------------
Rac02 Active
CTSS is in Active state. Proceeding with check of clock time offsets on all nodes...
Reference Time Offset Limit: 1000.0 msecs
Check: Reference Time Offset
Node Name Time Offset Status
------------------------------------------------------------
Rac02 0.0 passed
Time offset is within the specified limits on the following set of nodes:
"[Rac02]"
Result: Check of clock time offsets passed
Oracle Cluster Time Synchronization Services check passed
Verification of Clock Synchronization within ss the cluster nodes was successful.

13). 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;
14). All database files and Their ASM disk groups-(SQL ):
15). ASM disk volume:
16) start and stop a cluster:
The following operations must be performed by the root user.
(1) Stop the Oracle Clusterware system on the local server:
[Root @ rac01 ~] #/U01/app/11.2.0/grid/bin/crsctl stop cluster

　Note:After running the "crsctl stop cluster" command, if
If any of the resources is still running, the entire command fails. Use the-f option to unconditionally stop all resources and
Stop the Oracle Clusterware system.
In addition, you can disable Oracle Clusterware on all servers in the cluster by specifying the-all option.
System. Stop the oracle clusterware System on rac01 and rac02 as follows:
[Root @ rac02 ~] #/U01/app/11.2.0/grid/bin/crsctl stop cluster-all
Start the oralce clusterware system on the local server:
[Root @ rac01 ~] #/U01/app/11.2.0/grid/bin/crsctl start cluster
Note: You can specify the-all option to start the Oracle Clusterware system on all servers in the cluster.
[Root @ rac02 ~] #/U01/app/11.2.0/grid/bin/crsctl start cluster-all
You can also list one or more specified

Start the Oracle ware terware system on the server:
[Root @ rac01 ~] #/U01/app/11.2.0/grid/bin/crsctl start cluster-n rac01 rac02
Use SRVCTL to start/stop all instances:
[Oracle @ rac01 ~] # Srvctl stop database-d racdb
[Oracle @ rac01 ~] # Srvctl start database-d racdb