达梦数据库

一。安装在指定用户下。

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