一：虚谷数据库安装
1.1 准备安装介质
没有看错，就是 4.3M 大小
[root@cjc-db-01 xg]# ls -lrth
total 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 XuguServer
4.3M XuGuServer-12_20220520-trial-linux-x64.tar.gz
508K 虚谷数据库系统软件安装手册.pdf
1.2 查看配置文件
如果需要修改文件路径，需要调整配置文件。
[root@cjc-db-01 SETUP]# pwd
/soft/xg/XuguServer/SETUP
[root@cjc-db-01 SETUP]# ls
mount.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 -l
total 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.sh
XuGu SQL Server 12.0.0 (Built:2022-05-20 12:00:00 GA)
Start at: 2022-10-20 14:16:14
Daemon process is still running.
启动后自动生成文件
[root@cjc-db-01 XuguServer]# pwd
/soft/xg/XuguServer
[root@cjc-db-01 XuguServer]# ls
BIN SETUP XGLOG XHOME XVOCA
查看文件大小
[root@cjc-db-01 XuguServer]# du -sh *
11M BIN
24K SETUP
12K XGLOG
2.1G XHOME
0 XVOCA
[root@cjc-db-01 XuguServer]# cd XHOME/
[root@cjc-db-01 XHOME]# ls
ARCH BACKUP CATA DATA REDO TEMP UNDO XMODI
[root@cjc-db-01 XHOME]# du -sh *
0 ARCH
0 BACKUP
25M CATA
1.0G DATA
13M REDO
512M TEMP
512M UNDO
0 XMODI
2.3 启动日志
root@cjc-db-01 BIN]# cat stdout.txt
CPU info:
Node 0: 0 1
Resource limit:
File number: hard limit=4096,soft limit=1024
File size(M): hard limit=-1,soft limit=-1
Data memory(M): hard limit=-1,soft limit=-1
Resident(M): hard limit=-1,soft limit=-1
Proc's total memory(M): hard limit=-1,soft limit=-1
Open file cluster.ini failed.
init data buffer...ok.
Trial period 360 days
Mount all gstore...ok.
Open all system tables...ok
Create system database...ok.
Open all system views...ok
Load all jobs...ok
All service started.
Listening at port 5138
首次启动日志，包括数据初始化部分：
通过 EVENT.LOG 日志可以看到停库信息
[root@cjc-db-01 XGLOG]# ls EVENT.LOG
EVENT.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 grep
root 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 xugu
tcp 0 0 0.0.0.0:5138 0.0.0.0:* LISTEN 2860/xugu12_linux_x
2.6 关闭
显示用了 1ms ，看日志实际用了 4 秒。
SQL> shutdown immediate
Execute successful.
Use time:1 ms.
2.7 关闭日志
通过 EVENT.LOG 日志可以看到停库信息
[root@cjc-db-01 XGLOG]# ls EVENT.LOG
EVENT.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 SYSDBA
XGDBMS linux Console Release V1.2.1
Copyright (c) 2002, 2021, XuGu. All rights reserved.
Connect to 127.0.0.1:5138 SYSTEM SYSDBA
Connect 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_sessions
Column_Name NULL Data_Type
------------------------------------------------------------------------------
NODEID | | INTEGER
SESSION_ID | | INTEGER
USER_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 cjc
db_name cjc
Execute 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》
扫一扫
2680
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
