达梦数据库日常管理之问题处理笔记1

问题1：临时目录/tmp/DMInstall)不为空

[dmdba@localhost mnt]$ ./DMInstall.bin -i

Please select the installer's language (E/e:English C/c:Chinese) [E/e]:C

删除安装程序临时目录(/tmp/DMInstall)失败!请手动删除该目录后,重新运行安装程序.

[dmdba@localhost mnt]$ exit

logout

[root@localhost mnt]#

解决方法：删除临时文件目录DMInstall

[root@localhost mnt]# cd /tmp/

[root@localhost tmp]# rm -rf ./DMInstall/

问题2：删除配置文件/tmp/dm_build.properties失败

[dmdba@localhost mnt]$ ./DMInstall.bin -i

Please select the installer's language (E/e:English C/c:Chinese) [E/e]:C

解压安装程序.........

删除配置文件/tmp/dm_build.properties失败，请手动删除。

解决方法：手动删除/tmp/dm_build.properties文件

[dmdba@localhost mnt]$ cd /tmp/

[root@localhost tmp]# rm -rf ./dm_build.properties

[root@localhost tmp]#

[dmdba@localhost mnt]$ ./DMInstall.bin -i

Please select the installer's language (E/e:English C/c:Chinese) [E/e]:C

解压安装程序.........

欢迎使用达梦数据库安装程序

是否输入Key文件路径? (Y/y:是 N/n:否) [Y/y]:

问题3：:dmap未启动[-7170]错误

SQL> backup database backupset '/data/bak/BACKUP_FILE';

backup database backupset '/data/bak/BACKUP_FILE';

[-7170]:bakres连接DMAP失败.

已用时间: 802.586(毫秒). 执行号:0.

解决方法：手动启动dmap进程

切换到bin目录下启动dmap服务：

[dmdba@host-10-174-8-18 bin]$ ./dmap

dmap V8

dmap is ready

再次执行备份

SQL> backup database backupset '/data/bak/BACKUP_FILE';

操作已执行

已用时间: 992.241(毫秒). 执行号:53901.

SQL>

问题4：error while loading shared libraries: libdmnsort.so: cannot open shared object file: No such file or directory

[dmdba@localhost mnt]$ /dm8/dmdbms/bin/dminit PATH=/data/ INSTANCE_NAME=AQZTDB PAGE_SIZE=32 LOG_SIZE=2048 DB_NAME=AQZTDB CHARSET=1 CASE_SENSITIVE=N LENGTH_IN_CHAR=Y

/dm8/dmdbms/bin/dminit: error while loading shared libraries: libdmnsort.so: cannot open shared object file: No such file or directory

[dmdba@localhost mnt]$ cd /dm8/dmdbms/

bin/       desktop/   drivers/   jar/       log/       script/    uninstall/

bin2/      doc/       include/   jdk/       samples/   tool/      web/      

解决方法：切换到达梦数据库安装目录下的bin目录下，直接执行。

[dmdba@localhost mnt]$ cd /dm8/dmdbms/bin

[dmdba@localhost bin]$ dminit PATH=/data/ INSTANCE_NAME=AQZTDB PAGE_SIZE=32 LOG_SIZE=2048 DB_NAME=AQZTDB CHARSET=1 CASE_SENSITIVE=N LENGTH_IN_CHAR=Y

initdb V8

db version: 0x7000c

file dm.key not found, use default license!

License will expire on 2022-09-30

Normal of FAST

Normal of DEFAULT

Normal of RECYCLE

Normal of KEEP

Normal of ROLL

 log file path: /data/AQZTDB/AQZTDB01.log

 log file path: /data/AQZTDB/AQZTDB02.log

write to dir [/data/AQZTDB].

create dm database success. 2021-12-20 17:22:39

[dmdba@localhost bin]$