TIBERO 버전 확인

TIBERO 데이터베이스의 버전 확인

---

SQL

SQL> SELECT * FROM V$VERSION;

NAME          |VALUE       |BANNER         |
--------------+------------+---------------+
PRODUCT_MAJOR |6           |               |
PRODUCT_MINOR |            |               |
BUILD_NUMBER  |200518      |               |
PROTOCOL_MAJOR|2           |               |
PROTOCOL_MINOR|16          |               |
SHM_VERSION   |0x20020410  |               |
STABLE_VERSION|FS07_CS_2005|LINUX_X86_64bit|

SQL> SELECT * FROM VT_VERSION;
NAME          |VALUE       |BANNER         |
--------------+------------+---------------+
PRODUCT_MAJOR |6           |               |
PRODUCT_MINOR |            |               |
BUILD_NUMBER  |200518      |               |
PROTOCOL_MAJOR|2           |               |
PROTOCOL_MINOR|16          |               |
SHM_VERSION   |0x20020410  |               |
STABLE_VERSION|FS07_CS_2005|LINUX_X86_64bit|

SQL> SELECT * FROM GV$VERSION;
INST_ID|NAME          |VALUE       |BANNER         |
-------+--------------+------------+---------------+
       |PRODUCT_MAJOR |6           |               |
       |PRODUCT_MINOR |            |               |
       |BUILD_NUMBER  |200518      |               |
       |PROTOCOL_MAJOR|2           |               |
       |PROTOCOL_MINOR|16          |               |
       |SHM_VERSION   |0x20020410  |               |
       |STABLE_VERSION|FS07_CS_2005|LINUX_X86_64bit|
       
SQL> SELECT * FROM V$INSTANCE;
INSTANCE_NUMBER|INSTANCE_NAME|DB_NAME|HOST_NAME   |PARALLEL|THREAD#|VERSION|STARTUP_TIME|STATUS|SHUTDOWN_PENDING|TIP_FILE                         |
---------------+-------------+-------+------------+--------+-------+-------+------------+------+----------------+---------------------------------+
              0|tibero       |tibero |ad8772d8134e|NO      |      0|6      |  2022-10-05|NORMAL|NO              |/tibero/tibero6/config/tibero.tip|

 

Command

[tibero@ad8772d8134e ~]$ tbboot -version

Tibero 6   (DB 6.0 FS07_CS_2005)
Linux linux64-2016 3.10.0-327.el7.x86_64 #1 SMP Thu Nov 19 22:10:57 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux version (little-endian)

[tibero@ad8772d8134e ~]$ tbboot -cs     

FS07_CS_2005 (build 200518)

---

---