本文主要描述如何查看 OceanBase 数据库相关的版本号。
适用版本
OceanBase 数据库所有版本。
查看 OBClient 的版本号
$ obclient -V
$ obclient --version
$ rpm -qa | grep obclient
查看 MySQL 的版本号
$ mysql -V
$ mysql --version
$ rpm -qa | grep -i mysql
$ rpm -qa | grep -i mariadb
查看 OBServer 的版本号
在 OceanBase 数据库安装目录下执行以下命令，查看 OBServer 的版本号。
$ ./bin/observer -V
$ ./bin/observer --version
$ rpm -qa | grep oceanbase
查看 OBProxy 的版本号
在 OBProxy 安装目录下执行以下命令，查看 OBProxy 的版本号。
$ ./bin/obproxy -V $ ./bin/obproxy --version $ rpm -qa | grep obproxy通过 OBProxy 连接到 OceanBase 数据库集群中，再执行如下命令查看 OBProxy 的版本号。
obclient [(none)]> show proxyinfo binary;
查看 OceanBase 数据库 MySQL 模式的租户
obclient [(none)]> show variables like '%version%';
返回结果如下：
+-------------------------+--------------------------------------------------------------------------------------------------------------+
| Variable_name | Value |
+-------------------------+--------------------------------------------------------------------------------------------------------------+
| ob_last_schema_version | 0 |
| protocol_version | 10 |
| tls_version | |
| version | 2.2.77 |
| version_comment | OceanBase 2.2.77 (r116000022023021412-638d42711aaf1deed0370ac9fb944a3d56b46cf6) (Built Feb 14 2023 12:57:49) |
| version_compile_machine | |
| version_compile_os | |
+-------------------------+--------------------------------------------------------------------------------------------------------------+
7 rows in set (0.001 sec)
obclient [(none)]> select @@version,@@version_comment from dual;
返回结果如下：
+-----------+--------------------------------------------------------------------------------------------------------------+
| @@version | @@version_comment |
+-----------+--------------------------------------------------------------------------------------------------------------+
| 2.2.77 | OceanBase 2.2.77 (r116000022023021412-638d42711aaf1deed0370ac9fb944a3d56b46cf6) (Built Feb 14 2023 12:57:49) |
+-----------+--------------------------------------------------------------------------------------------------------------+
1 row in set (0.001 sec)
obclient [(none)]> select version() from dual;
返回结果如下：
+-----------+
| version() |
+-----------+
| 2.2.77 |
+-----------+
1 row in set (0.001 sec)
obclient [(none)]> select ob_version();
返回结果如下：
+--------------+
| ob_version() |
+--------------+
| 2.2.77 |
+--------------+
1 row in set (0.000 sec)
查看 OceanBase 数据库 Oracle 模式的租户
obclient [SYS]> show variables like '%version%';
返回结果如下：
+-------------------------+--------------------------------------------------------------------------------------------------------------+
| VARIABLE_NAME | VALUE |
+-------------------------+--------------------------------------------------------------------------------------------------------------+
| ob_last_schema_version | 0 |
| protocol_version | 10 |
| tls_version | NULL |
| version | 2.2.77 |
| version_comment | OceanBase 2.2.77 (r116000022023021412-638d42711aaf1deed0370ac9fb944a3d56b46cf6) (Built Feb 14 2023 12:57:49) |
| version_compile_machine | NULL |
| version_compile_os | NULL |
+-------------------------+--------------------------------------------------------------------------------------------------------------+
7 rows in set (0.008 sec)
obclient [SYS]> select @@version,@@version_comment from dual;
返回结果如下：
+-----------+--------------------------------------------------------------------------------------------------------------+
| @@VERSION | @@VERSION_COMMENT |
+-----------+--------------------------------------------------------------------------------------------------------------+
| 2.2.77 | OceanBase 2.2.77 (r116000022023021412-638d42711aaf1deed0370ac9fb944a3d56b46cf6) (Built Feb 14 2023 12:57:49) |
+-----------+--------------------------------------------------------------------------------------------------------------+
1 row in set (0.001 sec)
obclient [SYS]> select * from v$version;
返回结果如下：
+--------------------------------------------------------------------------------------------------------------+--------+
| BANNER | CON_ID |
+--------------------------------------------------------------------------------------------------------------+--------+
| OceanBase 2.2.77 (r116000022023021412-638d42711aaf1deed0370ac9fb944a3d56b46cf6) (Built Feb 14 2023 12:57:49) | 0 |
+--------------------------------------------------------------------------------------------------------------+--------+
1 row in set (0.002 sec)
obclient [SYS]> select version from v$instance;
返回结果如下：
+-------------+
| VERSION |
+-------------+
| 2.2.77_1160 |
+-------------+
1 row in set (0.014 sec)
