银河麒麟操作系统安装人大金仓数据库--九五小庞
<h1>一、环境要求</h1><ul>
<li>硬件：内存512M以上，磁盘空间10G以上</li>
<li>软件：主流Linux操作系统，本机使用kylin-v10</li>
<li>安装包准备：官网下载数据库文件镜像以及授权文件<br>https://www.kingbase.com.cn/rjcxxz/index.htm</li>
</ul>
<p><img src="https://img2023.cnblogs.com/blog/1943666/202309/1943666-20230915154901595-1395360509.png"></p>
<p> </p>
<p><img src="https://img2023.cnblogs.com/blog/1943666/202309/1943666-20230915154924360-1263516677.png"></p>
<h1>二、配置内核参数</h1>
<div class="cnblogs_code">
<pre>vim /etc/<span style="color: rgba(0, 0, 0, 1)">sysctl.conf
# 加入以下行
fs.aio</span>-max-nr= <span style="color: rgba(128, 0, 128, 1)">1048576</span><span style="color: rgba(0, 0, 0, 1)">
fs.file</span>-max= <span style="color: rgba(128, 0, 128, 1)">6815744</span><span style="color: rgba(0, 0, 0, 1)">
kernel.shmall</span>= <span style="color: rgba(128, 0, 128, 1)">2097152</span><span style="color: rgba(0, 0, 0, 1)">
kernel.shmmax</span>= <span style="color: rgba(128, 0, 128, 1)">4294967295</span><span style="color: rgba(0, 0, 0, 1)">
kernel.shmmni</span>= <span style="color: rgba(128, 0, 128, 1)">4096</span><span style="color: rgba(0, 0, 0, 1)">
kernel.sem</span>= <span style="color: rgba(128, 0, 128, 1)">250</span> <span style="color: rgba(128, 0, 128, 1)">32000</span> <span style="color: rgba(128, 0, 128, 1)">100</span> <span style="color: rgba(128, 0, 128, 1)">128</span><span style="color: rgba(0, 0, 0, 1)">
net.ipv4.ip_local_port_range</span>= <span style="color: rgba(128, 0, 128, 1)">9000</span> <span style="color: rgba(128, 0, 128, 1)">65500</span><span style="color: rgba(0, 0, 0, 1)">
net.core.rmem_default</span>= <span style="color: rgba(128, 0, 128, 1)">262144</span><span style="color: rgba(0, 0, 0, 1)">
net.core.rmem_max</span>= <span style="color: rgba(128, 0, 128, 1)">4194304</span><span style="color: rgba(0, 0, 0, 1)">
net.core.wmem_default</span>= <span style="color: rgba(128, 0, 128, 1)">262144</span><span style="color: rgba(0, 0, 0, 1)">
net.core.wmem_max</span>= <span style="color: rgba(128, 0, 128, 1)">1048576</span>
/sbin/sysctl -<span style="color: rgba(0, 0, 0, 1)">p# 重新加载以下
</span>/sbin/sysctl -a</pre>
</div>
<h1>三、参数调整</h1>
<h2>1、资源使用参数</h2>
<div class="cnblogs_code">
<pre>vim /etc/security/<span style="color: rgba(0, 0, 0, 1)">limits.conf
# 加入以下行
# </span>*<span style="color: rgba(0, 0, 0, 1)"> 表示所有用户，可只设置 root 和 kingbase 用户
</span>* soft nofile <span style="color: rgba(128, 0, 128, 1)">65536</span><span style="color: rgba(0, 0, 0, 1)">
# 注意：设置 nofile 的 hard limit 不能大于</span>/proc/sys/fs/<span style="color: rgba(0, 0, 0, 1)">nr_open，否则注销后将无法正常登陆
</span>* hard nofile <span style="color: rgba(128, 0, 128, 1)">65535</span>
* soft nproc <span style="color: rgba(128, 0, 128, 1)">65536</span>
* hard nproc <span style="color: rgba(128, 0, 128, 1)">65535</span><span style="color: rgba(0, 0, 0, 1)">
# unlimited 表示无限制
</span>*<span style="color: rgba(0, 0, 0, 1)"> soft core unlimited
</span>* hard core unlimited</pre>
</div>
<h2>2、RemoveIPC 参数</h2>
<p>把 /etc/systemd/logind.conf 文件中的 RemoveIPC=no 设置，再执行一下指令</p>
<div class="cnblogs_code">
<pre>systemctl daemon-<span style="color: rgba(0, 0, 0, 1)">reload
systemctl restart systemd</span>-logind.service</pre>
</div>
<h1>四、预安装工作</h1>
<h2>1、创建安装用户</h2>
<div class="cnblogs_code">
<pre>useradd -<span style="color: rgba(0, 0, 0, 1)">m kingbase
passwd kingbase # aaa123...A</span></pre>
</div>
<p>注意：创建安装系统用户 kingbase 之后，如无特殊说明，后续的操作默认使用 kingbase 用户进行操作</p>
<h2>2、创建安装目录</h2>
<div class="cnblogs_code">
<pre>mkdir -p /opt/Kingbase/ES/<span style="color: rgba(0, 0, 0, 1)">V8 # 默认路径，可自定义
chmod o</span>+rwx /opt/Kingbase/ES/V8</pre>
</div>
<h2>3、数据目录</h2>
<p>数据目录是金仓数据库管理系统 KingbaseES 中存放数据文件的目录，默认是在安装目录下的 data 目录，无需提前创建，安装过程中可以创建</p>
<p> </p>
<div class="cnblogs_code">
<pre>mkdir /opt/Kingbase/ES/V8/data</pre>
</div>
<h2>4、挂载安装包</h2>
<div class="cnblogs_code">
<pre>mkdir /<span style="color: rgba(0, 0, 0, 1)">KingbaseESV8 # 挂载点
mount KingbaseES_V008R006C006B0021_Lin64_install.iso</span>/<span style="color: rgba(0, 0, 0, 1)">KingbaseESV8
ls
setupsetup.sh # 挂载点下有两个文件</span></pre>
</div>
<h1>五、安装</h1>
<h2>1、安装</h2>
<div class="cnblogs_code">
<pre>su -<span style="color: rgba(0, 0, 0, 1)"> kingbase # 切换到安装用户
cd </span>/<span style="color: rgba(0, 0, 0, 1)">KingbaseESV8 # 进入挂载点目录
.</span>/setup.sh -i console # 执行安装脚本，命令行安装</pre>
</div>
<p>一路回车 --> 直到出现 完全安装 的选项，选择完全安装 --> 选择授权文件 --> 选择安装目录 --> 等待安装 --> 选择数据存储路径 --> 设置初始化参数</p>
<p><img src="https://img2023.cnblogs.com/blog/1943666/202309/1943666-20230915155449565-1796894874.png"></p>
<p> </p>
<p>最后显示：代表成功</p>
<p><img src="https://img2023.cnblogs.com/blog/1943666/202309/1943666-20230915155522053-1353628554.png"></p>
<p> </p>
<h2>2、注册系统服务</h2>
<div class="cnblogs_code">
<pre>su -<span style="color: rgba(0, 0, 0, 1)"> root
</span>/opt/Kingbase/ES/V8/install/script/root.sh</pre>
</div>
<p><img src="https://img2023.cnblogs.com/blog/1943666/202309/1943666-20230915155605338-1700553403.png"></p>
<p> 这个时候54321端口就已经开了，代表数据库服务已经正常运行。<br>我们可以用如下两种方法对数据库服务进行启停</p>
<div class="cnblogs_code">
<pre>systemctl start|<span style="color: rgba(0, 0, 0, 1)">stop kingbase8d.service
</span>/etc/init.d/kingbase8d start|stop</pre>
</div>
<h2>3、连接数据库</h2>
<div class="cnblogs_code">
<pre>cd /opt/Kingbase/ES/V8/Server/bin/<span style="color: rgba(0, 0, 0, 1)">
.</span>/ksql -p <span style="color: rgba(128, 0, 128, 1)">54321</span> -U system test</pre>
</div>
<p><img src="https://img2023.cnblogs.com/blog/1943666/202309/1943666-20230915155705041-743273413.png"></p>
<p> --------------------------------------------------------</p>
<p>参考链接：麒麟操作系统安装人大金仓数据库_银河麒麟安装人大金仓数据库_小猿桥的博客-CSDN博客</p><br><br>
来源：https://www.cnblogs.com/pxyblog/p/17705223.html
頁:
[1]