一：虚谷数据库安装
1.1准备安装介质
没有看错，就是4.3M大小
[root@cjc-db-01 xg]# ls -lrthtotal 4.3M-rw-r--r-- 1 root root 4.3M Oct 20 14:07 XuGuServer-12_20220520-trial-linux-x64.tar.gz
解压
[root@cjc-db-01 xg]# tar -zxvf XuGuServer-12_20220520-trial-linux-x64.tar.gz[root@cjc-db-01 xg]# du -sh *11M XuguServer4.3M XuGuServer-12_20220520-trial-linux-x64.tar.gz508K 虚谷数据库系统软件安装手册.pdf
1.2 查看配置文件
如果需要修改文件路径，需要调整配置文件。
[root@cjc-db-01 SETUP]# pwd/soft/xg/XuguServer/SETUP[root@cjc-db-01 SETUP]# lsmount.ini trust.ini types.ini xugu.ini
文件路径配置文件
[root@cjc-db-01 SETUP]# cat mount.ini/XGLOG ./XGLOG/CATA ./XHOME/CATA/DATA ./XHOME/DATA/TEMP ./XHOME/TEMP/REDO ./XHOME/REDO/BACKUP ./XHOME/BACKUP/ARCH ./XHOME/ARCH/UNDO ./XHOME/UNDO/MODI ./XHOME/XMODI
二：启动和关闭
2.1 授权
[root@cjc-db-01 BIN]# pwd/soft/xg/XuguServer/BIN[root@cjc-db-01 BIN]# chmod +x *[root@cjc-db-01 BIN]# ls -ltotal 10484-rwxr-xr-x 1 root root 758858 May 18 10:33 xgconsole-linux-x64-rwxr-xr-x 1 root root 9836610 May 18 10:33 xugu12_linux_x64_trial-rwxr-xr-x 1 root root 127551 May 18 10:33 xugu_init.sql-rwxr-xr-x 1 root root 37 May 18 10:33 xugu_start.sh
2.2 启动
[root@cjc-db-01 BIN]# sh xugu_start.shXuGu SQL Server 12.0.0 (Built:2022-05-20 12:00:00 GA)Start at: 2022-10-20 14:16:14Daemon process is still running.
启动后自动生成文件，不需要安装
[root@cjc-db-01 XuguServer]# pwd/soft/xg/XuguServer[root@cjc-db-01 XuguServer]# lsBIN SETUP XGLOG XHOME XVOCA
查看文件大小
[root@cjc-db-01 XuguServer]# du -sh *11M BIN24K SETUP12K XGLOG2.1G XHOME0 XVOCA[root@cjc-db-01 XuguServer]# cd XHOME/[root@cjc-db-01 XHOME]# lsARCH BACKUP CATA DATA REDO TEMP UNDO XMODI[root@cjc-db-01 XHOME]# du -sh *0 ARCH0 BACKUP25M CATA1.0G DATA13M REDO512M TEMP512M UNDO0 XMODI
2.3启动日志
自动安装日志
root@cjc-db-01 BIN]# cat stdout.txtCPU info:Node 0: 0 1Resource limit:File number: hard limit=4096,soft limit=1024File size(M): hard limit=-1,soft limit=-1Data memory(M): hard limit=-1,soft limit=-1Resident(M): hard limit=-1,soft limit=-1Proc's total memory(M): hard limit=-1,soft limit=-1Open file cluster.ini failed.init data buffer...ok.Trial period 360 daysMount all gstore...ok.Open all system tables...okCreate system database...ok.Open all system views...okLoad all jobs...okAll service started.Listening at port 5138
首次启动日志，包括数据初始化部分：
通过EVENT.LOG日志可以看到停库信息
[root@cjc-db-01 XGLOG]# ls EVENT.LOGEVENT.LOG
0 ^_ SYS_START ^_ 2022-10-20 14:16:14 ^_ SYSTEM ^_ ^_ Open file cluster.ini failed,start in singleton mode.^^1 ^_ SYS_START ^_ 2022-10-20 14:16:15 ^_ SYSTEM ^_ ^_ tablespace(1,GSYS1) inited.^^1 ^_ SYS_START ^_ 2022-10-20 14:16:15 ^_ SYSTEM ^_ ^_ tablespace(258,LSYS1) inited.^^1 ^_ SYS_START ^_ 2022-10-20 14:16:15 ^_ SYSTEM ^_ ^_ tablespace(257,UNDO_SYS) inited.^^1 ^_ SYS_START ^_ 2022-10-20 14:16:18 ^_ SYSTEM ^_ ^_ tablespace(259,DATA1) inited.^^1 ^_ SYS_START ^_ 2022-10-20 14:16:19 ^_ SYSTEM ^_ ^_ tablespace(260,DATA2) inited.^^1 ^_ SYS_START ^_ 2022-10-20 14:16:20 ^_ SYSTEM ^_ ^_ tablespace(261,DATA3) inited.^^1 ^_ SYS_START ^_ 2022-10-20 14:16:21 ^_ SYSTEM ^_ ^_ tablespace(262,DATA4) inited.^^1 ^_ SYS_START ^_ 2022-10-20 14:16:27 ^_ SYSTEM ^_ ^_ tablespace(263,TEMP1) inited.^^1 ^_ SYS_START ^_ 2022-10-20 14:16:33 ^_ SYSTEM ^_ ^_ tablespace(264,TEMP2) inited.^^1 ^_ SYS_START ^_ 2022-10-20 14:16:34 ^_ SYSTEM ^_ ^_ tablespace(265,UNDO1) inited.^^1 ^_ SYS_START ^_ 2022-10-20 14:16:35 ^_ SYSTEM ^_ ^_ tablespace(266,UNDO2) inited.^^1 ^_ SYS_START ^_ 2022-10-20 14:16:43 ^_ SYSTEM ^_ ^_ Mount all gstore...^^1 ^_ SYS_START ^_ 2022-10-20 14:16:43 ^_ SYSTEM ^_ ^_ Mount all gstore...done.^^1 ^_ CKPT ^_ 2022-10-20 14:16:43 ^_ SYSTEM ^_ ^_ Checkpoint(12723088),flush_clock(18446744073537644047),min_chkpt_no:1,max_chkpt_no:1^^1 ^_ SYS_START ^_ 2022-10-20 14:16:43 ^_ SYSTEM ^_ ^_ Open all system tables...^^1 ^_ SYS_START ^_ 2022-10-20 14:16:44 ^_ SYSTEM ^_ ^_ Open all system views...^^1 ^_ SYS_START ^_ 2022-10-20 14:16:44 ^_ SYSTEM ^_ ^_ Load all jobs...^^1 ^_ DB_OPEN ^_ 2022-10-20 14:16:44 ^_ SYSTEM ^_ ^_ opened(online).^^1 ^_ SYS_START ^_ 2022-10-20 14:16:44 ^_ SYSTEM ^_ ^_ All service started.^^1 ^_ SYS_START ^_ 2022-10-20 14:16:44 ^_ SYSTEM ^_ ^_ starting^^
第二次开始的启动日志：
0 SYS_START 2022-10-20 15:45:12 SYSTEM Open file cluster.ini failed,start in singleton mode.1 SYS_START 2022-10-20 15:45:12 SYSTEM Master Load all gstores...1 SYS_START 2022-10-20 15:45:12 SYSTEM Master Load all gstores...done.1 SYS_START 2022-10-20 15:45:13 SYSTEM Mount all gstore...1 SYS_START 2022-10-20 15:45:13 SYSTEM Mount all gstore...done.1 SYS_START 2022-10-20 15:45:13 SYSTEM Open all system tables...1 SYS_START 2022-10-20 15:45:13 SYSTEM Open all system views...1 SYS_START 2022-10-20 15:45:13 SYSTEM Load all jobs...1 DB_OPEN 2022-10-20 15:45:13 SYSTEM opened(online).1 SYS_START 2022-10-20 15:45:13 SYSTEM All service started.1 SYS_START 2022-10-20 15:45:13 SYSTEM starting
2.4检查数据库进程
[root@cjc-db-01 ~]# ps -ef|grep xugu*|grep -v greproot 2860 1 2 14:16 pts/0 00:00:25 soft/xg/XuguServer/BIN/xugu12_linux_x64_trial -service
2.5检查监听状态
[root@cjc-db-01 ~]# netstat -ntupl|grep xugutcp 0 0 0.0.0.0:5138 0.0.0.0:* LISTEN 2860/xugu12_linux_x
2.6 关闭
显示用了1ms，看日志实际用了4秒。
SQL> shutdown immediateExecute successful.Use time:1 ms.
2.7 关闭日志
通过EVENT.LOG日志可以看到停库信息
[root@cjc-db-01 XGLOG]# ls EVENT.LOGEVENT.LOG
日志内容如下：
1 ^_ SYS_EXIT ^_ 2022-10-20 15:38:06 ^_ SYSTEM ^_ ^_ Recv SHUTDOWN IMMEDIATE.^^1 ^_ CKPT ^_ 2022-10-20 15:38:06 ^_ SYSTEM ^_ ^_ Checkpoint(12971307),flush_clock(18446744073542527542),min_chkpt_no:488,max_chkpt_no:488^^1 ^_ SYS_EXIT ^_ 2022-10-20 15:38:06 ^_ SYSTEM ^_ ^_ Closing net ...^^1 ^_ SYS_EXIT ^_ 2022-10-20 15:38:09 ^_ SYSTEM ^_ ^_ Closing net ...done.^^1 ^_ SYS_EXIT ^_ 2022-10-20 15:38:09 ^_ SYSTEM ^_ ^_ Shutting down job manager...^^1 ^_ SYS_EXIT ^_ 2022-10-20 15:38:09 ^_ SYSTEM ^_ ^_ Shutting down job manager...done.^^1 ^_ SYS_EXIT ^_ 2022-10-20 15:38:09 ^_ SYSTEM ^_ ^_ Stopping sessions...^^1 ^_ SYS_EXIT ^_ 2022-10-20 15:38:09 ^_ SYSTEM ^_ ^_ Stopping sessions...done.^^1 ^_ SYS_EXIT ^_ 2022-10-20 15:38:09 ^_ SYSTEM ^_ ^_ Waiting tasks finish...^^1 ^_ SYS_EXIT ^_ 2022-10-20 15:38:10 ^_ SYSTEM ^_ ^_ Waiting tasks finish...done.^^1 ^_ CKPT ^_ 2022-10-20 15:38:10 ^_ SYSTEM ^_ ^_ Checkpoint(12971387),flush_clock(18446744073542527542),min_chkpt_no:488,max_chkpt_no:488^^1 ^_ SYS_EXIT ^_ 2022-10-20 15:38:10 ^_ SYSTEM ^_ ^_ Closing storages ...^^1 ^_ SYS_EXIT ^_ 2022-10-20 15:38:10 ^_ SYSTEM ^_ ^_ Closing storages ...done,System terminated.^^1 ^_ SYS_EXIT ^_ 2022-10-20 15:38:10 ^_ SYSTEM ^_ ^_ exit(3)^^
三：登录虚谷数据库
[root@cjc-db-01 BIN]# pwd/soft/xg/XuguServer/BIN
[root@cjc-db-01 BIN]# ./xgconsole-linux-x64 nssl 127.0.0.1 5138 SYSTEM SYSDBA SYSDBAXGDBMS linux Console Release V1.2.1Copyright (c) 2002, 2021, XuGu. All rights reserved.Connect to 127.0.0.1:5138 SYSTEM SYSDBAConnect ok.SQL>
四：检查
4.1检查数据库信息
SQL> SELECT DB_NAME,CHAR_SET,TIME_ZONE,CREATE_TIME,MODIFY_TIME,ONLINE FROM DBA_DATABASES;DB_NAME | CHAR_SET | TIME_ZONE | CREATE_TIME | MODIFY_TIME | ONLINE |------------------------------------------------------------------------------SYSTEM| UTF8.UTF8_GENERAL_CI| GMT+08:00| 2022-10-20 14:16:44.619 AD | 2022-10-20 14:16:44.619 AD | T |Total 1 records.Use time:3 ms.
4.2查看文件路径
SQL> SHOW DIR '/';DB_PATH | OS_PATH | IS_DIR |------------------------------------------------------------------------------/XGLOG| ./XGLOG| T |/CATA| ./XHOME/CATA| T |/DATA| ./XHOME/DATA| T |/TEMP| ./XHOME/TEMP| T |/REDO| ./XHOME/REDO| T |/BACKUP| ./XHOME/BACKUP| T |/ARCH| ./XHOME/ARCH| T |/UNDO| ./XHOME/UNDO| T |/MODI| ./XHOME/XMODI| T |Use time:0 ms.
4.3 会话信息
SQL> desc sys_all_sessionsColumn_Name NULL Data_Type------------------------------------------------------------------------------NODEID | | INTEGERSESSION_ID | | INTEGERUSER_ID | | INTEGER......SQL> SELECT NODEID,IP,COUNT(*) FROM SYS_ALL_SESSIONS GROUP BY NODEID,IP;NODEID | IP | EXPR1 |------------------------------------------------------------------------------1 | 127.0.0.1| 1 |Total 1 records.Use time:1 ms.
语法和Oracle相似
4.4 创建数据库
和MySQL语法相似
SQL> create database cjc;Execute successful.Use time:140 ms.
4.5 创建测试数据
SQL> use cjcdb_name cjcExecute successful.Use time:1 ms.SQL> create table t1(id int);Execute successful.Use time:40 ms.SQL> insert into t1 values(1),(2),(3);Total 3 records effected.Use time:8 ms.SQL> commit;Execute successful.Use time:0 ms.
五：管理工具
5.1 XuguManager
虚谷数据库管理工具
打开
登录
这界面感觉似曾相识呢?
连接数据库
查询
5.2 XuguConsole
虚谷数据库管理控制台
打开
登录，可以远程连接数据库
5.3 XuguDBeaver
虚谷数据库插件工具
登录
连接
执行SQL
文章转载自IT小Chen，如果涉嫌侵权，请发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
