活动专区

活动公告

上车！GBase 8a开发者联盟发车了 技术福利、人脉资源全都有！

认证培训专区

认证培训资料

GBase 8s GDCA 认证培训课前准备

GBase 8a

其他

物化视图报错：references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

01-GBase 8s 事务型数据库 安装与卸载

GBase 8s

适配迁移

[GBase 8s 教程]GBase 8s 常用函数、表达式

很早之前就听说了gbase8s ,各种原因，一直没有安装过，这不正好利用gbase8s 的学习机会，学了第二课，已经按捺不住想上上手了，下面我把我的安装步骤发一个出来，不对地方，还望指正：1.准备环境&nbsp; &nbsp;我看手册中，要求准备一个CENTOS 7环境，2C,4G即可.我本有RHEL10.1的环境，但担心不支持，算了，还是准备了一个 rhel7.9 。&nbsp;[gbasedbt@gbase8s ~]$ cat /etc/redhat-release&nbsp; Red Hat Enterprise Linux Server release 7.9 (Maipo)&nbsp;[gbasedbt@gbase8s ~]$ lscpu|grep -i "cpu(s)" CPU(s): &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4 On-line CPU(s) list: &nbsp; 0-3 NUMA node0 CPU(s): &nbsp; &nbsp; 0-3 [gbasedbt@gbase8s ~]$&nbsp; [gbasedbt@gbase8s ~]$ free -g &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;total &nbsp; &nbsp; &nbsp; &nbsp;used &nbsp; &nbsp; &nbsp; &nbsp;free &nbsp; &nbsp; &nbsp;shared &nbsp;buff/cache &nbsp; available Mem: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;7 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3 Swap: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7 [gbasedbt@gbase8s ~]$ lsblk NAME &nbsp; &nbsp; &nbsp; &nbsp;MAJ:MIN RM &nbsp; SIZE RO TYPE MOUNTPOINT sr0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;11:0 &nbsp; &nbsp;1 &nbsp;1024M &nbsp;0 rom &nbsp; sda &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 8:0 &nbsp; &nbsp;0 &nbsp; 120G &nbsp;0 disk&nbsp; ├─sda2 &nbsp; &nbsp; &nbsp; &nbsp;8:2 &nbsp; &nbsp;0 &nbsp; 119G &nbsp;0 part&nbsp; │ ├─ol-swap 252:1 &nbsp; &nbsp;0 &nbsp; 7.9G &nbsp;0 lvm &nbsp;[SWAP] │ └─ol-root 252:0 &nbsp; &nbsp;0 111.1G &nbsp;0 lvm &nbsp;/ └─sda1 &nbsp; &nbsp; &nbsp; &nbsp;8:1 &nbsp; &nbsp;0 &nbsp; &nbsp; 1G &nbsp;0 part /boot&nbsp;&nbsp; &nbsp; 具体的安装此处略 1000字。2. 下载安装介质&nbsp; &nbsp;&nbsp;<img class="image_resized" style="width:45.41%;" src="https://g1.cdn.gbase.cn/CommunityUploads/YgUWJyzXpqc-hQkr5aeqI/image.png">&nbsp; &nbsp; &nbsp;直接官网下载--》gbase 8s v8.8 --》安装包--》GBase 8s GDCA培训安装包.tar&nbsp; &nbsp; &nbsp;我是根据培训文档上的名字来的：GBase8s学习版安装包\GBase8s_ExpressEdition.tar&nbsp; &nbsp; &nbsp;发这个文件上传到 /root/setup 下面，我是使用sftp 实现的。&nbsp; &nbsp; &nbsp;[root@gbase8s setup]# ls -ltr /root/setup/GBase8s_ExpressEdition.tar&nbsp; -rw-r--r-- 1 root root 316692480 Apr &nbsp;1 &nbsp;2022 /root/setup/GBase8s_ExpressEdition.tar3.创建用户及组&nbsp; &nbsp;gbase8s 安装用到的超级用户（我是这么理解的）是 gbasedbt,在 rhel7上，直接使用useradd gbasedbt，会自动建立一个 gbasedbt组&nbsp; &nbsp;useradd gbasedbt&nbsp; &nbsp;确认一下&nbsp; &nbsp;[root@gbase8s setup]# id gbasedbt uid=1000(gbasedbt) gid=1000(gbasedbt) groups=1000(gbasedbt)4.准备安装&nbsp; &nbsp;4.1 解压安装包&nbsp; &nbsp; 使用ROOT用户执行&nbsp; &nbsp; mkdir /root/setup/install&nbsp; &nbsp; cd /root/setup/install/&nbsp; &nbsp; tar xvf ../GBase8s_ExpressEdition.tar&nbsp; &nbsp;4.2 确认 解压完后，如下：&nbsp; &nbsp; [root@gbase8s install]# ls -ltr total 309248 drwxr-xr-x 2 gbasedbt gbasedbt &nbsp; &nbsp; &nbsp; &nbsp;77 Mar 23 &nbsp;2021 doc -rwxr-xr-x 1 gbasedbt gbasedbt &nbsp; &nbsp; 82738 Mar 23 &nbsp;2021 onsecurity -rw-r--r-- 1 gbasedbt gbasedbt &nbsp; &nbsp; &nbsp;1864 Mar 23 &nbsp;2021 ids.properties -rwxr-xr-x 1 gbasedbt gbasedbt 316579352 Mar 23 &nbsp;2021 ids_install5.开始软件安装&nbsp; &nbsp;继续使用root用户来安装，这个是我始料未及的，其他一些数据库，一般使用非ROOT用户安装，这个倒有几分像MYSQL的安装&nbsp; &nbsp;cd /root/setup/install&nbsp; &nbsp;./ids_install&nbsp;&nbsp; &nbsp;我这里回车，就来了一个下马威，提示缺失 version file ：&nbsp; &nbsp;<img class="image_resized" style="width:44.92%;" src="https://g1.cdn.gbase.cn/CommunityUploads/K2KrsXlM48vwMZZLtifvv/1717e42a5bd45805712ddf82c1dbaae3.png">&nbsp; &nbsp; 还好，群里 张忠信老师丢了一个 连接：https://www.gbase.cn/community/post/176?shareId=719522&nbsp; &nbsp; 我按照上面的连接，找到，是缺少 unzip 软件，由于我操作系统是最小安装的，缺这个不足为奇，只是这个提示，有点看不明白，如果能够更多一些提示就好了。&nbsp; &nbsp; 解决了这个 the version file is not exist ,程序安装比较顺利，直接回车即可。&nbsp; &nbsp; 下面说几个关键点：&nbsp; &nbsp; &nbsp;。。。&nbsp; &nbsp; &nbsp;DO YOU ACCEPT THE TERMS OF THIS LICENSE AGREEMENT? (Y/N): Y &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;<img class="image_resized" style="width:53.96%;" src="https://g1.cdn.gbase.cn/CommunityUploads/TcMtQ68Cm3pPyCI7Un_Hu/image.png">&nbsp; &nbsp; &nbsp;&nbsp;<img class="image_resized" style="width:52.86%;" src="https://g1.cdn.gbase.cn/CommunityUploads/CKV-MchBl4xGBskgZvFii/image.png">&nbsp; &nbsp; &nbsp; 安装类型选择时，初学者不太清楚，我选择的 1 -典型安装，直接回车即可&nbsp; &nbsp; &nbsp;&nbsp;<img class="image_resized" style="width:52.33%;" src="https://g1.cdn.gbase.cn/CommunityUploads/4XvPw7Mx22-AjAYlrVh1B/image.png">&nbsp; &nbsp; &nbsp; 创建实例这里，老师说选择不创建实例，比较慢，后面单独安装，我安装老师的建议，放弃创建实例。&nbsp; &nbsp; &nbsp;&nbsp;<img class="image_resized" style="width:52.98%;" src="https://g1.cdn.gbase.cn/CommunityUploads/XDB7gX4SxuhZR6ELvLEEH/image.png">&nbsp; &nbsp; &nbsp; 这里准备安装这里，直接回车，再无问题。&nbsp; 6.验证一下软件&nbsp; &nbsp; &nbsp;ls -ltr /opt/gbase&nbsp; &nbsp;&nbsp;<img class="image_resized" style="width:52.95%;" src="https://g1.cdn.gbase.cn/CommunityUploads/jVCeAHEDJRhK9Gr1kx-Nj/image.png"> &nbsp;&nbsp;&nbsp; &nbsp; 看来软件已经安装好&nbsp; &nbsp; 7.创建实例&nbsp; &nbsp; &nbsp; &nbsp;和其他数据库一样，我们这里就叫实例创建吧，前面软件安装时，没有选择创建实例，这里来创建&nbsp; &nbsp; &nbsp; &nbsp;前面软件安装，我们都是使用ROOT用户来安装的，现在实例创建，我们要使用gbasedbt用户来执行&nbsp; &nbsp; &nbsp; &nbsp; 切换用户&nbsp; &nbsp; &nbsp; &nbsp; su - gbasedbt&nbsp; &nbsp; &nbsp; &nbsp; cd /opt/gbase/etc/&nbsp; &nbsp; &nbsp; &nbsp; ./GBaseInit_gbasedbt.sh&nbsp;&nbsp; &nbsp; &nbsp; &nbsp;<img class="image_resized" style="width:55.4%;" src="https://g1.cdn.gbase.cn/CommunityUploads/D-_1FtToDFJ2DC9t0HUCS/image.png">&nbsp; &nbsp; &nbsp; &nbsp;没有出现IP地址呢，报错了，提示 ifconfig :no such file or directory&nbsp; &nbsp; &nbsp; &nbsp;问了一下豆包，说是缺 net-tools包&nbsp; &nbsp; &nbsp; &nbsp;yum install net-tools 后，都不用退出安装，继续安装即可&nbsp; &nbsp; &nbsp; &nbsp;<img class="image_resized" style="width:55.92%;" src="https://g1.cdn.gbase.cn/CommunityUploads/T45MvAdSkIbU2HSxNoGgm/image.png">&nbsp; &nbsp; &nbsp; &nbsp; IP 保持默认即可&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<img class="image_resized" style="width:55.76%;" src="https://g1.cdn.gbase.cn/CommunityUploads/Y6DfjxDP_RGv3THLY2aSx/image.png">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;安装类型选择定制，&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;字符集，根据需要选择，我这里选择的UTF8&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;日志空间，我选择的200m,主要是练习，怎么省空间，怎么来&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;data 数据库空间和temp 数据库空间，可以选择 多个，我按安装文档来的，这里练习题还有专门说明。&nbsp; &nbsp; &nbsp; &nbsp; 后面一直倒安装完毕，没有再要求输入。&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<img class="image_resized" style="width:56.31%;" src="https://g1.cdn.gbase.cn/CommunityUploads/HW-zIE_0qeeeCv6c1LeOX/image.png">&nbsp; &nbsp; &nbsp; &nbsp; 确认一下安装完毕：&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<img class="image_resized" style="width:57.38%;" src="https://g1.cdn.gbase.cn/CommunityUploads/FqJNBPSrmDh1FqSXiPVhT/image.png">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;9088 端口&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<img class="image_resized" style="width:57.77%;" src="https://g1.cdn.gbase.cn/CommunityUploads/-auzFth3or3uCQa-inTOm/image.png">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;看到核心进程：oninit&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; gbase8s 是多进程多线程架构&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<img class="image_resized" style="width:57.09%;" src="https://g1.cdn.gbase.cn/CommunityUploads/HEK-KY8acFpXPeWhI-Rss/image.png">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;到此，GBASE8S数据库安装就算完成。&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp;

安装配置

gbase8s 我的首次安装

gbase8s 我的首次安装

评论

热门帖子