一、环境信息

操作系统：4.19.90-25.14.v2101.ky10.aarch64
安装目录：/data/dm/dmdbms
升级前版本：1-2-128-22.07.29-165918-20005-SEC
升级后版本：1-2-174-2022.11.21-175072-20024-SEC

二、数据库备份

建议在数据库升级前做一次全量备份

2.1 确认 AP 服务状态

注：若 AP 服务没有启动，则会导致备份报错
ps -ef | grep dmap

2.2 关闭数据库

DmServiceDMSERVER stop

2.3 脱机备份

dmrman
#全量备份
backup database '/data/dm/dmdata/data/dmdb/dm.ini' backupset '/data/backup';
#验证备份
check backupset '/data/backup';

报错：RMAN> backup database ‘/data/dm/dmdata/data/dmdb/dm.ini’ backupset ‘/data/backup’;
backup database ‘/data/dm/dmdata/data/dmdb/dm.ini’ backupset ‘/data/backup’;
file dm.key not found, use default license!
[-137]:服务器正在运行或者存在其他进程正在操作同一个库

原因：未关闭数据库

三、数据库升级

3.1 查看旧版本信息

SQL> select * from v$instance;

行号     NAME INSTANCE_NAME INSTANCE_NUMBER HOST_NAME     SVR_VERSION                DB_VERSION          START_TIME          STATUS$ MODE$  OGUID       DSC_SEQNO   DSC_ROLE
---------- ---- ------------- --------------- ------------- -------------------------- ------------------- ------------------- ------- ------ ----------- ----------- --------
           BUILD_VERSION                      BUILD_TIME          
           ---------------------------------- --------------------
1          DMDB DMDB          1               jtsremvuka-03 DM Database Server x64 V8  DB Version: 0x7000c 2023-01-05 22:58:31 OPEN    NORMAL 0           0           NULL
           1-2-128-22.07.29-165918-20005-SEC  Jul 29 2022 15:32:36


已用时间: 6.619(毫秒). 执行号:500.

3.2 重命名源环境的 bin 目录

注：使用同一用户操作（dmdba 用户），保持目录权限一致
cd /data/dm —软件安装目录
mv bin bin_bak

3.3 安装新的软件

3.3.1 dmdba 用户

[dmdba@jtsremvuka-03 iso]$ ./DMInstall.bin -i
Please select the installer's language (E/e:English C/c:Chinese) [E/e]:
Extract install files..........
Welcome to DM DBMS Installer

Whether to input the path of Key File? (Y/y:Yes N/n:No) [Y/y]:n

Whether to Set The TimeZone? (Y/y:Yes N/n:No) [Y/y]:y
TimeZone:
[ 1]: GTM-12=West Date Line
[ 2]: GTM-11=Samoa
[ 3]: GTM-10=Hawaii
[ 4]: GTM-09=Alaska
[ 5]: GTM-08=Pacific(America and Canada)
[ 6]: GTM-07=Arizona
[ 7]: GTM-06=Central(America and Canada)
[ 8]: GTM-05=East(America and Canada)
[ 9]: GTM-04=Atlantic(America and Canada)
[10]: GTM-03=Brasilia
[11]: GTM-02=Middle Atlantic
[12]: GTM-01=Azores
[13]: GTM=Greenwich Mean Time
[14]: GTM+01=Sarajevo
[15]: GTM+02=Cairo
[16]: GTM+03=Moscow
[17]: GTM+04=AbuDhabi
[18]: GTM+05=Islamabad
[19]: GTM+06=Dakar
[20]: GTM+07=BangKok,Hanoi
[21]: GTM+08=China
[22]: GTM+09=Seoul
[23]: GTM+10=Guam
[24]: GTM+11=Solomon
[25]: GTM+12=Fiji
[26]: GTM+13=Nukualofa
[27]: GTM+14=Kiribati
Please Select the TimeZone [21]:

Installation Type:
1 Typical
2 Server
3 Client
4 Custom
Please Input the number of the Installation Type [1 Typical]:
Require Space: 1904M

Please Input the install path [/home/dmdba/dmdbms]:
Available Space:25G
Please Confirm the install path(/home/dmdba/dmdbms)? (Y/y:Yes N/n:No) [Y/y]:y

Pre-Installation Summary
Installation Location: /home/dmdba/dmdbms
Require Space: 1904M
Available Space: 25G
Version Information: 
Expire Date: 
Installation Type: Typical
Confirm to Install? (Y/y:Yes N/n:No):y

File /etc/dm_svc.conf exist, replace it? (Y/y,N/n) [Y/y]:y
2023-01-05 23:23:55 
[INFO] Installing DM DBMS...
2023-01-05 23:23:55 
[INFO] Installing BASE Module...
2023-01-05 23:23:59 
[INFO] Installing SERVER Module...
2023-01-05 23:24:01 
[INFO] Installing CLIENT Module...
2023-01-05 23:24:01 
[INFO] Installing DRIVERS Module...
2023-01-05 23:24:08 
[INFO] Installing MANUAL Module...
2023-01-05 23:24:09 
[INFO] Installing SERVICE Module...
2023-01-05 23:24:12 
[INFO] Move log file to log directory.
2023-01-05 23:24:13 
[INFO] Installed DM DBMS completely.

Please execute the commands by root:
/home/dmdba/dmdbms/script/root/root_installer.sh

End

3.3.2 root 用户

注：根据 “3.3.1 dmdba 用户” 提示信息操作
/home/dmdba/dmdbms/script/root/root_installer.sh

3.4 拷贝 bin 目录

注：使用同一用户操作（dmdba 用户），保持目录权限一致
先将新环境的 bin 目录拷贝至旧环境的安装目录下，再将旧环境的服务文件拷贝至新的 bin 目录中。
cp -r /home/dmdba/dmdbms/bin /data/dm/
cp /data/dm/bin_bak/DmServiceDMSERVER /data/dm/bin/
cp /data/dm/bin_bak/DmAPService /data/dm/bin/

3.5 启动数据库

启动数据库
DmServiceDMSERVER start
启动 AP 服务
DmAPService restart

四、升级结果验证

4.1 查看新版本信息

SQL> select id_code;

LINEID     ID_CODE                            
---------- -----------------------------------
1          --05134283950-20221121-175072-20024

used time: 2.706(ms). Execute id is 3801.


SQL> select * from v$instance;

LINEID     NAME INSTANCE_NAME INSTANCE_NUMBER HOST_NAME     SVR_VERSION                DB_VERSION          START_TIME          STATUS$ MODE$  OGUID       DSC_SEQNO   DSC_ROLE
---------- ---- ------------- --------------- ------------- -------------------------- ------------------- ------------------- ------- ------ ----------- ----------- --------
           BUILD_VERSION                        BUILD_TIME          
           ------------------------------------ --------------------
1          DMDB DMDB          1               jtsremvuka-03 DM Database Server x64 V8  DB Version: 0x7000c 2023-01-06 00:05:18 OPEN    NORMAL 0           0           NULL
           1-2-174-2022.11.21-175072-20024-SEC  Nov 25 2022 17:32:11


used time: 4.458(ms). Execute id is 3800.

4.2 验证数据写入

SQL> create table t1(id int,name varchar(20));
executed successfully
used time: 20.603(ms). Execute id is 3802.
SQL> insert into t1 values(1,'x');
affect rows 1

used time: 1.104(ms). Execute id is 3803.