1.安装数据库软件
1.1 创建系统用户
groupadd gbasedbt
useradd -g gbasedbt gbasedbt
passwd gbasedbt
1.2 创建安装目录,上传安装文件并解压
[root@localhost ~]# mkdir /usr/local/GBASE/gbase
[root@localhost ~]# cd /usr/local/GBASE/
[root@localhost GBASE]# ls x86+RHEL6.zip
[root@localhost GBASE]# unzip x86+RHEL6.zip
Archive: x86+RHEL6.zip creating:
x86+RHEL6/GBase8sV8.8_3.3.0_2_RHEL6_x86_64/ inflating: x86+RHEL6/GBase8sV8.8_3.3.0_2_RHEL6_x86_64/GBase8sV8.8_TL_3.3.0_2_36477d_RHEL6_x86_64.tar inflating:
x86+RHEL6/GBase8sV8.8_3.3.0_2_RHEL6_x86_64/clientsdk_3.3.0_2_36477d_RHEL6_x86_64.tar inflating: x86+RHEL6/GBase8sV8.8_3.3.0_2_RHEL6_x86_64/gbasedbtjdbc_3.3.0_2_36477d.jar
[root@localhost GBASE]# cd x86+RHEL6/GBase8sV8.8_3.3.0_2_RHEL6_x86_64/
[root@localhost GBase8sV8.8_3.3.0_2_RHEL6_x86_64]# ls
clientsdk_3.3.0_2_36477d_RHEL6_x86_64.tar gbasedbtjdbc_3.3.0_2_36477d.jar GBase8sV8.8_TL_3.3.0_2_36477d_RHEL6_x86_64.tar
[root@localhost GBase8sV8.8_3.3.0_2_RHEL6_x86_64]# tar -xf Base8sV8.8_TL_3.3.0_2_36477d_RHEL6_x86_64.tar
[root@localhost GBase8sV8.8_3.3.0_2_RHEL6_x86_64]# ls
clientsdk_3.3.0_2_36477d_RHEL6_x86_64.tar gbasedbtjdbc_3.3.0_2_36477d.jar onsecurity doc ids_install GBase8sV8.8_TL_3.3.0_2_36477d_RHEL6_x86_64.tar ids.properties
1.3 执行安装
执行./ids_install安装程序,一直按enter继续
接受所有协议
修改安装目录
按回车,默认选择 1-典型安装
选择2-不创建实例
一路回车
看到此界面数据库软件就安装成功了
2.数据库配置
2.1 编辑gasedbt的.bash_profile文件添加一下环境变量
具体变量值可以根据自己环境的实际情况去设置
export GBASEDBTDIR=/usr/local/GBASE/gbase export GBASEDBTSERVER=gbaseserver export ONCONFIG=onconfig.gbaseserver export GBASEDBTSQLHOSTS=/usr/local/GBASE/gbase/etc/sqlhosts.gbaseserver export GL_USEGLU=1 export PATH=${GBASEDBTDIR}/bin:${GBASEDBTDIR}/extend/krakatoa/jre/bin:${PATH} export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$GBASEDBTDIR/lib:$GBASEDBTDIR/lib/esql:$GBASEDBTDIR/lib/cli export TERM=vt100 export TERMCAP=${GBASEDBTDIR}/etc/termcap #以下参数根据实际情况配置 export GL_DATE="%iY-%m-%d" export DATETIME="%iY-%m-%d %H:%M:%S" export DB_LOCALE=zh_cn.GB18030-2000 export CLIENT_LOCALE=zh_cn.GB18030-2000
执行命令,使环境变量生效
[gbasedbt@localhost ~]$ source .bash_profile
2.2 配置 onconfig.gbaseserver 参数文件
将 ${GBASEDBTDIR}/etc/ 目录中的 onconfig.std 文档复制一份,命名为 $ONCONFIG 变量指定的名称 onconfig.gbaseserver。
[gbasedbt@localhost ~]$ cd ${GBASEDBTDIR}/etc/ [gbasedbt@localhost etc]$ cp onconfig.std onconfig.gbaseserver
vi onconfig.gbaseserver 文件,配置以下参数并保存:
ROOTPATH /opt/GBASE/gbase/dbs/rootchk //系统数据库文件存储空间路径,
SERVERNUM 1 //实例编号,多实例中每个实例编号要唯一
DBSERVERNAME gbaseserver //数据库服务器实例名称
TAPEDEV /dev/null //用于存储空间备份的磁带设备
LTAPEDEV /dev/null //用于逻辑日志备份的磁带的设备路径
2.3 配置 sqlhosts.gbaseserver 文件
GBase 8s 数据库使用的监听端口默认为 9088,多实例中每个实例的端口必须唯一。
将 ${GBASEDBTDIR}/etc/ 目录中的 sqlhosts.std 文档复制一份,命名为GBASEDBTDQLHOSTS 变量指定的名称 sqlhost.gbaseserver。
[gbasedbt@localhost ~]$cd /opt/GBASE/gbase/etc/
[gbasedbt@localhost etc]$ cp sqlhosts.std sqlhosts.gbaseserver
vi sqlhosts.gbaseserver 文件,在文件末尾添加相关实例名、网络连接方式、IP 及端口
号。
[gbasedbt@localhost etc]$ vi sqlhosts.gbaseserver
在文件末尾按照如下格式添加内容并保存:
实例名 网络连接方式 IP 端口
gbaseserver onscoptcp * 9088
2.4 创建数据文件
[gbasedbt@localhost gbase]$ mkdir -p ${GBASEDBTDIR}/dbs/ [gbasedbt@localhost gbase]$ cd ${GBASEDBTDIR}/dbs/ [gbasedbt@localhost dbs]$ touch rootchk [gbasedbt@localhost dbs]$ ll total 0 -rw-rw-r-- 1 gbasedbt gbasedbt 0 Dec 28 10:48 rootchk [gbasedbt@localhost dbs]$ chmod 600 rootchk
2.5 初始化数据库
使用 gbasedbt 用户执行初始化命令:
[gbasedbt@localhost ~]$ oninit -ivy
看到下面的信息为初始化成功,初始化报错可以查看 ${GBASEDBTDIR}/tmp/online.log 日志排查解决
2.6 创建新的dbspace
执行以下命令添加dbspace
[gbasedbt@localhost dbs]$ cd ${GBASEDBTDIR}/dbs/
[gbasedbt@localhost dbs]$ touch plogchk llogchk datachk1 tmpchk1 sbchk1
onspaces -c -d plogdbs -p ${GBASEDBTDIR}/dbs/plogchk -o 0 -s 204800
onspaces -c -d llogdbs -p ${GBASEDBTDIR}/dbs/llogchk -o 0 -s 512000
onspaces -c -d datadbs1 -p ${GBASEDBTDIR}/dbs/datachk1 -o 0 -s 512000 -k 8
onspaces -c -d tmpdbs1 -p ${GBASEDBTDIR}/dbs/tmpchk1 -o 0 -s 512000 -k 8 -t
onspaces -c -S sbdbs1 -p ${GBASEDBTDIR}/dbs/sbchk1 -o 0 -s 204800
[gbasedbt@localhost dbs]$ cd ${GBASEDBTDIR}/dbs/
[gbasedbt@localhost dbs]$ touch plogchk llogchk datachk1 tmpchk1 sbchk1
[gbasedbt@localhost dbs]$ chmod 600 *
[gbasedbt@localhost dbs]$ onspaces -c -d plogdbs -p ${GBASEDBTDIR}/dbs/plogchk -o 0 -s 204800
Your evaluation license will expire on 2023-12-28 00:00:00
Verifying physical disk space, please wait ...
Space successfully added.
** WARNING ** A level 0 archive of Root DBSpace will need to be done.
[gbasedbt@localhost dbs]$ onspaces -c -d llogdbs -p ${GBASEDBTDIR}/dbs/llogchk -o 0 -s 512000
Your evaluation license will expire on 2023-12-28 00:00:00
Verifying physical disk space, please wait ...
Space successfully added.
** WARNING ** A level 0 archive of Root DBSpace will need to be done.
[gbasedbt@localhost dbs]$ onspaces -c -d datadbs1 -p ${GBASEDBTDIR}/dbs/datachk1 -o 0 -s 512000 -k 8
Your evaluation license will expire on 2023-12-28 00:00:00
Verifying physical disk space, please wait ...
Space successfully added.
** WARNING ** A level 0 archive of Root DBSpace will need to be done.
[gbasedbt@localhost dbs]$ onspaces -c -d tmpdbs1 -p ${GBASEDBTDIR}/dbs/tmpchk1 -o 0 -s 512000 -k 8 -t
Your evaluation license will expire on 2023-12-28 00:00:00
Verifying physical disk space, please wait ...
Space successfully added.
[gbasedbt@localhost dbs]$ onspaces -c -S sbdbs1 -p ${GBASEDBTDIR}/dbs/sbchk1 -o 0 -s 204800
Your evaluation license will expire on 2023-12-28 00:00:00
Verifying physical disk space, please wait ...
Space successfully added.
** WARNING ** A level 0 archive of Root DBSpace will need to be done.
[gbasedbt@localhost dbs]$
执行5次
onparams -a -d llogdbs -s 100000
[gbasedbt@localhost dbs]$ onparams -a -d llogdbs -s 100000
Your evaluation license will expire on 2023-12-28 00:00:00
Log operation started. To monitor progress, use the onstat -l command.
Logical log successfully added.
[gbasedbt@localhost dbs]$ onparams -a -d llogdbs -s 100000
Your evaluation license will expire on 2023-12-28 00:00:00
Log operation started. To monitor progress, use the onstat -l command.
Logical log successfully added.
[gbasedbt@localhost dbs]$ onparams -a -d llogdbs -s 100000
Your evaluation license will expire on 2023-12-28 00:00:00
Log operation started. To monitor progress, use the onstat -l command.
Logical log successfully added.
[gbasedbt@localhost dbs]$ onparams -a -d llogdbs -s 100000
Your evaluation license will expire on 2023-12-28 00:00:00
Log operation started. To monitor progress, use the onstat -l command.
Logical log successfully added.
[gbasedbt@localhost dbs]$ onparams -a -d llogdbs -s 100000
Your evaluation license will expire on 2023-12-28 00:00:00
Log operation started. To monitor progress, use the onstat -l command.
Logical log successfully added.
[gbasedbt@localhost dbs]$
onmode -l 执行6次,切换到新创建的数据空间
[gbasedbt@localhost dbs]$ onmode -l Your evaluation license will expire on 2023-12-28 00:00:00
[gbasedbt@localhost dbs]$ onmode -l Your evaluation license will expire on 2023-12-28 00:00:00
[gbasedbt@localhost dbs]$ onmode -l Your evaluation license will expire on 2023-12-28 00:00:00
[gbasedbt@localhost dbs]$ onmode -l Your evaluation license will expire on 2023-12-28 00:00:00
[gbasedbt@localhost dbs]$ onmode -l Your evaluation license will expire on 2023-12-28 00:00:00
[gbasedbt@localhost dbs]$ onmode -l Your evaluation license will expire on 2023-12-28 00:00:00
迁移到新创建的dbspace
删除安装默认的6个逻辑日志
[gbasedbt@localhost dbs]$ onparams -d -l 1 -y
Your evaluation license will expire on 2023-12-28 00:00:00
Logical log 1 successfully dropped.
[gbasedbt@localhost dbs]$ onparams -d -l 2 -y
Your evaluation license will expire on 2023-12-28 00:00:00
Logical log 2 successfully dropped.
[gbasedbt@localhost dbs]$ onparams -d -l 3 -y
Your evaluation license will expire on 2023-12-28 00:00:00
Logical log 3 successfully dropped.
[gbasedbt@localhost dbs]$ onparams -d -l 4 -y
Your evaluation license will expire on 2023-12-28 00:00:00
Logical log 4 successfully dropped.
[gbasedbt@localhost dbs]$ onparams -d -l 5 -y
Your evaluation license will expire on 2023-12-28 00:00:00
Logical log 5 successfully dropped.
[gbasedbt@localhost dbs]$ onparams -d -l 6 -y
Your evaluation license will expire on 2023-12-28 00:00:00
Logical log 6 successfully dropped.
[gbasedbt@localhost dbs]$
物理日志迁移出root
onparams -p -d plogdbs -s 200000 -y
3.开机自启动
vi /usr/lib/systemd/system/gbasedbtd.service
[Unit] Description=GBase 8s Database Server Wants=network-online.target After=network.target network-online.target [Service] Type=oneshot User=gbasedbt Group=gbasedbt RemainAfterExit=yes EnvironmentFile=/etc/sysconfig/gbasedbtd_service ExecStart=/usr/local/GBASE/gbase/bin/oninit ExecStop=/usr/local/GBASE/gbase/bin/onmode -ky #Restart=on-abort [Install] WantedBy=multi-user.target
vi /etc/sysconfig/gbasedbtd_service
gbasedbtd.service environmental variables GBASEDBTDIR=/usr/local/GBASE/gbase GBASEDBTSERVER=gbaseserver ONCONFIG=onconfig.gbaseserver GBASEDBTSQLHOSTS=/usr/local/GBASE/gbase/etc/sqlhosts.gbaseserver
[root@localhost]# systemctl enable gbasedbtd.service
Created symlink from /etc/systemd/system/multi-user.target.wants/gbasedbtd.service to /usr/lib/systemd/system/gbasedbtd.service
4. 创建数据库并授权
gbasedbt用户执行:
onmode -wf USERMAPPING='ADMIN'
dbaccess sysuser - <<!
CREATE DEFAULT USER WITH PROPERTIES USER 'daemon';
!
创建用户:
dbaccess sysuser -<<! CREATE USER testuser WITH PASSWORD "GBase123"; !
执行dbaccess - -命令按照以下命令创建数据库
也可以使用dbaccess 进入dbaccess字符界面,选择 Database ,选择Create,输入创建的库名,选择Dbspace,选择Log,进入选择需要的日志型,使用默认的Nlscase,选择Exit(相当于创建了SQL语句),选择Create-new-database,完成库创建
[gbasedbt@localhost etc]$ dbaccess - -
Your evaluation license will expire on 2023-12-28 00:00:00
create database test2 with log;
Database created.
database test2
;
Database closed.
Database selected.
grant dba to testuser;
Permission granted.