GBase 8s 部署（centos7）

目录

创建用户

安装

初始化数据库实例

数据库启动停止

连接数据库

---

创建用户

[root@localhost ~]# useradd gbasedbt
[root@localhost ~]# passwd gbasedbt

[root@localhost opt]# mkdir -p /opt/GBASE/gbase
[root@localhost opt]# chown gbasedbt:gbasedbt /opt/GBASE/gbase

[root@localhost opt]# ll /opt
-rw-r--r--. 1 root root 316692480 Feb  6 20:11 GBase8sV8.8_TL_3.3.0_2_36477d_RHEL6_x86_64.tar
[root@localhost opt]# tar -xvf GBase8sV8.8_TL_3.3.0_2_36477d_RHEL6_x86_64.tar

[root@localhost opt]# ll
drwxr-xr-x. 2 root root        77 Mar 23  2021 doc
-rwxr-xr-x. 1 root root 316579352 Mar 23  2021 ids_install
-rw-r--r--. 1 root root      1864 Mar 23  2021 ids.properties
-rwxr-xr-x. 1 root root     82738 Mar 23  2021 onsecurity

[root@localhost etc]# yum install -y net-tools
[root@localhost etc]# ifconfig
ens33: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        inet 192.168.61.103  netmask 255.255.255.0  broadcast 192.168.61.255

安装

[root@localhost opt]# cd /opt/
[root@localhost opt]# sh ids_install 

PRESS <ENTER> TO CONTINUE:回车
DO YOU ACCEPT THE TERMS OF THIS LICENSE AGREEMENT? (Y/N): Y

#安装路径
  Default Install Folder: /opt/GBASE/gbase

ENTER AN ABSOLUTE PATH, OR PRESS <ENTER> TO ACCEPT THE DEFAULT:回车（上面那行显示的是默认安装路径）

#自定义安装
->1- Typical installation
    2- Custom installation
    3- Extract the product files (-DLEGACY option)
    4- Create a RPM package for redistribution

ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS <ENTER> TO ACCEPT THE DEFAULT:: 2

#一律回车
Please choose the Features to be installed by this installer.: ___

If you want to install both ABC and XYZ, type:  2
If you want to install only XYZ, type:          1,2

PRESS <ENTER> TO CONTINUE: 回车

#一律回车
21-     |-[X] Database import and export utilities
   22-  |-[X] JSON Client Support
   23- [X] Global Language Support (GLS)
   24-  |-[X] Chinese

Please choose the Features to be installed by this installer.: 回车

#一律回车
Would you like to review the features that you have selected, or change which 
features you have selected?

  ->1- Continue
    2- Return to feature tree

ENTER THE NUMBER OF THE DESIRED CHOICE, OR PRESS <ENTER> TO ACCEPT THE 
   DEFAULT: 回车

#一律回车
If you do not enable role separation, the database server administrator 
performs all administration tasks.

    1- Enable role separation
  ->2- Do not enable role separation

ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS <ENTER> TO ACCEPT THE DEFAULT:: 回车

#不要创建数据库实例  默认创建的很耗费资源
Create a database server instance?

    1- Yes - create a server instance
  ->2- No - do not create a server instance

ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS <ENTER> TO ACCEPT THE DEFAULT:: 2


#检查安装信息无问题 回车
Installation Summary
--------------------

Please review the following before continuing:

Product Name:
    GBase Software Bundle

Install Folder:
    /opt/GBASE/gbase

Product Features:
    GBase database server,
    Base Server,
    Extensions and tools,
    J/Foundation,
    Database extensions,
    Conversion and reversion support,
    XML publishing,
    Demonstration database scripts,
    Enterprise Replication,
    Data loading utilities,
    onunload and onload utilities,
    dbload utility,
    Backup and Restore,
    archecker utility,
    ON-Bar utility,
    Interface to Tivoli Storage Manager,
    Administrative utilities,
    Performance monitoring utilities,
    Miscellaneous monitoring utilities,
    Auditing utilities,
    Database import and export utilities,
    JSON Client Support,
    Global Language Support (GLS),
    Chinese

Disk Space Information (for Installation Target): 
    Required:  496,188,997 Bytes
    Available: 15,283,138,560 Bytes

PRESS <ENTER> TO CONTINUE: 回车

#检查安装路径 无问题回车
InstallAnywhere is now ready to install GBase Software Bundle onto your system 
at the following location:

   /opt/GBASE/gbase

PRESS <ENTER> TO INSTALL: 回车

#安装完成
Installation Complete
---------------------

Congratulations! GBase Software Bundle installation is complete.

Product install status:
GBase: Successful
GBase Connect: Successful

GBase 8s V8.8


For more information about using GBase products, see the GBase Information 
Center at http://www.gbase.cn.

PRESS <ENTER> TO EXIT THE INSTALLER: 回车

初始化数据库实例

这里是自动化初始化的数据库实例，也可以手工初始化（后面有时间补充）

[root@localhost opt]# cd /opt/GBASE/gbase/etc/
[root@localhost etc]# chown -R gbasedbt:gbasedbt GBaseInit_gbasedbt.sh 
[root@localhost etc]# su - gbasedbt
[gbasedbt@localhost ~]$ cd /opt/GBASE/gbase/etc/
[gbasedbt@localhost etc]$ sh GBaseInit_gbasedbt.sh 

#输入实例名 默认GBASEDBTSERVER
ENTER GBASE INSTANCE NAME (GBASEDBTSERVER) [Default:gbaseserver]: 回车
#输入安装路径 默认/opt/GBASE/gbase
CHOOSE GBASE INSTALL FOLDER(GBASEDBTDIR) [Default:/opt/GBASE/gbase]: 回车
#选择IP地址
CHOOSE SERVICE IP ADDRESS FROM THE LIST:
 1) 192.168.61.103
 2) 127.0.0.1
ENTER THE NUMBER FOR YOUR CHOICE [Default:192.168.61.103]: 1
#输入端口号 默认9088
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
#选择字符集
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
#下面这些配置根据实际情况配置 一般直接回车即可 我的是虚拟机 少分配一些空间
ENTER THE NUMBER FOR YOUR CHOICE [Default:1]: 3
//数据库空间存储路径
ENTER THE DATA SPACE PATH [Default:/opt/GBASE/gbase/gbaseserver_dbs]: 
//逻辑日志空间大小
ENTER THE LOGICAL LOG DBSPACE SIZE(MB) [Default:1460]: 回车
//物理日志空间大小
ENTER THE PHYSICAL LOG DBSPACE SIZE(MB) [Default:1460]: 回车
//大对象空间大小
ENTER THE SMART LOB DBSPACE SIZE(MB) [Default:322]: 回车
//临时数据空间大小
ENTER THE TEMPORARY DBSPACE SIZE(MB) [Default:322]: 回车
//以上配置 输入Y启动安装 输入N重新配置
ENTER "Y" TO START DATABASE ADVANCED SETTINGS, OR ENTER "N" TO ACCEPT DEFAULT VALUES: [Default:N]: Y
//数据空间数 默认即可
ENTER THE NUMBER OF DATA DBSPACES [Default:1]: 5
//临时空间数 默认即可
ENTER THE NUMBER OF TEMP DBSPACES [Default:1]: 5
//这个不知道啥意思 Y
Enter "Y" TO ENABLE ENVIRONMENT GL_USEGLU, OR ENTER "N" TO DISABLE: [Default:N]: Y
//显示所有配置信息
INSTANCE SUMMARY:
  Instance name:               gbaseserver
  GBase install directory:     /opt/GBASE/gbase
  IP address & port:           192.168.61.103:9088
  Character set:               zh_CN.utf8
  Logical log space size:      100 MB
  Physical log space size:     100 MB
  Smart LOB space size:        100 MB
  Temp DBSpace size:           100 MB
  Data path:                   /opt/GBASE/gbase/gbaseserver_dbs
  Data path free size:         14515 MB
  The number of data DBSpace:  5
  The number of temp DBSpace:  5
  Environment GL_USEGLU:       1
//输入Y开始初始化
Enter "Y" to Start database initializing, or Enter "N" to Edit Again: Y

GBase Initializing Finished!

Initialize log file : ./InitGBaseDB_202302062145.log 

Press <ENTER> to Exit and Logout...

回车 初始化结束

数据库启动停止

[root@localhost etc]# su - gbasedbt

#启动
[gbasedbt@localhost ~]$ oninit -vy
#停止
[gbasedbt@localhost ~]$ onmode -ky

#验证是否启动
[gbasedbt@localhost ~]$ ps -ef | grep oninit
gbasedbt  29758      1  0 22:00 ?        00:00:00 oninit -vy
root      29760  29758  0 22:00 ?        00:00:00 oninit -vy
root      29761  29760  0 22:00 ?        00:00:00 oninit -vy

[gbasedbt@localhost ~]$ onstat -
Your evaluation license will expire on 2024-02-06 00:00:00
On-Line -- Up 00:11:27 -- 674664 Kbytes

连接数据库

[gbasedbt@localhost ~]$ su - gbasedbt
[gbasedbt@localhost ~]$ dbaccess - -
Your evaluation license will expire on 2024-02-06 00:00:00
> create database testDB with log;

Database created.