参考文档
以下链接有安装包的下载方式
https://blog.csdn.net/wiserhowe/article/details/120182208
https://blog.csdn.net/jihui8848/article/details/117996240?spm=1001.2014.3001.5501
准备虚拟机

安装操作系统




[root@gbase ~]# free -m
total used free shared buff/cache available
Mem: 3771 175 3350 11 245 3326
Swap: 4095 0 4095
[root@gbase ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/centos-root 95G 1.1G 94G 2% /
devtmpfs 1.9G 0 1.9G 0% /dev
tmpfs 1.9G 0 1.9G 0% /dev/shm
tmpfs 1.9G 12M 1.9G 1% /run
tmpfs 1.9G 0 1.9G 0% /sys/fs/cgroup
/dev/sda1 1014M 146M 869M 15% /boot
tmpfs 378M 0 378M 0% /run/user/0
[root@gbase ~]# ip a
1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN group default qlen 1000
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: ens32: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP group default qlen 1000
link/ether 00:0c:29:4e:bb:e9 brd ff:ff:ff:ff:ff:ff
inet 192.168.0.89/24 brd 192.168.0.255 scope global noprefixroute ens32
valid_lft forever preferred_lft forever
inet6 fe80::20c:29ff:fe4e:bbe9/64 scope link
valid_lft forever preferred_lft forever
[root@gbase ~]# cat /etc/redhat-release
CentOS Linux release 7.6.1810 (Core)
安装前的准备工作
创建用户
[root@gbase ~]# useradd gbasedbt
[root@gbase ~]# echo "gbasedbt" | passwd --stdin gbasedbt
Changing password for user gbasedbt.
passwd: all authentication tokens updated successfully.
上传并解压安装包
# 创建存放安装包的目录
[root@gbase ~]# mkdir /opt/soft
# 上传安装包
[root@gbase ~]# ls -lrt /opt/soft/
total 490192
-rw-r--r--. 1 root root 316692480 Feb 9 13:27 GBase8s_ExpressEdition.tar
-rw-r--r--. 1 root root 2506640 Feb 9 13:27 gbasedbtjdbc_ExpressEdition.jar
-rw-r--r--. 1 root root 256128 Feb 9 13:27 rlwrap
-rw-r--r--. 1 root root 182497280 Feb 9 13:27 clientsdk_ExpressEdition.tar
# 解压安装包
[root@gbase ~]# cd /opt/soft/
[root@gbase soft]# tar -xvf GBase8s_ExpressEdition.tar
doc/
doc/ids_machine_notes_12.10.txt
doc/ids_unix_relnotes_12.10.html
ids.properties
ids_install
onsecurity
.gbase.properties
[root@gbase soft]# ls -lrt
total 799440
drwxr-xr-x. 2 gbasedbt gbasedbt 77 Mar 23 2021 doc
-rwxr-xr-x. 1 gbasedbt gbasedbt 82738 Mar 23 2021 onsecurity
-rw-r--r--. 1 gbasedbt gbasedbt 1864 Mar 23 2021 ids.properties
-rwxr-xr-x. 1 gbasedbt gbasedbt 316579352 Mar 23 2021 ids_install
-rw-r--r--. 1 root root 316692480 Feb 9 13:27 GBase8s_ExpressEdition.tar
-rw-r--r--. 1 root root 2506640 Feb 9 13:27 gbasedbtjdbc_ExpressEdition.jar
-rw-r--r--. 1 root root 256128 Feb 9 13:27 rlwrap
-rw-r--r--. 1 root root 182497280 Feb 9 13:27 clientsdk_ExpressEdition.tar
关闭服务
systemctl stop firewalld.service
systemctl disable firewalld.service
systemctl stop NetworkManager.service
systemctl disable NetworkManager.service
sed -i "s/SELINUX=enforcing/SELINUX=disabled/g" /etc/selinux/config
setenforce 0
安装系统包
[root@gbase ~]# yum install -y unzip java tar net-tools
安装GBase 8s数据库组件
在root用户下,进入安装包目录,运行安装命令ids_install,启动安装程序。
[root@gbase ~]# cd /opt/soft/
[root@gbase soft]# ./ids_install
Preparing to install...
Extracting the JRE from the installer archive...
Unpacking the JRE...
Extracting the installation resources from the installer archive...
Configuring the installer for this system's environment...
Launching installer...
===============================================================================
GBase Software Bundle (created with InstallAnywhere)
-------------------------------------------------------------------------------
Preparing CONSOLE Mode Installation...
===============================================================================
Getting Started
---------------
This application will guide you through the installation of GBase Software
Bundle.
Copyright General Data Corporation 2014, 2023. All rights reserved.
1. Release Notes
The Release Notes can be found in /opt/soft/doc/ids_unix_relnotes_12.10.html.
2. Launch Information Center
Access the GBase Information Center at http://www.gbase.cn.
To Begin Installation, respond to each prompt to proceed to the next step in
the installation.
If you want to change something on a previous step, type 'back'.
You may cancel this installation at any time by typing 'quit'.
PRESS <ENTER> TO CONTINUE:
回车继续
===============================================================================
License Agreement
-----------------
Installation and Use of GBase Software Bundle Requires Acceptance of the
Following License Agreement:
Thank you for choosing GBase product!
Please read carefully the following licencing agreement before installing any
product: TIANJIN GENERAL DATA TECHNOLOGY CO. LTD. LICENSE AGREEMENT
READ THE TERMS OF THIS AGREEMENT AND ANY PROVIDED SUPPLEMENTAL LICENSETERMS
(COLLECTIVELY "AGREEMENT") CAREFULLY BEFORE OPENING THE SOFTWAREMEDIA PACKAGE.
BY OPENING THE SOFTWARE MEDIA PACKAGE, YOU AGREE TO THE TERMS OF THIS
AGREEMENT. IF YOU ARE ACCESSING THE SOFTWARE ELECTRONICALLY, INDICATE YOUR
ACCEPTANCE OF THESE TERMS. IF YOU DO NOT AGREE TO ALL THESE TERMS, PROMPTLY
RETURN THE UNUSED SOFTWARE TO YOUR PLACE OF PURCHASE FOR A REFUND.
1. LICENSE TO USE. GeneralData grants you a non-exclusive and non-transferable
license for the internal use only of the accompanying software and
documentation and any error corrections provided by GeneralData(collectively
"Software"), by the number of users and the class of computer hardware for
which the corresponding fee has been paid.
2. RESTRICTIONS. Software is confidential and copyrighted. Title to Software
PRESS <ENTER> TO CONTINUE:
回车继续
and all associated intellectual property rights is retained by GeneralData
and/or its licensors. Except as specifically authorized in any Supplemental
License Terms, you may not make copies of Software, other than a single copy
of Software for archival purposes. Unless enforcement is prohibited by
applicable law, you may not modify, decompile, or reverse engineer Software.
You acknowledge that Software is not designed, licensed or intended for use in
the design, construction, operation or maintenance of any nuclear facility.
GeneralData disclaims any express or implied warranty of fitness for such
uses. No right, title or interest in or to any trademark, service mark, logo or
trade name of GeneralData or its licensors is granted under this Agreement.
3. DISCLAIMER OF WARRANTY. Unless specified in this agreement, all express of
implied conditions, representations and warranties, including any implied
warranty of merchantability, fitness for aparticular purpose or
non-infringement are disclaimed, except to theextent that these disclaimers
are held to be legally invalid.
4. LIMITATION OF LIABILITY. To the extent not prohibited by law, in no event
will GeneralData or its licensors be liable for any lost revenue, profit or
data, or for special, indirect, consequential, incidental orpunitive damages,
however caused regardless of the theory of liability, arising out of or
related to the use of or inability to use software, even if GeneralData has
PRESS <ENTER> TO CONTINUE:
回车继续
been advised of the possibility of such damages. In no event will
GeneralData's libility to you, whether incontract, tort(including negligence),
or otherwise, exceed the amount paid by you for Software under this Agreement.
The foregoing limitations will apply even if the above stated warranty fails
of itsessential purpose.
5. TERMINATION. This Agreement is effective until terminated. You may terminate
this Agreement at any time by destroying all copies of Software. This
Agreement will terminate immediately without noticefrom GeneralData if you
fail to comply with any provision of this Agreement. Upon Termination, you
must destroy all copies of Software.
6. EXPORT REGULATIONS. All Software and technical data delivered under this
Agreement are subject to US export control laws and may be subject to export
or import regulations in other countries. You agree to comply strictly with
all such laws and regulations and acknowledge that you have the responsibility
to obtain such licenses to export, re-export, or import as may be required
after delivery to you.
7. CHINESE GOVERNMENT RESTRICTED. If Software is being acquired by or on behalf
PRESS <ENTER> TO CONTINUE:
回车继续
of the Chinese Government, then the Government's rights in Software and
accompanying documentation will be only as set forth in this Agreement.
8. GOVERNING LAW. Any action related to this Agreement will be governed by
Chinese law: "COPYRIGHT LAW OF THE PEOPLE'S REPUBLIC OF CHINA", "PATENT LAW OF
THE PEOPLE'S REPUBLIC OF CHINA", "TRADEMARK LAW OF THE PEOPLE'S REPUBLIC OF
CHINA", "COMPUTER SOFTWARE PROTECTION REGULATIONS OF THE PEOPLE'S REPUBLIC OF
CHINA". No choice of law rules of any jurisdiction will apply."
9. SEVERABILITY. If any provision of this Agreement is held to be
unenforceable, this Agreement will remain in effect with the provision
omitted, unless omission would frustrate the intent of the parties, in which
case this Agreement will immediately terminate.
10. INTEGRATION. This Agreement is the entire agreement between you and
GeneralData relating to its subject matter. It supersedes all prior or
contemporaneous oral or written communications, proposals, representations and
warranties and prevails over any conflicting or additional terms of any quote,
order, acknowledgment, or other communication between the parties relating to
its subject matter during the term of this Agreement. No modification of this
Agreement will be binding, unless in writing and signed by an authorize
depresentative of each party. When the translation document has the different
PRESS <ENTER> TO CONTINUE:
回车继续
meaning or has the conflicting views with Chinese original text conflict, should take the laws and regulations promulgation unit as well as the GeneralData issue Chinese original text as the standard. All trademarks and registered trademarks mentioned herein are the property of their respective owners. DO YOU ACCEPT THE TERMS OF THIS LICENSE AGREEMENT? (Y/N): y
接受License,输入y,按回车开始安装
===============================================================================
Installation Location
---------------------
Choose location for software installation.
Default Install Folder: /opt/GBASE/gbase
ENTER AN ABSOLUTE PATH, OR PRESS <ENTER> TO ACCEPT THE DEFAULT
: /opt/gbase
安装程序提示用户输入GBase 8s的安装路径,我们输入/opt/gbase。
INSTALL FOLDER IS: /opt/gbase IS THIS CORRECT? (Y/N): y
输入y,确认安装路径。
===============================================================================
Installation or Distribution
----------------------------
Select the installation type.
Typical: Install the database server with all features and a database server
that
is configured with default values. Includes:
** Client Software Development Kit (CSDK)
** Java Database Connectivity (JDBC)
Minimum disk space required: 700-800MB
Custom: Install the database server with specific features and software that
you need.
Optionally install a configured database server instance.
Minimum disk space required: 75 MB (without a server instance)
->1- Typical installation
2- Custom installation
3- Extract the product files (-DLEGACY option)
ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS <ENTER> TO ACCEPT THE DEFAULT:: 1
安装程序支持典型安装和自定义安装方式,我们选择典型安装,所以输入1。
===============================================================================
Server Instance Creation
------------------------
Create a server instance?
->1- Yes - create an instance
2- No - do not create an instance
ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS <ENTER> TO ACCEPT THE DEFAULT:: 2
在安装过程中,可以自动创建一个数据库的实例。由于典型安装中创建的实例在配置上非常简单,不适合后期深入的学习GBase 8s,因此我们选择不创建实例,我们在安装后,可以手动执行一个脚本,方便了创建一个新的数据库实例。此处我们输入2。
===============================================================================
Installation Summary
--------------------
Please review the following before continuing:
Product Name:
GBase Software Bundle
Install Folder:
/opt/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: 99,248,541,696 Bytes
PRESS <ENTER> TO CONTINUE:
安装程序给出一个报告,列出了本次将要安装的数据库组件。按回车将继续安装。
=============================================================================== Ready To Install ---------------- InstallAnywhere is now ready to install GBase Software Bundle onto your system at the following location: /opt/gbase PRESS <ENTER> TO INSTALL:
安装程序再次让用户确认安装程序的位置。我们按回车键,确认安装位置并继续安装。
===============================================================================
Installing...
-------------
[==================|==================|==================|==================]
[------------------|------------------|------------------|------------------]
===============================================================================
Installation Complete
---------------------
Congratulations! GBase Software Bundle installation is complete.
Product install status:
GBase: Successful
GBase Connect: Successful
Main Version: GBase 8s Express Edition
For more information about using GBase products, see the GBase Information
Center at http://www.gbase.cn.
PRESS <ENTER> TO EXIT THE INSTALLER:
[root@gbase soft]#
安装完成。按回车键退出安装程序。
创建数据库实例
执行创建实例的脚本
[root@gbase ~]# su - gbasedbt
[gbasedbt@gbase ~]$ cd /opt/gbase/etc
[gbasedbt@gbase 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]:
脚本默认的实例名称为gbaseserver,可以在冒号后面输入我们希望的名称,也可以直接回车,使用默认的实例名。
SEARCHING FOR GBASE INSTALL FOLDER, PLEASE WAIT FOR SECONDS... GBASE INSTALL FOLDER LIST: 1) /opt/gbase CHOOSE GBASE INSTALL FOLDER(GBASEDBTDIR) [Default:/opt/gbase]:
安装脚本询问GBase 8s的程序安装在哪个路径下,默认是我们之前安装时指定的路径。我们直接回车继续。
CHOOSE SERVICE IP ADDRESS FROM THE LIST: 1) 192.168.0.89 2) 127.0.0.1 ENTER THE NUMBER FOR YOUR CHOICE [Default:192.168.0.89]:
安装脚本询问我们服务器的IP地址,我们输入服务器的IP地址。如果默认的IP地址是我们希望的IP,直接回车继续。
SPECIFY THE PORT NUMBER FOR GBASE [Default:9088]:
安装脚本询问我们数据库监听使用的端口号,默认为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
安装脚本询问我们初始化的类型,我们选择CUSTOM,输入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
安装脚本询问我们数据库使用哪种字符集,我们使用UTF8,输入3,回车继续。
ENTER THE DATA SPACE PATH [Default:/opt/gbase/gbaseserver_dbs]:
安装脚本询问我们数据保存在哪个目录中,我们使用默认值,回车继续。
ENTER THE LOGICAL LOG DBSPACE SIZE(MB) [Default:9550]: 200
安装脚本询问我们,保存逻辑日志的数据库空间大小,我们输入200,回车继续。
ENTER THE PHYSICAL LOG DBSPACE SIZE(MB) [Default:9550]: 200
安装脚本询问我们,保存物理日志的数据库空间大小,我们输入200,回车继续。
ENTER THE SMART LOB DBSPACE SIZE(MB) [Default:1940]: 100
安装脚本询问我们,保存智能大对象的数据库空间大小,我们输入100,回车继续。
ENTER THE TEMPORARY DBSPACE SIZE(MB) [Default:1940]: 100
安装脚本询问我们,保存临时数据的数据库空间大小,我们输入100,回车继续。
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]: 5
安装脚本询问我们,创建几个保存数据的数据库空间,我们输入5,回车继续。
ENTER THE NUMBER OF TEMP DBSPACES [Default:1]: 3
安装脚本询问我们,创建几个保存临时数据的数据库空间,我们输入3,回车继续。
Enter "Y" TO ENABLE ENVIRONMENT GL_USEGLU, OR ENTER "N" TO DISABLE: [Default:N]:
安装脚本询问我们,是否启用GL_USEGLU,默认不启用,我们直接回车继续。
INSTANCE SUMMARY:
Instance name: gbaseserver
GBase install directory: /opt/gbase
IP address & port: 192.168.0.89:9088
Character set: zh_CN.utf8
Logical log space size: 200 MB
Physical log space size: 200 MB
Smart LOB space size: 100 MB
Temp DBSpace size: 100 MB
Data path: /opt/gbase/gbaseserver_dbs
Data path free size: 94593 MB
The number of data DBSpace: 5
The number of temp DBSpace: 3
Environment GL_USEGLU: 0
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.2.3...OK
Creating data Dbspace.1.2.3.4.5...OK
Setting dbscheduler...OK
Moving physical log...OK
Adding 20 logical logs: 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20...OK
Setting data chunks extendable...OK
Cleaning logical logs in rootdbs...Your evaluation license will expire on 2024-02-09 00:00:00
.Your evaluation license will expire on 2024-02-09 00:00:00
.Your evaluation license will expire on 2024-02-09 00:00:00
.Your evaluation license will expire on 2024-02-09 00:00:00
...OK
Database restarting.......Your evaluation license will expire on 2024-02-09 00:00:00
OK
Creating database: gbasedb...OK
Now you can use this URL to connect to gbasedb:
jdbc:gbasedbt-sqli://192.168.0.89:9088/gbasedb:GBASEDBTSERVER=gbaseserver;DB_LOCALE=zh_CN.utf8;CLIENT_LOCALE=zh_CN.utf8;NEWCODESET=UTF8,utf8,57372;
Version:
Your evaluation license will expire on 2024-02-09 00:00:00
On-Line -- Up 00:00:17 -- 2171620 Kbytes
Build Number: 3.3.0_N303
GBase Initializing Finished!
Initialize log file : ./InitGBaseDB_202302091351.log
Press <ENTER> to Exit and Logout...
Killed
[root@gbase ~]#
环境变量
[root@gbase ~]# su - gbasedbt
Last login: Thu Feb 9 13:55:32 CST 2023 on pts/0
[gbasedbt@gbase ~]$ cat profile.gbaseserver
export GBASEDBTSERVER=gbaseserver
export GBASEDBTDIR=/opt/gbase
export GBASEDBTSQLHOSTS=/opt/gbase/etc/sqlhosts.gbaseserver
export ONCONFIG=onconfig.gbaseserver
export PATH=/opt/gbase/bin:$PATH
export DB_LOCALE=zh_CN.utf8
export CLIENT_LOCALE=zh_CN.utf8
unset GL_USEGLU
查看GBase 8s的进程信息
GBase 8s启动后,会运行名称为oninit的进程,可以使用ps命令查看。
[gbasedbt@gbase ~]$ ps -ef | grep oninit gbasedbt 36937 1 0 13:54 ? 00:00:01 oninit -v root 36958 36937 0 13:54 ? 00:00:00 oninit -v root 36959 36958 0 13:54 ? 00:00:00 oninit -v root 36967 36958 0 13:54 ? 00:00:00 oninit -v root 36974 36958 0 13:54 ? 00:00:00 oninit -v root 36982 36958 0 13:54 ? 00:00:00 oninit -v root 36990 36958 0 13:54 ? 00:00:00 oninit -v gbasedbt 36998 36958 0 13:54 ? 00:00:00 oninit -v gbasedbt 36999 36958 0 13:54 ? 00:00:00 oninit -v gbasedbt 37000 36958 0 13:54 ? 00:00:00 oninit -v root 37008 36958 0 13:54 ? 00:00:00 oninit -v root 37009 36958 0 13:54 ? 00:00:00 oninit -v root 37010 36958 0 13:54 ? 00:00:00 oninit -v root 37011 36958 0 13:54 ? 00:00:00 oninit -v root 37012 36958 0 13:54 ? 00:00:00 oninit -v gbasedbt 41011 40479 0 14:04 pts/0 00:00:00 grep --color=auto oninit
查看数据库运行状态
可以使用onstat命令,查看数据库运行状态。
[gbasedbt@gbase ~]$ onstat - Your evaluation license will expire on 2024-02-09 00:00:00 On-Line -- Up 00:11:02 -- 2171620 Kbytes
停止数据库
[gbasedbt@gbase ~]$ onmode -ky
Your evaluation license will expire on 2024-02-09 00:00:00
[gbasedbt@gbase ~]$ onstat -
Your evaluation license will expire on 2024-02-09 00:00:00
shared memory not initialized for GBASEDBTSERVER 'gbaseserver'
启动数据库
[gbasedbt@gbase ~]$ oninit -vy
Your evaluation license will expire on 2024-02-09 00:00:00
Reading configuration file '/opt/gbase/etc/onconfig.gbaseserver'...succeeded
Creating /GBASEDBTTMP/.infxdirs...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 76314 kbytes...succeeded
Creating infos file "/opt/gbase/etc/.infos.gbaseserver"...succeeded
Linking conf file "/opt/gbase/etc/.conf.gbaseserver"...succeeded
Initializing rhead structure...rhlock_t 65536 (2048K)... rlock_t (66406K)... 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
Starting tracing...succeeded
Initializing 32 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@gbase ~]$ onstat -
Your evaluation license will expire on 2024-02-09 00:00:00
On-Line -- Up 00:00:15 -- 2171620 Kbytes
验证数据库
[gbasedbt@gbase ~]$ dbaccess - -
Your evaluation license will expire on 2024-02-09 00:00:00
> create database mydb with log;
Database created.
> database mydb;
Database closed.
Database selected.
> create table t_user(f_userid int, f_username varchar(50));
Table created.
> insert into t_user values(1,'gbasedbt');
1 row(s) inserted.
> select * from t_user;
f_userid f_username
1 gbasedbt
1 row(s) retrieved.
>
Database closed.
[gbasedbt@gbase ~]$
卸载GBase 8s数据库组件与数据
[root@gbase ~]# cd /opt/gbase/uninstall/uninstall_ids/
[root@gbase uninstall_ids]# ls -lrt
total 11668
-rwxr-xr-x. 1 root root 74206 Feb 9 13:39 uninstallids
-rwxr-xr-x. 1 root root 3402 Feb 9 13:39 uninstallids.lax
-rw-rw-r--. 1 root root 5125880 Feb 9 13:39 InstallScript.iap_xml
-rw-rw-r--. 1 root root 6727010 Feb 9 13:39 uninstaller.jar
-rw-rw-r--. 1 root root 66 Feb 9 13:39 removablesList.txt
-rwxr-xr-x. 1 root root 1032 Feb 9 13:39 installvariables.properties
[root@gbase uninstall_ids]# ./uninstallids
===============================================================================
GBase Software Bundle (created with InstallAnywhere)
-------------------------------------------------------------------------------
Preparing CONSOLE Mode Uninstallation...
===============================================================================
Uninstall GBase Software Bundle
-------------------------------
About to uninstall GBase Software Bundle.
In this uninstall process, all GBase Software Bundle products in /opt/gbase
will be uninstalled.
It is recommended that you first shutdown all database server instances related
to this installation prior to uninstalling the product.
PRESS <ENTER> TO CONTINUE:
回车确认
===============================================================================
Server Uninstall Options
------------------------
Server action:
Important: Choosing to remove all databases will remove all database chunks,
environment files, registry entries, and message log files for all database
server instances associated with this installation.
->1- Retains all databases, but removes all server binaries
2- Removes server binaries and all databases associated with them
ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS <ENTER> TO ACCEPT THE DEFAULT:: 2
我们需要删除GBase 8s数据库组件和全部的数据库,输入2并回车。
===============================================================================
Uninstalling...
---------------
...*
*
*************************
*************************
*************************
************************
...*
*
*************************
*************************
*************************
************************
...*
*
*************************
*************************
*************************
************************
...*
*
*************************
*************************
*************************
************************
...*
*
*************************
*************************
*************************
************************
...*
*
*************************
*************************
*************************
*************************
===============================================================================
Uninstall Complete
------------------
Uninstall is complete for GBase Software Bundle.
Product uninstall status:
GBase: Successful
由于卸载程序在GBase 8s的安装目录中,因此卸载程序并没有完成清空安装目录,需要我们手动清除。
[root@gbase uninstall_ids]# cd /opt
[root@gbase opt]# rm -rf gbase
执行userdel,删除用户。
[root@gbase opt]# userdel -r gbasedbt




