--- title: 如何查看 OceanBase 数据库相关的版本号-OceanBase数据库使用指南 description: 了解OceanBase数据库在实际应用中关于如何查看 OceanBase 数据库相关的版本号相关的常见问题和使用技巧，帮助您快速解决如何查看 OceanBase 数据库相关的版本号的难题。 --- 切换语言 - 中文站 - 简体中文 - International - English - 日本站 - 日本語 划线反馈 # 如何查看 OceanBase 数据库相关的版本号 更新时间：2026-06-01 09:21 适用版本： V2.2.x、V3.1.x、V3.2.x、V4.0.x、V4.1.x、V4.2.x 内容类型：How-to 本文主要描述如何查看 OceanBase 数据库相关的版本号。 ## 适用版本 OceanBase 数据库所有版本。 ## 查看 OBClient 的版本号 ```shell $ obclient -V $ obclient --version $ rpm -qa | grep obclient ``` ## 查看 MySQL 的版本号 ```shell $ mysql -V $ mysql --version $ rpm -qa | grep -i mysql $ rpm -qa | grep -i mariadb ``` ## 查看 OBServer 的版本号 在 OceanBase 数据库安装目录下执行以下命令，查看 OBServer 的版本号。 ```shell $ ./bin/observer -V $ ./bin/observer --version $ rpm -qa | grep oceanbase ``` ## 查看 OBProxy 的版本号 - 在 OBProxy 安装目录下执行以下命令，查看 OBProxy 的版本号。 ```shell $ ./bin/obproxy -V $ ./bin/obproxy --version $ rpm -qa | grep obproxy ``` - 通过 OBProxy 连接到 OceanBase 数据库集群中，再执行如下命令查看 OBProxy 的版本号。 ```shell obclient [(none)]> show proxyinfo binary; ``` ## 查看 OceanBase 数据库 MySQL 模式的租户 ```shell obclient [(none)]> show variables like '%version%'; ``` 返回结果如下： ```shell +-------------------------+--------------------------------------------------------------------------------------------------------------+ | 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) ``` ```shell obclient [(none)]> select @@version,@@version_comment from dual; ``` 返回结果如下： ```shell +-----------+--------------------------------------------------------------------------------------------------------------+ | @@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) ``` ```shell obclient [(none)]> select version() from dual; ``` 返回结果如下： ```shell +-----------+ | version() | +-----------+ | 2.2.77 | +-----------+ 1 row in set (0.001 sec) ``` ```shell obclient [(none)]> select ob_version(); ``` 返回结果如下： ```shell +--------------+ | ob_version() | +--------------+ | 2.2.77 | +--------------+ 1 row in set (0.000 sec) ``` ## 查看 OceanBase 数据库 Oracle 模式的租户 ```shell obclient [SYS]> show variables like '%version%'; ``` 返回结果如下： ```shell +-------------------------+--------------------------------------------------------------------------------------------------------------+ | 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) ``` ```shell obclient [SYS]> select @@version,@@version_comment from dual; ``` 返回结果如下： ``` ```shell obclient [SYS]> select * from v$version; ``` 返回结果如下： ```shell +--------------------------------------------------------------------------------------------------------------+--------+ | BANNER | CON_ID | +--------------------------------------------------------------------------------------------------------------+--------+ | OceanBase 2.2.77 (r116000022023021412-638d42711aaf1deed0370ac9fb944a3d56b46cf6) (Built Feb 14 2023 12:57:49) | 0 | +--------------------------------------------------------------------------------------------------------------+--------+ 1 row in set (0.002 sec) ``` ```shell obclient [SYS]> select version from v$instance; ``` 返回结果如下： ```shell +-------------+ | VERSION | +-------------+ | 2.2.77_1160 | +-------------+ 1 row in set (0.014 sec) ``` 上一篇 [OceanBase 数据库风险排查指南](https://www.oceanbase.com/knowledge-base/oceanbase-database-20000001032) 下一篇 [OceanBase 产品版本生命周期](https://www.oceanbase.com/knowledge-base/oceanbase-database-1000000001497334) ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线