gaussdb 100 启动

安装好高斯100（下面简称高斯，都是单机环境），会有app/bin的目录，我们要启动高斯首先要进入这个目录

[omm@mgr ~]$ cd /opt/gaosi/app/bin/
[omm@mgr bin]$ python zctl.py -t start
Successfully started instance.

这样就可以登陆数据库了

[omm@mgr bin]$ zsql sys/XXX_123@192.168.80.50:1888   
Warning: SSL connection to server without CA certificate is insecure. Continue anyway? (y/n):y
connected.

启动日志记录如下：

UTC+0 2019-11-28 15:08:12.571|ZENGINE|00000|4575|INFO>[LOG] file '/opt/gaosi/data/log/zenith_alarm.log' is added [srv_param.c:488]
UTC+0 2019-11-28 15:08:12.613|ZENGINE|00000|4575|INFO>[LOG] file '/opt/gaosi/data/log/run/zengine.rlog' is added [cm_log.c:643]
UTC+0 2019-11-28 15:08:12.702|ZENGINE|00000|4575|INFO>[PARAM] LSNR_ADDR            = 127.0.0.1,192.168.80.50
UTC+0 2019-11-28 15:08:12.702|ZENGINE|00000|4575|INFO>[PARAM] LSNR_PORT            = 1888
UTC+0 2019-11-28 15:08:12.702|ZENGINE|00000|4575|INFO>[PARAM] DATA_BUFFER_SIZE     = 600M
UTC+0 2019-11-28 15:08:12.702|ZENGINE|00000|4575|INFO>[PARAM] SHARED_POOL_SIZE     = 300M
UTC+0 2019-11-28 15:08:12.702|ZENGINE|00000|4575|INFO>[PARAM] LOG_BUFFER_SIZE      = 64M
UTC+0 2019-11-28 15:08:12.702|ZENGINE|00000|4575|INFO>[PARAM] LOG_BUFFER_COUNT     = 8
UTC+0 2019-11-28 15:08:12.702|ZENGINE|00000|4575|INFO>[PARAM] TEMP_BUFFER_SIZE     = 300M
UTC+0 2019-11-28 15:08:12.702|ZENGINE|00000|4575|INFO>[PARAM] SESSIONS             = 1500
UTC+0 2019-11-28 15:08:12.702|ZENGINE|00000|4575|INFO>[PARAM] CONTROL_FILES        = (/opt/gaosi/data/data/cntl1, /opt/gaosi/data/data/cntl2, /opt/gaosi/data/data/cntl3)
UTC+0 2019-11-28 15:08:12.702|ZENGINE|00000|4575|INFO>[PARAM] DBWR_PROCESSES       = 8
UTC+0 2019-11-28 15:08:12.702|ZENGINE|00000|4575|INFO>[PARAM] INSTANCE_NAME        = zenith
UTC+0 2019-11-28 15:08:12.702|ZENGINE|00000|4575|INFO>[PARAM] AUDIT_LEVEL          = 7
UTC+0 2019-11-28 15:08:12.702|ZENGINE|00000|4575|INFO>[PARAM] ENABLE_SYSDBA_LOGIN  = TRUE
UTC+0 2019-11-28 15:08:12.731|ZENGINE|00000|206158434783|INFO>starting instance(normal)
UTC+0 2019-11-28 15:08:13.025|ZENGINE|00000|4578|INFO>lgwr thread started
UTC+0 2019-11-28 15:08:13.025|ZENGINE|00000|4579|INFO>dbwr thread started
UTC+0 2019-11-28 15:08:13.025|ZENGINE|00000|4580|INFO>dbwr thread started
UTC+0 2019-11-28 15:08:13.025|ZENGINE|00000|4581|INFO>dbwr thread started
UTC+0 2019-11-28 15:08:13.025|ZENGINE|00000|4582|INFO>dbwr thread started
UTC+0 2019-11-28 15:08:13.025|ZENGINE|00000|4583|INFO>dbwr thread started
UTC+0 2019-11-28 15:08:13.025|ZENGINE|00000|4584|INFO>dbwr thread started
UTC+0 2019-11-28 15:08:13.025|ZENGINE|00000|4585|INFO>dbwr thread started
UTC+0 2019-11-28 15:08:13.025|ZENGINE|00000|4586|INFO>dbwr thread started
UTC+0 2019-11-28 15:08:13.025|ZENGINE|00000|4587|INFO>ckpt thread started
UTC+0 2019-11-28 15:08:13.025|ZENGINE|00000|4590|INFO>index page recycle thread started
UTC+0 2019-11-28 15:08:13.029|ZENGINE|00000|4591|INFO>rollback thread started
UTC+0 2019-11-28 15:08:13.029|ZENGINE|00000|4592|INFO>rollback thread started
UTC+0 2019-11-28 15:08:13.029|ZENGINE|00000|4593|INFO>rmon thread started
UTC+0 2019-11-28 15:08:13.029|ZENGINE|00000|4588|INFO>smon thread started
UTC+0 2019-11-28 15:08:13.029|ZENGINE|00000|4589|INFO>stats thread started
UTC+0 2019-11-28 15:08:13.051|ZENGINE|00000|4594|INFO>job master thread started
UTC+0 2019-11-28 15:08:13.246|ZENGINE|00000|4575|INFO>local ip: 127.0.0.1
UTC+0 2019-11-28 15:08:13.246|ZENGINE|00000|4575|INFO>local ip: 192.168.80.50
UTC+0 2019-11-28 15:08:13.252|ZENGINE|00000|4595|INFO>reactor thread started
UTC+0 2019-11-28 15:08:13.252|ZENGINE|00000|4596|INFO>tcp-lsnr thread started
UTC+0 2019-11-28 15:08:13.252|ZENGINE|00000|4597|INFO>uds-lsnr thread started
UTC+0 2019-11-28 15:08:13.316|ZENGINE|00000|4575|INFO>SSL disabled: server certificate or private key file is not available.
UTC+0 2019-11-28 15:08:13.316|ZENGINE|00000|4575|INFO>start to alter database MOUNT
UTC+0 2019-11-28 15:08:13.922|ZENGINE|00000|4575|INFO>[ARCH] Init arch is_archive 0
UTC+0 2019-11-28 15:08:13.922|ZENGINE|00000|4575|INFO>[ARCH] Initialization complete
UTC+0 2019-11-28 15:08:13.922|ZENGINE|00000|4575|INFO>sucessfully alter database MOUNT
UTC+0 2019-11-28 15:08:13.949|ZENGINE|00000|206158434783|INFO>start to alter database OPEN
UTC+0 2019-11-28 15:08:14.547|ZENGINE|00000|140733193392607|INFO>[ARCH] Start ARCH thread for ARCHIVE_DEST_1[/opt/gaosi/data/archive_log]
UTC+0 2019-11-28 15:08:14.547|ZENGINE|00000|7986910807000617439|INFO>The last shutdown is a inconsistent shutdown
UTC+0 2019-11-28 15:08:14.547|ZENGINE|00000|4575|INFO>database start recovery
UTC+0 2019-11-28 15:08:14.547|ZENGINE|00000|4575|INFO>recovery from file:5,point:11036,lfn:13167
UTC+0 2019-11-28 15:08:14.547|ZENGINE|00000|4575|INFO>recovery expected least end with file:5,point:11162,lfn:13207
UTC+0 2019-11-28 15:08:16.387|ZENGINE|00000|140733193392607|INFO>[RCY] recovery real end with file:5,point:11353,lfn:13304
UTC+0 2019-11-28 15:08:16.387|ZENGINE|00000|140733193392607|INFO>[RCY] current lfn 13304, rcy point lfn 13167, consistent point 13207, lrp point lfn 13207
UTC+0 2019-11-28 15:08:18.358|ZENGINE|00000|139942919410143|INFO>no valid standby configuration
UTC+0 2019-11-28 15:08:18.358|ZENGINE|00000|4575|INFO>[DB] sse42 available 0
UTC+0 2019-11-28 15:08:18.358|ZENGINE|00000|4575|INFO>sucessfully alter database OPEN

可以看到启动跟oracle 基本类似。高斯启动也分nomount,mount,open,也有参数文件，控制文件，状态也是NO–参数，mount找控制，找归档什么等待。
总结一些区别：

1. Oracle 最小是db_name,高斯需要加端口（日志看不出，需要自己测试）
2. 高斯不是多进程就是没有smon进程可能是线程
3. Oracle 可以在nomount下mount，gaosi可以执行命令，好像不起效果。
   如下：

[omm@mgr bin]$ python zctl.py -t stop                   
Successfully stopped instance.
[omm@mgr bin]$ python zctl.py -t  -m nomount
Parameter input error: nomount
[omm@mgr bin]$ python zctl.py -t  start -m nomount
Successfully started instance.
[omm@mgr bin]$  python zctl.py -t  start -m mount
Zengine instance has already started.
[omm@mgr bin]$  python zctl.py -t  start -m open 
Zengine instance has already started.
[omm@mgr bin]$ zsql sys/XX_123@192.168.80.50:1888

Warning: SSL connection to server without CA certificate is insecure. Continue anyway? (y/n):y
GS-00329, Incorrect user or password