How to Find Clusterware Configuration Details Using srvctl

Posted in: Technical Track

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.

email

Interested in working with Michael? Schedule a tech call.

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *