达梦8-License授权更新

替换达梦bin目录的dm.key(新证书)

cd /data/dameng8/app/bin
mv dm.key dm.key.origin

mv dmEB01108787_2.key dm.key
chown dmdba.dinstall dm.key

CLI登陆数据库

# ./disql
disql V8
用户名:SYSDBA
密码:

服务器[LOCALHOST:5236]:处于主库打开状态
登录使用时间 : 3.141(ms)
上次登录ip       : ::ffff:127.0.0.1
上次登录时间   : 2023-05-06 11:31:30
登录失败次数   : 0
口令是否过期   : 未过期

查看当前授权

SQL>  SELECT * FROM V$LICENSE;

行号     LIC_VERSION SERIES_NO  SERVER_SERIES SERVER_TYPE SERVER_VER EXPIRED_DATE AUTHORIZED_CUSTOMER      AUTHORIZED_USER_NUMBER CONCURRENCY_USER_NUMBER MAX_CPU_NUM NOACTIVE_DEADLINE HARDWARE_ID CHECK_CODE       PRODUCT_TYPE
---------- ----------- ---------- ------------- ----------- ---------- ------------ ------------------------ ---------------------- ----------------------- ----------- ----------------- ----------- ---------------- ------------
           PROJECT_NAME             CPU_TYPE OS_TYPE MAX_CORE_NUM HARDWARE_TYPE CLUSTER_TYPE DATE_GEN   SERVER_SERIES_NAME TABLE_RECORD_NUMBER_LIMIT TOTAL_SPACE_LIMIT
           ------------------------ -------- ------- ------------ ------------- ------------ ---------- ------------------ ------------------------- -----------------
1          3.00        7301094985 A             3           DM_PRODUCT 2024-06-25   达梦公司产品试用 NULL                   NULL                    NULL        NULL                          36A7111E7363458C DM8
           达梦公司产品试用 Feiteng  Linux   NULL                       1111         2023-06-19 安全版          NULL                      NULL


已用时间: 1.911(毫秒). 执行号:131100.

刷新授权信息

SQL> SP_LOAD_LIC_INFO();
SQL> COMMIT;

查看更新后的授权信息

SQL>  SELECT * FROM V$LICENSE;

行号     LIC_VERSION SERIES_NO  SERVER_SERIES SERVER_TYPE SERVER_VER EXPIRED_DATE AUTHORIZED_CUSTOMER               AUTHORIZED_USER_NUMBER CONCURRENCY_USER_NUMBER MAX_CPU_NUM NOACTIVE_DEADLINE HARDWARE_ID CHECK_CODE
---------- ----------- ---------- ------------- ----------- ---------- ------------ --------------------------------- ---------------------- ----------------------- ----------- ----------------- ----------- ----------------
           PRODUCT_TYPE PROJECT_NAME                                                       CPU_TYPE OS_TYPE MAX_CORE_NUM HARDWARE_TYPE CLUSTER_TYPE DATE_GEN   SERVER_SERIES_NAME TABLE_RECORD_NUMBER_LIMIT TOTAL_SPACE_LIMIT
           ------------ ------------------------------------------------------------------ -------- ------- ------------ ------------- ------------ ---------- ------------------ ------------------------- -----------------
1          3.00        EB01108787 A             1           DM_PRODUCT NULL         xxxxxxxxxxxxxxxxxxxxxx NULL                   NULL                    2           NULL                          76758DE620CA403A
           DM8          xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx Feiteng  Linux   NULL                       1000         2023-12-25 安全版          NULL                      NULL


已用时间: 0.422(毫秒). 执行号:131103.