[ To find database version - oracle (rac), tibero, mysql ]
Software | Version check |
ORACLE | sqlplus -V | grep Release | awk '{ print $3 }' |
ORACLE RAC | ${DBIN_DIR}/crsctl query crs
softwareversion | grep Clusterware | head -1 | awk '{ print $NF }' | tr -d
'[]' (Oracle 12 or higher) ${DBIN_DIR}/crsctl query has softwareversion | grep "High Availability" | awk '{ print $NF }' | tr -d '[]' |
TIBERO | tbsql -v | grep tbSQL | awk '{
print $2,$3 }' |
MySQL | mysql --version | egrep -i
'mysql|ver' | awk '{ print $3, $5 }' | tr -d ',' |
No comments:
Post a Comment