麒麟系统安装OcenBase数据库
<p>1.OceanBase下载</p><p>下载地址：<span style="font-family: Arial">https://www.oceanbase.com/softwarecenter</span></p>
<p><span style="font-family: Arial">选择社区版点击下载</span></p>
<p> </p>
<p><img src="https://img2024.cnblogs.com/blog/2259678/202502/2259678-20250207090814443-1581348667.png"></p>
<p>2.上传OceanBase包</p>
<p>将下载下的tar包上传麒麟服务器上root路径下。</p>
<p><img src="https://img2024.cnblogs.com/blog/2259678/202502/2259678-20250207091714020-528651418.png"></p>
<p> 3.解压tar包</p>
<div class="cnblogs_code">
<pre>tar -xzf oceanbase-all-<span style="color: rgba(0, 0, 255, 1)">in</span>-one-<span style="color: rgba(128, 0, 128, 1)">4.3</span>.5_20250115.el7.x86_64.tar.gz</pre>
</div>
<p><img src="https://img2024.cnblogs.com/blog/2259678/202502/2259678-20250207103800899-1103223960.png"></p>
<p> 4.进入bin文件夹</p>
<div class="cnblogs_code">
<pre>cd oceanbase-all-<span style="color: rgba(0, 0, 255, 1)">in</span>-one/bin/</pre>
</div>
<p> </p>
<p><img src="https://img2024.cnblogs.com/blog/2259678/202502/2259678-20250207104117563-158826804.png"></p>
<p>5.执行安装</p>
<div class="cnblogs_code">
<pre>./<span style="color: rgba(0, 0, 0, 1)">install.sh
source </span>~/.oceanbase-all-<span style="color: rgba(0, 0, 255, 1)">in</span>-one/bin/env.sh</pre>
</div>
<p><img src="https://img2024.cnblogs.com/blog/2259678/202502/2259678-20250207104900385-1477484451.png"></p>
<p> 6.快速部署（方式1）</p>
<div class="cnblogs_code">
<pre>obd demo</pre>
</div>
<p><img src="https://img2024.cnblogs.com/blog/2259678/202502/2259678-20250207105111936-1936352512.png"></p>
<p> 执行后出现问题：</p>
<p><img src="https://img2024.cnblogs.com/blog/2259678/202502/2259678-20250207110154588-1597727344.png"></p>
<p>问题解决方式：</p>
<div class="cnblogs_code">
<pre>vim /etc/security/limits.conf </pre>
</div>
<p><span style="font-family: 宋体">进入文件之后</span><span style="font-family: Helvetica">i</span><span style="font-family: 宋体">插入数据</span></p>
<p>在文件最后添加</p>
<div class="cnblogs_code">
<pre>*soft nofile <span style="color: rgba(128, 0, 128, 1)">655360</span>
*hard nofile <span style="color: rgba(128, 0, 128, 1)">655360</span>
*soft nproc <span style="color: rgba(128, 0, 128, 1)">655360</span>
*hard nproc <span style="color: rgba(128, 0, 128, 1)">655360</span>
*<span style="color: rgba(0, 0, 0, 1)">soft core unlimited
</span>*<span style="color: rgba(0, 0, 0, 1)">hard core unlimited
</span>*<span style="color: rgba(0, 0, 0, 1)">soft stack unlimited
</span>*hard stack unlimited</pre>
</div>
<p><span style="font-family: 宋体">：</span><span style="font-family: Helvetica">wq</span><span style="font-family: 宋体">保存文件之后注销或重启系统</span></p>
<p><img src="https://img2024.cnblogs.com/blog/2259678/202502/2259678-20250207133137724-1081422722.png"></p>
<p> 注意<span style="color: rgba(255, 0, 0, 1)">*</span>号和后边配置要有一个<span style="color: rgba(255, 0, 0, 1)">空格</span>，否则配置不起作用。</p>
<p> 重新进入bin目录执行 命令</p>
<div class="cnblogs_code">
<pre>obd demo</pre>
</div>
<p><img src="https://img2024.cnblogs.com/blog/2259678/202502/2259678-20250207133255670-226636652.png"></p>
<p> </p>
<p><span style="font-family: Helvetica">9090</span><span style="font-family: 宋体">端口为标麒麟默认端口也是</span>prometheus默认端口，所以修改方法为部署时修改端口，命令如下：</p>
<div class="cnblogs_code">
<pre>obd demo --prometheus.port=<span style="color: rgba(128, 0, 128, 1)">9091</span></pre>
</div>
<p><img src="https://img2024.cnblogs.com/blog/2259678/202502/2259678-20250207133459528-1422909579.png"></p>
<p><img src="https://img2024.cnblogs.com/blog/2259678/202502/2259678-20250207133809233-1270505898.png"></p>
<p><span style="font-family: "Times New Roman"">demo running</span><span style="font-family: 仿宋_GB2312">表示运行成功， 然后记住数据库默认密码，即可进行连接！</span></p>
<p>7.测试连接</p>
<p>使用Navicat连接数据库，数据库默认端口是2881。</p>
<p><img src="https://img2024.cnblogs.com/blog/2259678/202502/2259678-20250207135212085-1536175938.png"></p>
<p> 如果连接不上2881端口，有可能是防火墙开通端口问题。</p>
<p>查看防火墙端口列表：</p>
<div class="cnblogs_code">
<pre>sudo firewall-cmd --list-ports</pre>
</div>
<p>查看防护墙指定端口：</p>
<div class="cnblogs_code">
<pre>sudo firewall-cmd --zone=<span style="color: rgba(0, 0, 255, 1)">public</span> --query-port=<span style="color: rgba(128, 0, 128, 1)">2881</span>/tcp</pre>
</div>
<p>开放端口：</p>
<div class="cnblogs_code">
<pre>sudo firewall-cmd --zone=<span style="color: rgba(0, 0, 255, 1)">public</span> --add-port=<span style="color: rgba(128, 0, 128, 1)">2881</span>/tcp --permanent</pre>
</div>
<p>刷新防护墙：</p>
<div class="cnblogs_code">
<pre>sudo firewall-cmd --reload</pre>
</div>
<p>8.修改数据库密码</p>
<p>登录数据库成功后，执行命令修改密码：</p>
<div class="cnblogs_code">
<pre>ALTER USER root IDENTIFIED BY <span style="color: rgba(128, 0, 0, 1)">'</span><span style="color: rgba(128, 0, 0, 1)">12345678</span><span style="color: rgba(128, 0, 0, 1)">'</span>;</pre>
</div>
<p><img src="https://img2024.cnblogs.com/blog/2259678/202502/2259678-20250207141144059-1612267166.png"></p>
<p> </p>
<p> </p>
<p> </p>
<p>问题：</p>
<p>1.虚拟机粘贴不了需要安装 open-vm-tools</p>
<div class="cnblogs_code">
<pre>yum install open-vm-tools</pre>
</div>
<p> </p>
<p><img src="https://img2024.cnblogs.com/blog/2259678/202502/2259678-20250207132406426-404302176.png"></p>
<p> </p><br><br>
来源：https://www.cnblogs.com/ckfuture/p/18702027
頁:
[1]