达梦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.