查看oceanbase的license信息

[root@lnob bin]# obclient -h192.168.207.28 -P2881 -uroot@sys -pxxxxxx. -A -Doceanbase
Welcome to the OceanBase.  Commands end with ; or \g.
Your OceanBase connection id is 3221600926
Server version: OceanBase 4.2.5.4 (r104030022025070212-37927c3517f028002a34b40302f78cce88afdbd9) (Built Jul  2 2025 12:21:09)

Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

obclient(root@sys)[oceanbase]> show tables like '%LICENSE%';
+---------------------------------+
| Tables_in_oceanbase (%LICENSE%) |
+---------------------------------+
| DBA_OB_LICENSE                  |
| __all_license                   |
+---------------------------------+
2 rows in set (0.006 sec)

obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.__all_license;
+------------+------------+--------------+--------------+--------------+----------------------------+----------------------------+----------------------------+-----------+----------+----------+----------------------------+----------------------------+
| LICENSE_ID | END_USER   | LICENSE_CODE | LICENSE_TYPE | PRODUCT_TYPE | ISSUANCE_DATE              | ACTIVATION_TIME            | EXPIRED_TIME               | OPTIONS   | CORE_NUM | NODE_NUM | LTS_TIME                   | CLUSTER_ULID               |
+------------+------------+--------------+--------------+--------------+----------------------------+----------------------------+----------------------------+-----------+----------+----------+----------------------------+----------------------------+
| Trial ID   | Trial User | Trial Code   | Trial        | SE           | 2025-07-22 14:43:30.772011 | 2025-07-22 14:43:30.772011 | 2026-01-18 14:43:30.772011 | Unlimited |     9999 |        1 | 2025-08-11 10:47:52.015326 | 06C31QW1AKJAFWM2CR6R9QQZR8 |
+------------+------------+--------------+--------------+--------------+----------------------------+----------------------------+----------------------------+-----------+----------+----------+----------------------------+----------------------------+
1 row in set (0.002 sec)

obclient(root@sys)[oceanbase]> SELECT * FROM DBA_OB_LICENSE;
+------------+------------+--------------+--------------+--------------+---------------------+---------------------+---------------------+-----------+----------+----------------------------+
| END_USER   | LICENSE_ID | LICENSE_CODE | LICENSE_TYPE | PRODUCT_TYPE | ISSUANCE_DATE       | ACTIVATION_TIME     | EXPIRED_TIME        | OPTIONS   | NODE_NUM | CLUSTER_ULID               |
+------------+------------+--------------+--------------+--------------+---------------------+---------------------+---------------------+-----------+----------+----------------------------+
| Trial User | Trial ID   | Trial Code   | Trial        | SE           | 2025-07-22 14:43:30 | 2025-07-22 14:43:30 | 2026-01-18 14:43:30 | Unlimited |        1 | 06C31QW1AKJAFWM2CR6R9QQZR8 |
+------------+------------+--------------+--------------+--------------+---------------------+---------------------+---------------------+-----------+----------+----------------------------+
1 row in set (0.001 sec)

https://www.oceanbase.com/docs/common-oceanbase-database-standalone-1000000003577290

加载 License

获取 License 文件之后，您可以通过 ALTER SYSTEM LOAD LICENSE 语句加载 License。

1. 使用 sys 租户登录数据库。

   obclient -hxxx.xxx.xxx.xxx -P2881 -uroot -p****** -Doceanbase -A
   

2. 查看 License 信息。

   您可以查询 DBA_OB_LICENSE 查看当前 License 详细内容。

   obclient> select * from DBA_OB_LICENSE;
   

3. 加载 license。

   obclient> ALTER SYSTEM LOAD LICENSE <license_file_path>;
   

   说明

   license_file_path必填项，代表 License 文件的路径。

   示例如下。

   obclient(root@(none))[oceanbase]> alter system load license "/data/OceanBase.lic";
   Query OK, 0 rows affected (0.012 sec)
   

4. 查看 license 信息。

   obclient> select * from DBA_OB_LICENSE;