GBase 8s使用脚本自动创建和初始化实例

[root@localhost ~]# cd /opt/GBASE/gbase

[root@localhost gbase]# chown -R gbasedbt:gbasedbt GBaseInit_gbasedbt.sh

[root@localhost gbase]# ls -l GBaseInit_gbasedbt.sh

-rw-r--r--. 1 gbasedbt gbasedbt 32705 Jan 15 10:10 GBaseInit_gbasedbt.sh 

[root@localhost gbase]# su gbasedbt

[gbasedbt@localhost gbase]$ sh GBaseInit_gbasedbt.sh 

Initializing Program...OK

ENTER THE INSTANCE INFORMATION or PRESS <ENTER> TO ACCEPT THE DEFAULT.

// 创建实例名称，默认为 gbaseserver  

ENTER GBASE INSTANCE NAME (GBASEDBTSERVER) [Default:gbaseserver]: 

//选择安装目录。默认为 /opt/GBASE/gbase 

GBASE INSTALL FOLDER LIST:

 1) /opt/GBASE/gbase

CHOOSE GBASE INSTALL FOLDER(GBASEDBTDIR) [Default:/opt/GBASE/gbase]: 

//选择本机 IP 地址

CHOOSE SERVICE IP ADDRESS FROM THE LIST:

 1) 192.168.127.101

 2) 127.0.0.1

 ENTER THE NUMBER FOR YOUR CHOICE [Default:192.168.127.101]: 

//指定数据库的监听端口，缺省为 9088 

SPECIFY THE PORT NUMBER FOR GBASE [Default:9088]: 

//选择安装方式： 2 定制安装

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]: 2

//输入数据库空间存储路径

ENTER THE DATA SPACE PATH [Default:/opt/GBASE/gbase/gbaseserver_dbs]: 

//设置逻辑日志空间大小

ENTER THE LOGICAL LOG DBSPACE SIZE(MB) [Default:540]: 

//设置物理日志空间大小

ENTER THE PHYSICAL LOG DBSPACE SIZE(MB) [Default:540]: 

//设置智能大对象空间大小

ENTER THE SMART LOB DBSPACE SIZE(MB) [Default:138]: 

//设置临时数据空间大小

ENTER THE TEMPORARY DBSPACE SIZE(MB) [Default:138]: 

// 输入 Y 启动以上设置，N 重新进行配置

ENTER "Y" TO START DATABASE ADVANCED SETTINGS, OR ENTER "N" TO ACCEPT DEFAULT VALUES: [Default:Y]: Y

ENTER THE NUMBER OF DATA DBSPACES [Default:1]: 

ENTER THE NUMBER OF TEMP DBSPACES [Default:1]:

//实例配置如下所示：

INSTANCE SUMMARY:

  Instance name:               gbaseserver

  GBase install directory:     /opt/GBASE/gbase

  IP address & port:           192.168.127.101:9088

  Character set:               zh_CN.GB18030-2000

  Logical log space size:      430 MB

  Physical log space size:     430 MB

  Smart LOB space size:        116 MB

  Temp DBSpace size:           116 MB

  Data path:                   /opt/GBASE/gbase/gbaseserver_dbs

  Data path free size:         4292 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: 

Enter "Y" to Start database initializing, or Enter "N" to Edit Again: Y

Touching Chunks...OK

Create sqlhosts File:  /opt/GBASE/gbase/etc/sqlhosts.gbaseserver ...OK

Setting Parameters in /opt/GBASE/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 40 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.38.39.40...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.8.123:9088/gbasedb:GBASEDBTSERVER=gbaseserver;

Version:

GBase Database Server Version 12.10.FC4G1AEE -- On-Line -- Up 00:00:13 -- 1121592 Kbytes

Build Number:       2.0.1A2_N303

GBase Initializing Finished!

Initialize log file : ./InitGBaseDB_201901081452.log 

Press <ENTER> to Exit and Logout...