注册
安全版本数据库替换临时(正式)授权
专栏/技术分享/ 文章详情 /

安全版本数据库替换临时(正式)授权

竹蜻蜓vYv 2023/09/23 1822 2 0
摘要

1.初始化数据库放置安全版key:

1.1.查看现有授权,如果SERVER_SERIES_NAME值是安全版,说明数据库初始化实例之前已经放置安全版本key

19:12:26 SYSDBA@DAMENG:5236 SQL> select SERIES_NO,EXPIRED_DATE,PRODUCT_TYPE,SERVER_SERIES_NAME from v$license; SERIES_NO EXPIRED_DATE PRODUCT_TYPE SERVER_SERIES_NAME ---------- ------------ ------------ ------------------ 1C01091259 2024-03-25 DM8 安全版 已用时间: 1.403(毫秒). 执行号:806.

1.2.上传临时key(正式key)到DM_HOME/bin目录下

[root@yuanzj:/soft]$ chown -R dmdba.dinstall dm7301094992.key [root@yuanzj:/soft]$ cp -pr dm7301094992.key /opt/dmdbms/bin/dm.key cp:是否覆盖"/opt/dmdbms/bin/dm.key"? y [root@yuanzj:/soft]$ sd [dmdba@yuanzj:~]$ ds 服务器[LOCALHOST:5236]:处于普通打开状态 登录使用时间 : 14.818(ms) 上次登录ip : ::1 上次登录时间 : 2023-09-23 19:12:05 登录失败次数 : 0 口令是否过期 : 未过期 密钥过期时间:2024-03-25 disql V8 19:17:45 SYSDBA@DAMENG:5236 SQL> sp_load_lic_info(); DMSQL 过程已成功完成 已用时间: 0.888(毫秒). 执行号:904. 19:18:00 SYSDBA@DAMENG:5236 SQL> select SERIES_NO,EXPIRED_DATE,PRODUCT_TYPE,SERVER_SERIES_NAME from v$license; SERIES_NO EXPIRED_DATE PRODUCT_TYPE SERVER_SERIES_NAME ---------- ------------ ------------ ------------------ 7301094992 2024-06-25 DM8 安全版 已用时间: 0.312(毫秒). 执行号:905.

2.初始化数据库未放置安全key:

2.1.查看数据库使用授权类型(使用数据库出厂授权,如果SERVER_SERIES_NAME值是空值或者企业版,说明数据库初始化实例没有使用安全版本key,或者使用企业版本key)

19:21:23 SYSDBA@DAMENG:5236 SQL> select SERIES_NO,EXPIRED_DATE,PRODUCT_TYPE,SERVER_SERIES_NAME from v$license; SERIES_NO EXPIRED_DATE PRODUCT_TYPE SERVER_SERIES_NAME --------- ------------ ------------ ------------------ dm66n367 2024-05-24 DM8 已用时间: 1.068(毫秒). 执行号:58904.

2.2.使用企业版临时key(正式key)替换授权

[root@yuanzj:/soft]$ chown -R dmdba.dinstall dm7401094993.key [root@yuanzj:/soft]$ cp -pr dm7401094993.key /opt/dmdbms/bin/dm.key [root@yuanzj:/soft]$ sd [dmdba@yuanzj:~]$ ds 服务器[LOCALHOST:5236]:处于普通打开状态 登录使用时间 : 2.757(ms) 密钥过期时间:2024-05-24 disql V8 19:24:24 SYSDBA@DAMENG:5236 SQL> sp_load_lic_info(); DMSQL 过程已成功完成 已用时间: 0.894(毫秒). 执行号:59004. 19:24:34 SYSDBA@DAMENG:5236 SQL> select SERIES_NO,EXPIRED_DATE,PRODUCT_TYPE,SERVER_SERIES_NAME from v$license; SERIES_NO EXPIRED_DATE PRODUCT_TYPE SERVER_SERIES_NAME ---------- ------------ ------------ ------------------ 7401094993 2024-06-25 DM8 企业版 已用时间: 0.360(毫秒). 执行号:59005.

2.3.使用安全版临时key(正式key)替换授权

[root@yuanzj:/soft]$ chown -R dmdba.dinstall dm7301094992.key [root@yuanzj:/soft]$ cp -pr dm7301094992.key /opt/dmdbms/bin/dm.key cp:是否覆盖"/opt/dmdbms/bin/dm.key"? y [root@yuanzj:/soft]$ sd [dmdba@yuanzj:~]$ dmserver /dmdata/DAMENG/dm.ini upd_lic=1 version info: security DM Database Server 64 V8 05134283968-20230524-191261-20033 startup... Normal of FAST Normal of DEFAULT Normal of RECYCLE Normal of KEEP Normal of ROLL Database mode = 0, oguid = 0 License will expire on 2024-06-25 file lsn: 38860 ndct db load finished ndct second level fill fast pool finished ndct third level fill fast pool finished ndct second level fill fast pool finished ndct third level fill fast pool finished ndct fill fast pool finished pseg_set_gtv_trxid_low next_trxid in mem:[4008] pseg_collect_mgr_items, total collect 0 active_trxs, 0 cmt_trxs, 0 pre_cmt_trxs, 0 to_release_trxs, 0 active_pages, 0 cmt_pages, 0 pre_cmt_pages, 0 to_release_pages, 0 mgr pages, 0 mgr recs! next_trxid in mem:[5010] next_trxid = 6012. pseg recv finished nsvr_startup end. aud sys init success. aud rt sys init success. systables desc init success. ndct_db_load_info success. nsvr_process_before_open begin. nsvr_process_before_open success. SYSTEM IS READY. exit Server is stopping... listener closed and all sessions disconnected adjust undo_retention & wakeup purge thread...full check point starting... generate force checkpoint, rlog free space[536676352], used space[186368] checkpoint begin, used_space[186368], free_space[536676352]... checkpoint end, 0 pages flushed, used_space[168448], free_space[536694272]. full check point end. shutdown audit subsystem...OK shutdown schedule subsystem...OK shutdown timer successfully. pre-shutdown MAL subsystem...OK shutdown worker threads subsystem...OK shutdown logic log subsystem...OK shutdown sequence cache subsystem...OK wait for mtsk link worker to exit..OK shutdown mpp session subsystem...OK wait for rapply is all over... OK rapply worker threads exit successfully. pre ending task & worker threads...OK shutdown dblink subsystem...OK shutdown local parallel threads pool successfully. shutdown pthd_pools...OK shutdown session subsystem...shutdown aux session subsystem...OK shutdown rollback segments purging subsystem...OK shutdown transaction subsystem...OK shutdown locking subsystem...OK shutdown dbms_lock subsystem...OK ending tsk and worker threads...OK ckpt2_exec_immediately begin. checkpoint begin, used_space[168448], free_space[536694272]... checkpoint end, 0 pages flushed, used_space[6656], free_space[536856064]. checkpoint begin, used_space[6656], free_space[536856064]... checkpoint end, 0 pages flushed, used_space[0], free_space[536862720]. checkpoint begin, used_space[0], free_space[536862720]... checkpoint end, 0 pages flushed, used_space[0], free_space[536862720]. shutdown archive subsystem...OK shutdown redo log subsystem...OK shutdown MAL subsystem...OK shutdown message compress subsystem successfully. shutdown task subsystem...OK shutdown trace subsystem...OK shutdown svr_log subsystem...OK shutdown plan cache subsystem...OK shutdown database dictionary subsystem...OK shutdown file subsystem...OK shutdown mac cache subsystem...OK shutdown dynamic login cache subsystem...OK shutdown ifun/bifun/sfun/afun cache subsystem...OK shutdown crypt subsystem...OK shutdown pipe subsystem...OK shutdown compress component...OK shutdown slave redo subsystem...OK shutdown kernel buffer subsystem...OK shutdown SQL capture subsystem...OK shutdown control file system...OK shutdown dtype subsystem...OK shutdown huge buffer and memory pools...OK close lsnr socket DM Database Server shutdown successfully. [dmdba@yuanzj:~]$ DmServiceDAMENG start Starting DmServiceDAMENG: [ OK ] [dmdba@yuanzj:~]$ ds 服务器[LOCALHOST:5236]:处于普通打开状态 登录使用时间 : 3.786(ms) 上次登录ip : ::1 上次登录时间 : 2023-09-23 19:24:24 登录失败次数 : 0 口令是否过期 : 未过期 密钥过期时间:2024-06-25 disql V8 19:30:21 SYSDBA@DAMENG:5236 SQL> select SERIES_NO,EXPIRED_DATE,PRODUCT_TYPE,SERVER_SERIES_NAME from v$license; SERIES_NO EXPIRED_DATE PRODUCT_TYPE SERVER_SERIES_NAME ---------- ------------ ------------ ------------------ 7301094992 2024-06-25 DM8 安全版 已用时间: 0.930(毫秒). 执行号:504.

3.win服务器安全版本数据库升级正式授权步骤(如果未放置安全版key初始化数据库实例,请按照以下步骤替换正式key,如果放置安全key后初始化数据库实例,请参照1.2替换正式授权)

3.1.关闭数据库(打开DM服务查看器,点击左上角停止服务

关闭数据库.png

3.2.正式授权放置到DM_HOME/bin目录下

PS C:\Users\yuanzj> D: PS D:\> cd D:\dmdbms\bin\ PS D:\dmdbms\bin> ls .\dm.key Directory: D:\dmdbms\bin Mode LastWriteTime Length Name ---- ------------- ------ ---- -a--- 2023-09-22 20:47 648 dm.key

3.3.前台启动数据库(启动完成之后,关闭终端,数据库自动关闭

dmserver.exe D:\dmdbms\data\DAMENG\dm.ini upd_lic=1

3.4.启动数据库(打开DM服务查看器,点击左上角启动服务

启动数据库.png

3.5.查询数据库授权

select SERIES_NO,EXPIRED_DATE,PRODUCT_TYPE,SERVER_SERIES_NAME from v$license;
评论
后发表回复

作者

文章

阅读量

获赞

扫一扫
联系客服