银河麒麟系统安装人大金仓数据库
<p><strong><span style="font-family: "Microsoft YaHei"; font-size: 14px">1.系统环境（银河麒麟v10_sp3）</span></strong></p><p><span style="font-family: "Microsoft YaHei"; font-size: 14px">安装包准备：官网下载数据库文件镜像以及授权文件https://www.kingbase.com.cn/rjcxxz/index.htm</span></p>
<p><strong><span style="font-family: "Microsoft YaHei"; font-size: 14px">2.内核参数配置</span></strong></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">通过vim操作输入命令 vim /etc/sysctl.conf 或 根据该目录（/etc/sysctl.conf）直接修改文件</span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px"># 加入以下行</span><br><span style="font-family: "Microsoft YaHei"; font-size: 14px">fs.aio-max-nr= 1048576</span><br><span style="font-family: "Microsoft YaHei"; font-size: 14px">fs.file-max= 6815744</span><br><span style="font-family: "Microsoft YaHei"; font-size: 14px">kernel.shmall= 2097152</span><br><span style="font-family: "Microsoft YaHei"; font-size: 14px">kernel.shmmax= 4294967295</span><br><span style="font-family: "Microsoft YaHei"; font-size: 14px">kernel.shmmni= 4096</span><br><span style="font-family: "Microsoft YaHei"; font-size: 14px">kernel.sem= 250 32000 100 128</span><br><span style="font-family: "Microsoft YaHei"; font-size: 14px">net.ipv4.ip_local_port_range= 9000 65500</span><br><span style="font-family: "Microsoft YaHei"; font-size: 14px">net.core.rmem_default= 262144</span><br><span style="font-family: "Microsoft YaHei"; font-size: 14px">net.core.rmem_max= 4194304</span><br><span style="font-family: "Microsoft YaHei"; font-size: 14px">net.core.wmem_default= 262144</span><br><span style="font-family: "Microsoft YaHei"; font-size: 14px">net.core.wmem_max= 1048576</span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">/sbin/sysctl -p # 重新加载以下</span><br><span style="font-family: "Microsoft YaHei"; font-size: 14px">/sbin/sysctl -a</span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px"># 上述命令保存后重新执行以下命令以供重载 sysctl.conf 文件 </span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">/sbin/sysctl -p </span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">/sbin/sysctl -a </span></p>
<p><strong><span style="font-family: "Microsoft YaHei"; font-size: 14px">3.参数调整 </span></strong></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">1）通过vim操作输入命令 vim /etc/security/limits.conf 或 根据该目录（/etc/security/limits.conf）直接修改文件 </span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px"># 加入以下行 # * 表示所有用户，可只设置 root 和 kingbase 用户 </span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">* soft nofile 65536 </span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px"># 注意：设置 nofile 的 hard limit 不能大于/proc/sys/fs/nr_open，否则注销后将无法正常登陆 </span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">* hard nofile 65535 </span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">* soft nproc 65536 </span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">* hard nproc 65535 </span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px"># unlimited 表示无限制 </span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">* soft core unlimited </span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">* hard core unlimited </span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">2）把 /etc/systemd/logind.conf 文件中的 RemoveIPC=no 保存后再执行以下指令 </span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">systemctl daemon-reload </span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">systemctl restart systemd-logind.service </span></p>
<p><strong><span style="font-family: "Microsoft YaHei"; font-size: 14px">4.预安装工作 </span></strong></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">1）创建安装用户</span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px"> useradd -m kingbase </span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">passwd kingbase #密码需要大小写、字符最少8位 </span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">2）创建安装目录 </span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">mkdir -p /opt/Kingbase/ES/V9 # 默认路径，可自定义 </span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">chmod o+rwx /opt/Kingbase/ES/V9 # 设置读写权限 </span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">3）创建数据目录 </span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">mkdir /opt/Kingbase/ES/V9/data </span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">4）挂载安装包（iso文件） </span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">mkdir /KingbaseESV9 # 创建挂载点 </span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">mount KingbaseES_V009R001C001B0030_Lin64_install.iso /KingbaseESV9 # 替换自己下载的iso文件 </span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">ls </span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">setup setup.sh # 挂载点下有两个文件 </span></p>
<p><strong><span style="font-family: "Microsoft YaHei"; font-size: 14px">5.开始安装 </span></strong></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">1）安装 </span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">su - kingbase # 切换到安装用户 </span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">cd /KingbaseESV9 # 进入挂载点目录 </span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">./setup.sh -i console # 执行安装脚本，命令行安装 </span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">2）等待出现内容后一路进行 直到出现 “完全安装” 的选项</span></p>
<p>选择完全安装 --> 选择授权文件 --> 选择安装目录 --> 等待安装 --> 选择数据存储路径 --> 设置初始化参数</p>
<p>①默认端口为：54321</p>
<p>②授权文件, 输入存放文件的文件目录：例如 /data/<span style="font-family: "Microsoft YaHei"; font-size: 14px">KingbaseESV9</span></p>
<p>③<span style="font-family: "Microsoft YaHei"; font-size: 14px">默认会装在之前配置的目录下 /opt/Kingbase/ES/V9</span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">④账户默认为 system ； 密码自定义</span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">⑤默认字符集编码 UTF-8</span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">⑥数据库兼容模式 可选择 ORACLE / PG / MYSQL</span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">⑦大小写敏感只能选 否</span></p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">⑧默认数据库大小8k（可选16k、32k）</span></p>
<p> </p>
<p><span style="font-family: "Microsoft YaHei"; font-size: 14px">原文摘自：银河麒麟操作系统安装人大金仓数据库--九五小庞 - 九五小庞 - 博客园</span></p><br><br>
来源：https://www.cnblogs.com/ypsofter/p/18502363
頁:
[1]