Demandé par le support Oracle pour connaitre la version du Cluster Ready Service noeud par noeud, le passage des instructions crsctl query crs en masse peut être fastidieux. Voici donc une petite fonction bash pour obtenir les informations sous linux. Il faut bien sûr qu’elle soit lancée par l’utilisateur propriétaire de la grid-infrastructure et que la variable GI_HOME corresponde à son répertoire d’installation
function racCrsVersions {
for s in $(olsnodes)
do
echo ""
echo "===> $s"
echo ""
echo " - activeversion -f ==> $( ssh $s ${GI_HOME}/bin/crsctl query crs activeversion -f )"
echo " - softwareversion ==> $( ssh $s ${GI_HOME}/bin/crsctl query crs softwareversion )"
echo " - softwarepatch ==> $( ssh $s ${GI_HOME}/bin/crsctl query crs softwarepatch )"
echo " - releaseversion ==> $( ssh $s ${GI_HOME}/bin/crsctl query crs releaseversion )"
echo " - releasepatch ==> $( ssh $s ${GI_HOME}/bin/crsctl query crs releasepatch )"
done
}
Le résultat de la requête peut être le suivant :
===> racnode01 - activeversion -f ==> Oracle Clusterware active version on the cluster is [19.0.0.0.0]. The cluster upgrade state is [UPGRADE FINAL]. The cluster active patch level is [724960844]. - softwareversion ==> Oracle Clusterware version on node [racnode01] is [19.0.0.0.0] - softwarepatch ==> Oracle Clusterware patch level on node racnode01 is [724960844]. - releaseversion ==> Oracle High Availability Services release version on the local node is [19.0.0.0.0] - releasepatch ==> Oracle Clusterware release patch level is [724960844] and the complete list of patches [29401763 29517242 29517247 29585399 ] have been applied on the local node. The release patch string is [19.3.0.0.0]. ===> racnode02 - activeversion -f ==> Oracle Clusterware active version on the cluster is [19.0.0.0.0]. The cluster upgrade state is [UPGRADE FINAL]. The cluster active patch level is [724960844]. - softwareversion ==> Oracle Clusterware version on node [racnode02] is [19.0.0.0.0] - softwarepatch ==> Oracle Clusterware patch level on node racnode02 is [724960844]. - releaseversion ==> Oracle High Availability Services release version on the local node is [19.0.0.0.0] - releasepatch ==> Oracle Clusterware release patch level is [724960844] and the complete list of patches [29401763 29517242 29517247 29585399 ] have been applied on the local node. The release patch string is [19.3.0.0.0]. ===> racnode03 - activeversion -f ==> Oracle Clusterware active version on the cluster is [19.0.0.0.0]. The cluster upgrade state is [UPGRADE FINAL]. The cluster active patch level is [724960844]. - softwareversion ==> Oracle Clusterware version on node [racnode03] is [19.0.0.0.0] - softwarepatch ==> Oracle Clusterware patch level on node racnode03 is [724960844]. - releaseversion ==> Oracle High Availability Services release version on the local node is [19.0.0.0.0] - releasepatch ==> Oracle Clusterware release patch level is [724960844] and the complete list of patches [29401763 29517242 29517247 29585399 ] have been applied on the local node. The release patch string is [19.3.0.0.0].