20221120-GBase 8s数据库初体验-01安装

最新推荐文章于 2025-06-12 07:15:17 发布

chenoracle

最新推荐文章于 2025-06-12 07:15:17 发布

阅读量139

点赞数 8

分类专栏：国产数据库文章标签：数据库

本文链接：https://blog.csdn.net/chenoracle/article/details/148493847

版权

国产数据库专栏收录该内容

3 篇文章

订阅专栏

在这里插入图片描述

国产数据库四朵金花

在这里插入图片描述

GBase 8s 发展史

在这里插入图片描述

功能
在这里插入图片描述

服务架构
在这里插入图片描述

安装

以图形化安装为例，命令行方式安装参考链接：

https://blog.csdn.net/jihui8848/article/details/117996240?spm=1001.2014.3001.5501

[root@cjc-db-01 gbase]# ./ids_install -i swing

在这里插入图片描述

添加用户环境变量

[gbasedbt@cjc-db-01 ~]$ vi .bash_profile
export GBASEDBTSERVER=ol_gbasedbt1210
export GBASEDBTDIR=/gbase/rdbms
export GBASEDBTSQLHOSTS=/gbase/rdbms/etc/sqlhosts.ol_gbasedbt1210
export ONCONFIG=onconfig.ol_gbasedbt1210
export PATH=/gbase/rdbms/bin:$PATH
export DB_LOCALE=zh_CN.utf8
export CLIENT_LOCALE=zh_CN.utf8
unset GL_USEGLU
[gbasedbt@cjc-db-01 ~]$ source .bash_profile

检查gbase进程

[gbasedbt@cjc-db-01 ~]$ ps -ef|grep oninit|grep -v grep
gbasedbt   7876      1  0 18:14 ?        00:00:00 /gbase/rdbms/bin/oninit -ivwy
root       7877   7876  0 18:14 ?        00:00:00 /gbase/rdbms/bin/oninit -ivwy
root       7878   7877  0 18:14 ?        00:00:00 /gbase/rdbms/bin/oninit -ivwy
root       7879   7877  0 18:14 ?        00:00:00 /gbase/rdbms/bin/oninit -ivwy
root       7880   7877  0 18:14 ?        00:00:00 /gbase/rdbms/bin/oninit -ivwy
root       7881   7877  0 18:15 ?        00:00:00 /gbase/rdbms/bin/oninit -ivwy
root       7882   7877  0 18:15 ?        00:00:00 /gbase/rdbms/bin/oninit -ivwy
root       7883   7877  0 18:15 ?        00:00:00 /gbase/rdbms/bin/oninit -ivwy

检查数据库状态

[gbasedbt@cjc-db-01 ~]$ onstat -
Your evaluation license will expire on 2023-11-12 00:00:00
On-Line -- Up 00:20:08 -- 175748 Kbytes

停库

[gbasedbt@cjc-db-01 ~]$ onmode -ky
Your evaluation license will expire on 2023-11-12 00:00:00

检查状态

[gbasedbt@cjc-db-01 ~]$ onstat -
Your evaluation license will expire on 2023-11-12 00:00:00
shared memory not initialized for GBASEDBTSERVER 'ol_gbasedbt1210'

启库

[gbasedbt@cjc-db-01 ~]$ oninit -vy
Your evaluation license will expire on 2023-11-12 00:00:00
Warning: Parameter's user-configured value was adjusted. (DS_MAX_SCANS)
Warning: Parameter's user-configured value was adjusted. (ONLIDX_MAXMEM)
Reading configuration file '/gbase/rdbms/etc/onconfig.ol_gbasedbt1210'...succeeded
Creating /GBASEDBTTMP/.infxdirs...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 8310 kbytes...succeeded
Creating infos file "/gbase/rdbms/etc/.infos.ol_gbasedbt1210"...succeeded
Linking conf file "/gbase/rdbms/etc/.conf.ol_gbasedbt1210"...succeeded
Initializing rhead structure...rhlock_t 16384 (512K)... rlock_t (5312K)... Writing to infos file...succeeded
Initialization of Encryption...succeeded
Initializing ASF...succeeded
Initializing Dictionary Cache and SPL Routine Cache...succeeded
Bringing up ADM VP...succeeded
Creating VP classes...succeeded
Forking main_loop thread...succeeded
Initializing DR structures...succeeded
Forking 1 'soctcp' listener threads...succeeded
Forking 1 'soctcp' listener threads...succeeded
Forking 1 'soctcp' listener threads...succeeded
Starting tracing...succeeded
Initializing 2 flushers...succeeded
Initializing SDS Server network connections...succeeded
Initializing log/checkpoint information...succeeded
Initializing dbspaces...succeeded
Opening primary chunks...succeeded
Validating chunks...succeeded
Initialize Async Log Flusher...succeeded
Starting B-tree Scanner...succeeded
Init ReadAhead Daemon...succeeded
Init DB Util Daemon...succeeded
Initializing DBSPACETEMP list...succeeded
Init Auto Tuning Daemon...succeeded
Checking database partition index...succeeded
Initializing dataskip structure...succeeded
Checking for temporary tables to drop...succeeded
Updating Global Row Counter...succeeded
Forking onmode_mon thread...succeeded
Creating periodic thread...succeeded
Creating periodic thread...succeeded
Starting scheduling system...succeeded
Verbose output complete: mode = 5

查看状态

[gbasedbt@cjc-db-01 ~]$ onstat -
Your evaluation license will expire on 2023-11-12 00:00:00
On-Line -- Up 00:00:31 -- 175748 Kbytes

登录数据库

[gbasedbt@cjc-db-01 ~]$ dbaccess - -
Your evaluation license will expire on 2023-11-12 00:00:00
>

创建数据库，报错

> create database cjcdb with log;
  
  908: Attempt to connect to database server (ol_gbasedbt1210) failed.
  
  201: A syntax error has occurred.
Error in line 1
Near character position 1
>

修改文件

[gbasedbt@cjc-db-01 ~]$ cd /gbase/rdbms/etc/
[gbasedbt@cjc-db-01 etc]$ cp sqlhosts.ol_gbasedbt1210 sqlhosts.ol_gbasedbt1210_bak
[gbasedbt@cjc-db-01 etc]$ vi sqlhosts.ol_gbasedbt1210

原文件

ol_gbasedbt1210 onsoctcp cjc-db-01 ol_gbasedbt1210
dr_gbasedbt1210 drsoctcp cjc-db-01 dr_gbasedbt1210
lo_gbasedbt1210 onsoctcp 127.0.0.1 lo_gbasedbt1210

将主机名改成IP

ol_gbasedbt1210 onsoctcp 192.168.126.128 ol_gbasedbt1210
dr_gbasedbt1210 drsoctcp 192.168.126.128 dr_gbasedbt1210
lo_gbasedbt1210 onsoctcp 127.0.0.1 lo_gbasedbt1210

重启数据库

停库

[gbasedbt@cjc-db-01 ~]$ onmode -ky

启库

[gbasedbt@cjc-db-01 ~]$ oninit -vy

重新创建数据库，成功

[gbasedbt@cjc-db-01 etc]$ dbaccess - -
Your evaluation license will expire on 2023-11-12 00:00:00
> create database cjcdb with log;
  
Database created.

创建测试数据

> create table t1(id int,name varchar(10));
> insert into t1 values(1,'aaa');
> insert into t1 values(2,'bbb');
> select * from t1;
         id name       
          1 aaa       
          2 bbb       
  
2 row(s) retrieved.

欢迎关注我的公众号《IT小Chen》