达梦数据库

    xiaoxiao2021-11-30  49

    一。安装在指定用户下。

    1. DM数据库系统用户

    groupadd dinstall useradd -g dinstall -m -d /home/dmdba -s /bin/bash dmdba passwd dmdba mkdir -p /opt/dmdbms chmod -R 755 /opt/dmdbms 2. 执行安装 ./DMInstall.bin -i 3. DM数据库随机启动服务 /* bin目录下的DmServiceDMSERVER文件拷贝到/etc/rc.d/init.d 目录下如果手工执行: 设默认安装路径: /opt/dmdbms 服务名: DMSERVER ln –s /etc/rc.d/init.d/DmServiceDMSERVER /etc/rc.d/rc0.d/K02DmServiceDMSERVER ln –s /etc/rc.d/init.d/DmServiceDMSERVER /etc/rc.d/rc3.d/S98DmServiceDMSERVER ln –s /etc/rc.d/init.d/DmServiceDMSERVER /etc/rc.d/rc5.d/S98DmServiceDMSERVER ln –s /etc/rc.d/init.d/DmServiceDMSERVER /etc/rc.d/rc6.d/K02DmServiceDMSERVER chkconfig --add DmServiceDMSERVER 但在新的 DM 7 下没找到这些。。。 */ [dmdba@xclos dm7_20131111_neoky5_64]$ ./DMInstall.bin -i rm: cannot remove `/tmp/DMInstall/source': Permission denied rm: cannot remove `/tmp/DMInstall/install': Permission denied Extract install files......... chmod: changing permissions of `/tmp/DMInstall/': Operation not permitted chmod: changing permissions of `/tmp/DMInstall/source': Operation not permitted chmod: cannot read directory `/tmp/DMInstall/source': Permission denied chmod: changing permissions of `/tmp/DMInstall/install': Operation not permitted /tmp/DMInstall/install/install.sh: line 35: /tmp/DMInstall/source/script/ckdmstat.sh: Permission denied Welcome to DM Install Program Whether to input the path of Key File? (Y/y:Yes N/n:No) [Y/y]:^C -- 在 root 用户下删除掉 /tmp/DMInstall 后再执行安装 [dmdba@xclos dm7_20131111_neoky5_64]$ ./DMInstall.bin -i Extract install files......... Welcome to DM Install Program 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]:n Installation Type: 1 Typical 2 Server 3 Client 4 Custom Please Input the number of the Installation Type [1 Typical]:1 Require Space: 380M Please Input the install path [/home/dmdba/dmdbms]: Available Space: 99G Please Confirm the install path? (Y/y:Yes N/n:No) [Y/y]: Pre-Installation Summary Installation Location: /home/dmdba/dmdbms Require Space: 380M Available Space: 99G Version Information: Expire Data: Installation Type: Typical Confirm to Install? (Y/y:Yes N/n:No) [Y/y]: 2014-01-06 17:38:27 [INFO] Installing default Module... 2014-01-06 17:38:27 [INFO] Installing DM DBMS... 2014-01-06 17:39:01 [INFO] Installing server Module... 2014-01-06 17:40:06 [INFO] Installing client Module... 2014-01-06 17:40:11 [INFO] Installing drivers Module... 2014-01-06 17:40:11 [INFO] Installing manual Module... 2014-01-06 17:40:11 [INFO] Installing service Module... 2014-01-06 17:40:15 [ERROR] /etc/dm_svc.conf (Permission denied) 2014-01-06 17:40:15 [INFO] Move ant log file to log directory. 2014-01-06 17:40:16 [INFO] Installed DM DBMS completely. End [dmdba@xclos dm7_20131111_neoky5_64]$ 二。 root用户下的安装 直接执行就行了。 [root@xcl12c soft]# tar -xzvf dm7_20131111_neoky5_64.tar.gz dm7_20131111_neoky5_64/DMInstall.bin dm7_20131111_neoky5_64/DM_Install_en.pdf dm7_20131111_neoky5_64/DM_Install_zh.pdf dm7_20131111_neoky5_64/dm.key [root@xcl12c soft]# ./dm7_20131111_neoky5_64/DMInstall.bin -i Extract install files......... Welcome to DM Install Program 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]:n Installation Type: 1 Typical 2 Server 3 Client 4 Custom Please Input the number of the Installation Type [1 Typical]:1 Require Space: 380M Please Input the install path [/opt/dmdbms]: Available Space: 10G Please Confirm the install path? (Y/y:Yes N/n:No) [Y/y]: Pre-Installation Summary Installation Location: /opt/dmdbms Require Space: 380M Available Space: 10G Version Information: Expire Data: Installation Type: Typical Confirm to Install? (Y/y:Yes N/n:No) [Y/y]: 2014-01-06 09:35:52 [INFO] Installing DM DBMS... 2014-01-06 09:35:52 [INFO] Installing default Module... 2014-01-06 09:35:54 [INFO] Installing server Module... 2014-01-06 09:35:57 [INFO] Installing client Module... 2014-01-06 09:35:58 [INFO] Installing drivers Module... 2014-01-06 09:35:58 [INFO] Installing manual Module... 2014-01-06 09:35:59 [INFO] Installing service Module... 2014-01-06 09:36:20 [INFO] Move ant log file to log directory. 2014-01-06 09:36:21 [INFO] Create system user "dmdba" successfully. 2014-01-06 09:36:21 [INFO] Installed DM DBMS completely. End MAIL: xcl_168@aliyun.com BLOG: http://blog.csdn.net/xcl168

    达梦在Windows全是图形界面到没什么难的。 但在Linux下就有点为难了。 都不知在哪下手。 翻了半天文档才有点眉目。

    如何启动相关服务及生成相关数据库。先记录下来,也不知这样理解对不对。

    1. 生成数据库,默认为dm a. 创建好目录

    -- 存放数据库文件存放目录

    mkdir /opt/dmdbms/data

    -- 保存 dminit 的日志

    mkdir /opt/dmdbms/data/log b. 依提示创建 ./dminit 2. 启动数据库 在一个会话中启动一个数据库 ./dmserver /opt/dmdbms/data/DMSERVER/dm.ini dmserver命令说明: [root@xcl12c bin]# ./dmserver help format: ./dmserver [ini_file_path] [-noconsole] [mount] example: ./dmserver path=/opt/dmdbms/bin/dm.ini ./dmserver /opt/dmdbms/bin/dm.ini KEY WORD EXPLANATION -------------------------------------------------------------------------------- PATH the absolute path of dm.ini or the current directory -noconsole start in service mode mount start in mount status HELP print help information 3. 在另一个会话中就可以连接上新建的数据库了 [root@xcl12c bin]# ./disql SYSDBA/SYSDBA@localhost Server[localhost:5236]:mode is normal, state is open normal user login login used time: 8.931(ms) disql V7.1.2.215-Build(2013.11.08-36626trunc) Connected to: DM 7.1.2.215 SQL>

    MAIL: xcl_168@aliyun.com

    BLOG: http://blog.csdn.net/xcl168

    转载请注明原文地址: https://ju.6miu.com/read-679206.html

    最新回复(0)