Check Software version and Patch level of Clusterware
CRSCTL is used to manages the clusterware resources. You can also check the software version and patch level of your grid home with CRSCTL utility. CRSCTL utility present in $GRID_HOME\bin directory.
CHECK ACTIVE VERSION OF CLUSTERWARE
crsctl query crs activeversion command to display the active version and the configured patch level of the Oracle Clusterware software running in the cluster. During a rolling upgrade the active version is not changed until the upgrade is finished across the cluster.
CRSCTL QUERY CRS ACTIVEVERSION
Output:
Oracle Clusterware active version on the cluster is [12.1.0.0.2]. The cluster upgrade state is [NORMAL]. The cluster active patch level is [456789126].
CHECK PATCH LEVEL OF CLUSTERWARE
crsctl query crs releasepatch command to display the patch level which is updated in the Grid home patch repository while patching a node.
The patch level corresponds to only the local node in which the command is executed.
CRSCTL QUERY CRS RELEASEPATCH
Output:
Oracle Clusterware release patch level is [3180840333] and the complete list of patches is [13559647] on the local node.
CHECK VERSION OF THE ORACLE CLUSTERWARE SOFTWARE
crsctl query crs releaseversion command to display the version of the Oracle Clusterware software stored in the binaries on the local node.
CRSCTL QUERY CRS RELEASEVERSION
Output:
Oracle High Availability Services release version on the local node is [12.2.0.1.0]
CHECK PATCH LEVEL OF ORACLE CLUSTERWARE FOR SPECIFIC NODE
crsctl query crs softwarepatch command to display the configured patch level of the installed Oracle Clusterware.
CRSCTL QUERY CRS SOFTWAREPATCH [NODE_NAME]
Output:
Oracle Clusterware patch level on node [node1] is [456789126]
CHECK LATEST VERSION OF THE SOFTWARE RUNNING SUCCESSFULLY ON SPECIFIC NODE
crsctl query crs softwareversion command to display latest version of the software that has been successfully started on the specified node.
CRSCTL QUERY CRS SOFTWAREVERSION [NODE_NAME]
Output:
Oracle Clusterware version on node [node1] is [12.2.0.1.0]