如何查看 OceanBase 数据库相关的版本号-OceanBase数据库使用指南

本文主要描述如何查看 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)