GBase 8s是南大通用自主研发、支持共享存储集群、两地三中心部署的、成熟稳定的百T金融级事务型国产数据库。GBase 8s适用于OLTP应用场景，包括金融、电信、政企、安全等行业的关键核心业务系统，在当前安全形势日益严峻的大背景下，GBase 8s已成为去IOE的主流国产数据库产品，能够在90%以上的场景中替代Oracle。
客户端独立安装的意义
当安装好GBase 8s后，系统自动安装了dbaccess命令行客户端工具，执行使用即可连接到8s数据库。在实际的生产环境中，操作人员不直接连接到服务器上，而是通过连接堡垒机上面的客户端工具，然后通过该客户端工具再连接到GBase 8s服务器上，这样比较安全。需要在相应的堡垒机上安装客户端工具即可，而不需要安装8s服务器了。
GBase 8s提供了csdk的安装包用于安装连接器和客户端用到的sdk，包括JAVA、ODBC等。
客户端独立安装包的获取
在gbase官网(www.gbase.cn)可以下载GBase 8s试用版
具体方法：官网–>技术支持–>产品文档–>GBase 8s V8.8–> GBase 8s 试用版下载
GBase 8s试用版下载地址：
http://www.gbase.cn/tech_info/474.html
可以下载各种平台系统的GBase 8s安装包。
根据服务器和操作系统选择对应的GBase 8s版本，对于非国产化硬件要求的服务器，选择 x86+RHEL6.zip 安装包下载。
将 x86+RHEL6.zip 下载并解压缩后，生成3个文件，其中 clientsdk_3.3.0_2_36477d_RHEL6_x86_64.tar 为客户端安装包。
客户端独立安装包环境准备
本文使用的CentOS 7.6操作系统虚拟机环境
已经安装GBase 8s服务器IP：172.16.9.161
准备在 172.16.9.163 服务器上安装能访问172.16.9.161 的GBase 8s的客户端
以下所有操作都在 172.16.9.163 服务器上进行
1、建gbasedbt用户（如果已设置，则跳过）
[root@163 ~]# groupadd gbasedbt [root@163 ~]# useradd -g gbasedbt -d /home/gbasedbt -s /bin/bash -m gbasedbt复制
2、创建/opt/gbase8s/用于安装csdk （使用root账户进行操作）
[root@163 ~]# mkdir -p /opt/gbase8s/复制
3、将clientsdk_3.3.0_2_36477d_RHEL6_x86_64.tar文件上传到 /opt/gbase8s/ 目录下面，然后解压缩。
[root@163 ~]# cd /opt/gbase8s/ [root@163 gbase8s]# ll 总用量 180668 -rw-r--r-- 1 root root 182497280 3月 30 18:59 clientsdk_3.3.0_2_36477d_RHEL6_x86_64.tar [root@163 gbase8s]# tar xvf clientsdk_3.3.0_2_36477d_RHEL6_x86_64.tar installclientsdk doc/ doc/Odbc_machine_notes_4.10.txt doc/Libcpp_machine_notes_4.10.txt doc/Glsapi_machine_notes_4.10.txt doc/ESQLC_machine_notes_4.10.txt csdk.properties .gbase.properties复制
环境准备好了，可以进行安装操作了。
安装客户端
执行安装脚本为 installclientsdk，以控制台方式进行安装，根据屏幕提示语,直接多次回车，然后输入 Y，输入安装目录，选择安装的组件处，直接回车不具体选择某一项（全部安装），直至安装完成。
[root@163 gbase8s]# ./installclientsdk 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 ClientSDK (created with InstallAnywhere) ------------------------------------------------------------------------------- Preparing CONSOLE Mode Installation... =============================================================================== Introduction ------------ The installer will guide you through the installation of GBase Client-SDK 4.10.FC4G1. Copyright General Data Corporation 2014, 2022, All rights reserved. It is strongly recommended that you quit all programs before continuing with this 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 Client-SDK 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 =============================================================================== Installation Location --------------------- Where Would You Like to Install GBase Client-SDK 4.10.FC4G1? Default Install Folder: /opt/GBASE/gbase ENTER AN ABSOLUTE PATH, OR PRESS <ENTER> TO ACCEPT THE DEFAULT : /opt/gbase8s INSTALL FOLDER IS: /opt/gbase8s IS THIS CORRECT? (Y/N): Y =============================================================================== Installation Features ---------------------复制
下面出现安装选项，注意不要输入数字，直接回车，表示全部安装
=============================================================================== Choose Product Features ----------------------- ENTER A COMMA_SEPARATED LIST OF NUMBERS REPRESENTING THE FEATURES YOU WOULD LIKE TO SELECT, OR DESELECT. TO VIEW A FEATURE'S DESCRIPTION, ENTER '?<NUMBER>'. PRESS <RETURN> WHEN YOU ARE DONE: 1- [X] GBase Client SDK 2- |-[X] GBase Object Interface for C++ 3- |-[X] GBase Object Interface for C++ Demos 4- |-[X] GBase ESQL/C 5- |-[X] GBase ESQL/C Demos 6- |-[X] 7.2 Application Compatibility Module 7- |-[X] GBase LIBDMI for Client Applications 8- |-[X] GBase ODBC Driver 9- |-[X] GBase ODBC Driver Demos 10- |-[X] GBase Common Database Utilities 11- [X] Global Language Support (GLS) 12- |-[X] West European and Americas 13- |-[X] Chinese Please choose the Features to be installed by this installer.: --不要输入数字，直接回车表示全部安装 =============================================================================== Installation Summary -------------------- Type 'back' to go to the previous step or 'quit' to cancel the installation. Please review the following before continuing: Product Name: GBase Client-SDK Install Folder: /opt/gbase8s Product Features: GBase Client SDK, GBase Object Interface for C++, GBase Object Interface for C++ Demos, GBase ESQL/C, GBase ESQL/C Demos, 7.2 Application Compatibility Module, GBase LIBDMI for Client Applications, GBase ODBC Driver, GBase ODBC Driver Demos, GBase Common Database Utilities, Global Language Support (GLS), West European and Americas, Chinese Disk Space Information (for Installation Target): Required: 265,155,051 Bytes Available: 48,737,861,632 Bytes PRESS <ENTER> TO CONTINUE: =============================================================================== Installing... ------------- [==================|==================|==================|==================] [------------------|------------------|------------------|------------------] =============================================================================== Installation Complete --------------------- Congratulations. GBase Client-SDK 4.10.FC4G1 has been successfully installed to: /opt/gbase8s GBase 8s V8.8 PRESS <ENTER> TO EXIT THE INSTALLER: [root@163 gbase8s]#复制
显示 successfully installed 表示安装成功了！
将 /opt/gbase8s 所有文件属主改为gbasedbt
[root@163 gbase8s]# cd .. [root@163 opt]# chown -Rf gbasedbt:gbasedbt gbase8s [root@163 opt]# ll gbase8s/ 总用量 358936 drwxrwxr-x 3 gbasedbt gbasedbt 317 8月 5 22:55 bin -rw-r--r-- 1 gbasedbt gbasedbt 182497280 3月 30 18:59 clientsdk_3.3.0_2_36477d_RHEL6_x86_64.tar -rw-r--r-- 1 gbasedbt gbasedbt 2792 3月 23 2021 csdk.properties drwxr-xr-x 3 gbasedbt gbasedbt 166 8月 5 22:55 doc drwxrwxr-x 2 gbasedbt gbasedbt 4096 8月 5 22:55 etc drwxrwxr-x 3 gbasedbt gbasedbt 22 8月 5 22:55 extend -rwxr-xr-x 1 gbasedbt gbasedbt 33219 8月 5 23:15 GBase_Client-SDK_Install_08_05_2022_22_55_05.log -rw-r--r-- 1 gbasedbt gbasedbt 2506640 3月 30 19:00 gbasedbtjdbc_3.3.0_2_36477d.jar -rwxr-xr-x 1 gbasedbt gbasedbt 26303 8月 5 22:55 GBase_GLS_Install_08_05_2022_22_55_24.log drwxr-xr-x 7 gbasedbt gbasedbt 62 8月 5 22:55 gls drwxrwxr-x 3 gbasedbt gbasedbt 17 8月 5 22:55 incl -rwxr-xr-x 1 gbasedbt gbasedbt 182470658 3月 23 2021 installclientsdk drwxrwxr-x 4 gbasedbt gbasedbt 195 8月 5 22:55 lib drwxrwxr-x 4 gbasedbt gbasedbt 32 8月 5 22:55 msg drwxrwxr-x 3 gbasedbt gbasedbt 19 8月 5 22:55 release drwxrwxr-x 2 gbasedbt gbasedbt 6 8月 5 22:55 tmp drwxrwxr-x 3 gbasedbt gbasedbt 33 8月 5 22:55 uninstall复制
1、切换账号gbasedbt，配置环境变量
[root@163 gbase8s]# su - gbasedbt # 设置环境变量 [gbasedbt@163 etc]$ cd ~ [gbasedbt@163 ~]$ vim .bash_profile # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs # 增加下面这些内容 PATH=$PATH:$HOME/.local/bin:$HOME/bin export PATH export GBASEDBTDIR=/opt/gbase8s export GBASEDBTSERVER=gbase01 export ONCONFIG=onconfig.$GBASEDBTSERVER export PATH=$GBASEDBTDIR/bin:${PATH} export GBASEDBTSQLHOSTS=/opt/gbase8s/etc/sqlhosts export DB_LOCALE=zh_CN.utf8 export CLIENT_LOCALE=zh_CN.utf8 export GL_USEGLU=1 export DBDATE="Y4MD-" export DBACCESS_SHOW_TIME=1 export LD_LIBRARY_PATH=${GBASEDBTDIR}/lib:${GBASEDBTDIR}/lib/esql:${GBASEDBTDIR}/lib/cli export ODBCINI=/opt/gbase8s/etc/odbc.ini复制
环境变量文件保存之后要生效
[gbasedbt@163 ~]$ source .bash_profile复制
2、然后设置sqlhost 文件
[gbasedbt@163 ~]$ cd /opt/gbase8s/ [gbasedbt@163 gbase8s]$ cd etc [gbasedbt@163 etc]$ vim sqlhosts # 输入下面这行设置，然后保存退出，注意一定写上8s服务器的IP地址172.16.9.161 gbase01 onsoctcp 172.16.9.161 9088复制
3、需要在 8s 服务器端172.16.9.161的sqlhost 文件里设置，增加一条信息
[gbasedbt@161 ~]$ cd /opt/gbase8s/ [gbasedbt@161 gbase8s]$ cd etc [gbasedbt@161 etc]$ vi sqlhosts gbase01 onsoctcp 172.16.9.161 9088 gbase01 onsoctcp 172.16.9.164 9088复制
4、使用dbaccess客户端连接8s
执行dbaccess菜单模式，点连接Connect，输入实例、用户名密码就能连成功了。
[gbasedbt@163 etc]$ dbaccess复制
然后选择“C/连接”，然后回车
再次回车，就会显示出 gbase01实例名
需要输入 gbase01 实例名
回车之后，输入数据库账户 gbasedbt
回车后输入密码 GBase123
然后回车就显示出所有数据库名称了，表示dbaccess连接成功。
卸载GBase 8s的客户端工具
如果不再使用客户端工具了，需要使用root账户进行卸载，卸载命令为 uninstallclientsdk
[root@163 ~]# cd /opt/gbase8s/ [root@163 uninstall]# cd uninstall_clientsdk/ [root@163 uninstall_clientsdk]# ll 总用量 7604 -rwxrwxr-x 1 root root 25113 3月 23 2021 ids_unlink.xsl -rw-rw-r-- 1 root root 1008907 8月 6 00:52 InstallScript.iap_xml -rwxr-xr-x 1 root root 8540 8月 6 00:54 installvariables.properties -rw-rw-r-- 1 root root 29 8月 6 00:54 removablesList.txt -rwxr-xr-x 1 root root 74206 8月 6 00:52 uninstallclientsdk -rwxrwxr-x 1 root root 3416 8月 6 00:52 uninstallclientsdk.lax -rw-rw-r-- 1 root root 6644522 8月 6 00:52 uninstaller.jar [root@163 uninstall_clientsdk]# ./uninstallclientsdk Graphical installers are not supported by the VM. The console mode will be used instead... =============================================================================== GBase Client-SDK (created with InstallAnywhere) ------------------------------------------------------------------------------- Preparing CONSOLE Mode Uninstallation... =============================================================================== Uninstall GBase Client-SDK 4.10.FC4G1 ------------------------------------- About to uninstall... GBase Client-SDK 4.10.FC4G1 This will remove features installed by InstallAnywhere. It will not remove files and folders created after the installation. PRESS <ENTER> TO CONTINUE: =============================================================================== Uninstall Options ----------------- ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS <ENTER> TO ACCEPT THE DEFAULT: ->1- Completely remove all features and components. 2- Choose specific features that were installed by InstallAnywhere. Please choose one of the following options:: 1 =============================================================================== Uninstalling... --------------- ... =============================================================================== Uninstall Complete ------------------ Some items could not be removed. [root@163 ..]# pwd /opt/gbase8s/uninstall/uninstall_clientsdk/.. [root@163 ..]# cd /opt # 将安装目录内容全部删除 [root@163 opt]# rm -rf gbase8s复制
总结
本文详细介绍了如何独立安装8s客户端工具的全过程，希望对大家使用8s有所帮助。
最后修改时间：2022-09-13 13:59:13
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
评论
目录
