View the database version

You can connect to the database from a client and check the database version information. If you cannot obtain database version information after logging on to the database by using other tools, try the following methods:

• MySQL mode

  Log on to the console as the administrator and run the following command to check the database version:

  obclient> select version();
  +-----------+
  | version() |
  +-----------+
  | 2.2.75    |
  +-----------+
  1 row in set (0.01 sec)
  

• Oracle mode

  Log on to the console as the administrator and run the following command to check the database version:

  obclient> select * from v$version;
  +----------------------------------------------------------------------------------------------------------+--------+
  | BANNER          | CON_ID |
  +----------------------------------------------------------------------------------------------------------+--------+
  | OceanBase 2.2.75 (r20210107182621-81357ec10e1342ef9f9e993ea38ef1cdd8778cf6) (Built Jan  7 2021 18:54:53) |      0 |
  +----------------------------------------------------------------------------------------------------------+--------+
  1 row in set (0.01 sec)