1、下载安装介质【https://www.gbase.cn/download/gbase-8s-1?category=INSTALL_PACKAGE】
2、创建【gbasedbt】用户组和用户，使用【root】用户执行：
groupadd gbasedbt -g 500
useradd gbasedbt -u 500 -g gbasedbt -m -d /home/gbasedbt
echo "GBase123" | passwd --stdin gbasedbt
3、解压安装介质，静默安装，安装到目录【/opt/gbase】，【root】用户执行：
tar -xvf GBase8s*.tar
./ids_install -i silent -DLICENSE_ACCEPTED=TRUE -DUSER_INSTALL_DIR=/opt/gbase
4、【gbasedbt】用户执行初始化脚本，如没有可下载【GBaseInit_gbasedbt_V1.18.sh】：
cd /opt/gbase/etc
[gbasedbt@dbhost1 etc]$ sh GBaseInit_gbasedbt.sh
Initializing Program...OK
ENTER THE INSTANCE INFORMATION or PRESS <ENTER> TO ACCEPT THE DEFAULT.
ENTER GBASE INSTANCE NAME (GBASEDBTSERVER) [Default:gbaseserver]:
GBASE INSTALL FOLDER LIST:
1) /opt/gbase
CHOOSE GBASE INSTALL FOLDER(GBASEDBTDIR) [Default:/opt/gbase]:
CHOOSE SERVICE IP ADDRESS FROM THE LIST: #选择要监听的IP
1) 192.168.17.101
2) 127.0.0.1
3) 192.168.122.1
ENTER THE NUMBER FOR YOUR CHOICE [Default:192.168.17.101]:
SPECIFY THE PORT NUMBER FOR GBASE [Default:9088]: #选择要监听的端口
INITIALIZE TYPE:
1) TYPICAL -- Initialize the instance with all features configured with default values.
2) CUSTOM -- Initialize the instance with specific features that you need.
ENTER THE NUMBER FOR YOUR CHOICE [Default:1]: 2 #2，自定义字符集
GBASE CHARACTER SET LIST:
1) en_US.8859-1
2) zh_CN.GB18030-2000
3) zh_CN.utf8
ENTER THE NUMBER FOR YOUR CHOICE [Default:1]: 3 #3，推荐utf8
ENTER THE DATA SPACE PATH [Default:/opt/gbase/gbaseserver_dbs]: #数据存放路径
ENTER THE LOGICAL LOG DBSPACE SIZE(MB) [Default:370]: #逻辑日志总大小，可默认
ENTER THE PHYSICAL LOG DBSPACE SIZE(MB) [Default:370]: #物理日志大小，可默认
ENTER THE SMART LOB DBSPACE SIZE(MB) [Default:104]: #只能大对象空间大小，存放blob/clob，可默认
ENTER THE TEMPORARY DBSPACE SIZE(MB) [Default:104]: 临时空间大小，可默认
ENTER "Y" TO START DATABASE ADVANCED SETTINGS, OR ENTER "N" TO ACCEPT DEFAULT VALUES: [Default:N]: y #输入y
ENTER THE NUMBER OF DATA DBSPACES [Default:1]: #默认回车
ENTER THE NUMBER OF TEMP DBSPACES [Default:1]: #默认回车
Enter "Y" TO ENABLE ENVIRONMENT GL_USEGLU, OR ENTER "N" TO DISABLE: [Default:N]: y #输入y，设置GL_USEGLU环境变量，支持更多生僻字
INSTANCE SUMMARY:
Instance name: gbaseserver
GBase install directory: /opt/gbase
IP address & port: 192.168.17.101:9088
Character set: zh_CN.utf8
Logical log space size: 370 MB
Physical log space size: 370 MB
Smart LOB space size: 104 MB
Temp DBSpace size: 104 MB
Data path: /opt/gbase/gbaseserver_dbs
Data path free size: 3700 MB
The number of data DBSpace: 1
The number of temp DBSpace: 1
Environment GL_USEGLU: 1
Enter "Y" to Start database initializing, or Enter "N" to Edit Again: y #输入y
Touching Chunks...OK
Create sqlhosts File: /opt/gbase/etc/sqlhosts.gbaseserver ...OK
Setting Parameters in /opt/gbase/etc/onconfig.gbaseserver :
ROOTPATH.ROOTSIZE.DBSERVERNAME.FULL_DISK_INIT.SBSPACENAME.SYSSBSPACENAME.DBSPACETEMP.LOGFILES.MULTIPROCESSOR.VPCLASS.NETTYPE.CLEANERS.DEF_TABLE_LOCKMODE.DIRECT_IO.LOCKS.TAPEDEV.LTAPEDEV.CKPTINTVL.DS_MAX_QUERIES.DS_TOTAL_MEMORY.DS_NONPDQ_QUERY_MEM.PHYSBUFF.LOGBUFF.AUTO_TUNE.MSGPATH.SERVERNUM.ALLOW_NEWLINE.TEMPTAB_NOLOG.DUMPSHMEM.USEOSTIME.STACKSIZE.ON_RECVRY_THREADS.OFF_RECVRY_THREADS.USELASTCOMMITTED.SHMVIRTSIZE.SHMADD.GBASEDBTCONTIME.BUFFERPOOL2K.BUFFERPOOL16K...AUTO_CKPTS.OK
Initializing Root DBSpace & Share Memory...OK
Creating system database.......OK
Creating logical log Dbspace...OK
Creating physical log Dbspace...OK
Creating smart LOB Dbspace...OK
Creating temp Dbspace.1...OK
Creating data Dbspace.1...OK
Setting dbscheduler...OK
Moving physical log...OK
Adding 37 logical logs: 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37...OK
Setting data chunks extendable...OK
Cleaning logical logs in rootdbs.........OK
Database restarting.......OK
Creating database: gbasedb...OK
Now you can use this URL to connect to gbasedb:
jdbc:gbasedbt-sqli://192.168.17.101:9088/gbasedb:GBASEDBTSERVER=gbaseserver;DB_LOCALE=zh_CN.utf8;CLIENT_LOCALE=zh_CN.utf8;NEWCODESET=UTF8,utf8,57372;GL_USEGLU=1
Version:
On-Line -- Up 00:00:14 -- 674664 Kbytes
Build Number: 3.3.0_N303
GBase Initializing Finished!
Initialize log file : ./InitGBaseDB_202404251625.log
Press <ENTER> to Exit and Logout... #回车
Killed
[root@dbhost1 ~]#
[root@dbhost1 ~]# su - gbasedbt
Last login: Thu Apr 25 16:24:01 CST 2024 on pts/0
[gbasedbt@dbhost1 ~]$ onstat - #检查数据库状态，On-Line正常
On-Line -- Up 00:00:22 -- 674664 Kbytes
[gbasedbt@dbhost1 ~]$ dbaccess gbasedb - #连接数据库执行sql
数据库已被选用。
> select/update/insert/delete ...... #在这里输入要执行的sql语句，自动commit，无需commit
可使用【dbaccess gbasedb -】命令连接数据库执行sql。
参考文档【GBase 8s DB-Access 用户指南.pdf】
可使用官方数据库管理工具连接数据库【GBaseDataStudio下载】，无需安装，解压即用。
参考文档【GBase 8s GBaseDataStudio管理工具手册.pdf】
如需从其他数据库迁移数据，使用官方迁移工具【GBase8sMTK下载】，无需安装，解压即用。
参考文档【GBase 8s MTK迁移工具使用手册.pdf】
更多文档下载，点击这里【文档下载】