Monday, December 17, 2018

▷ To find database version (DB 버전 확인)

[ 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

◈ Recent Post

▷ UITest demo with TestOne (Mobile, Keypad and Drag until found tip)

[ UITest Demo Environment ] 1. UITest Solution: TestOne 2. Description 데모 설명    How to use keypad, and to drag until found.     키패드를...

◈ Popular Posts