1.1.1 修改兼容性参数compatible_level
人大金仓数据库兼容oracle参数调整
参数查看:
show all
select * from sys_catalog.sys_settings where name like'compatible%';
参数修改:
方式一:
kingbase -c compatible_level=oracle -D/opt/Kingbase/ES/V7/data
alter database set compatible_level =oracle;
方式二:
SET 参数名称 = 参数值
执行SQL
方式三:
修改参数配置文件kingbase.conf
[kingbase@wgzx data]$ tail -10 /opt/Kingbase/ES/V7/data/kingbase.conf
#cs_loader_threadcount = 5
#cs_loader_thread_bufsize = 320
#---------------------------------------------------------------------------
# KLogMiner
#---------------------------------------------------------------------------
#enable logminer
#enable_llogminer=off
compatible_level = 'oracle'
重启数据库查看
[kingbase@wgzx data]$ sys_ctl --help
sys_ctl 是一个启动,停止,重启,重载配置文件的工具,
汇报Kingbase 服务器的状态, 或者用信号通知Kingbase 的进程.
使用:
sys_ctl start [-w] [-D DATADIR][-s] [-l FILENAME] [-o "OPTIONS"]
sys_ctl stop [-W] [-D DATADIR][-s] [-m SHUTDOWN-MODE]
sys_ctl restart [-w] [-D DATADIR] [-s] [-m SHUTDOWN-MODE] [-o"OPTIONS"]
sys_ctl reload [-D DATADIR] [-s]
sys_ctl status [-D DATADIR]
sys_ctl kill SIGNALNAME PID