How to Find Clusterware Configuration Details Using srvctl

1 min read
Oct 23, 2019

At times, you may be required to gather information about Oracle Clusterware configuration details. Instead of running multiple commands, information can be gathered using one simple command. This should work with srvctl version: 18.0.0.0.0 or higher.
 oracle@ol7-19-rac2 ~]$ echo $ORACLE_HOME
 /u01/app/19.0.0/grid
 
 [oracle@ol7-19-rac2 ~]$ srvctl -version
 srvctl version: 19.0.0.0.0
 
 [oracle@ol7-19-rac2 ~]$ srvctl config all
 
 Oracle Clusterware configuration details
 ========================================
 
 Oracle Clusterware basic information
 ------------------------------------
 Operating system Linux
 Name ol7-19-cluster
 Class STANDALONE
 Cluster nodes ol7-19-rac1, ol7-19-rac2
 Version 19.0.0.0.0
 Groups SYSOPER: SYSASM:dba SYSRAC:dba SYSDBA:dba
 OCR locations +DATA
 Voting disk locations DATA
 Voting disk file paths /dev/oracleasm/asm-disk3
 
 Cluster network configuration details
 -------------------------------------
 Interface name Type Subnet Classification
 eth1 IPV4 192.168.56.0/24 PUBLIC
 eth2 IPV4 192.168.1.0/24 PRIVATE, ASM
 
 SCAN configuration details
 --------------------------
 
 SCAN "ol7-19-scan" details
 ++++++++++++++++++++++++++
 Name ol7-19-scan
 IPv4 subnet 192.168.56.0/24
 DHCP server type static
 End points TCP:1521
 
 SCAN listeners
 --------------
 Name VIP address
 LISTENER_SCAN1 192.168.56.105
 LISTENER_SCAN2 192.168.56.106
 LISTENER_SCAN3 192.168.56.107
 
 ASM configuration details
 -------------------------
 Mode remote
 Password file +DATA
 SPFILE +DATA
 
 ASM disk group details
 ++++++++++++++++++++++
 Name Redundancy
 DATA EXTERN
 
 Database configuration details
 ==============================
 
 Database "ora.cdbrac.db" details
 --------------------------------
 Name ora.cdbrac.db
 Type RAC
 Version 19.0.0.0.0
 Role PRIMARY
 Management AUTOMATIC
 policy
 SPFILE +DATA
 Password file +DATA
 Groups OSDBA:dba OSOPER:oper OSBACKUP:dba OSDG:dba OSKM:dba OSRAC:dba
 Oracle home /u01/app/oracle/product/19.0.0/dbhome_1
 [oracle@ol7-19-rac2 ~]$
 
In summary, srvctl config all should make a DBA's life a little easier.

Get Email Notifications

No Comments Yet

Let us know what you think