1、在路径/home/dmdba/dmdbms/bin下执行:
./disql
2、连接达梦数据库(账号和密码:SYSDBA/123456):
conn SYSDBA/123456@58.213.151.125:5236
3、查看达梦数据库所有关键字:
select keyword,reserved from v$reserved_words;
4、取消关键字admin:
sp_set_para_string_value(2,'EXCLUDE_RESERVED_WORDS','admin');
5、再查关键字还有没有admin:
select keyword,reserved from v$reserved_words;
6、重启达梦数据库是配置生效:
[root@dm1 dm]# service DmServiceDMSERVER start
[root@dm1 dm]# service DmServiceDMSERVER stop
[root@dm1 dm]# service DmServiceDMSERVER restart
[root@dm1 dm]# service DmServiceDMSERVER status
7、关闭防火墙进行远程连接
查看防火墙状态 systemctl status firewalld.service
关闭防火墙 systemctl stop firewalld.service
永久关闭防火墙:systemctl disable firewalld.service