提前上传安装镜像及授权文件(key文件)到/data
提前重命名key 文件
cd /data
mv *.key dm.key
1、服务器类型,虚机还是物理机
virt-what
如果系统运行在物理机上,virt-what 命令通常不会返回任何结果
2、基础工具是否安装
tar、iotop、telnet、gdb、nmon、pstack、iostat、netstat、perf、ethtool
for cmd in tar iotop telnet gdb nmon pstack iostat netstat perf ethtool; do
which cmd >/dev/null && echo "cmd 已安装" || echo “$cmd 未安装”
done
3、磁盘测试
dd if=/dev/sda of=test bs=32k count=20k oflag=dsync
dd if=/dev/vdb of=test bs=32k count=20k oflag=dsync
dd if=/dev/vda of=test bs=32k count=20k oflag=dsync
dd if=/dev/vdc of=test bs=32k count=20k oflag=dsync
/dev/sdb 是数据盘符名称,根据实际环境修改
/dev/vdb 是数据盘符名称,根据实际环境修改
4、修改limits.conf
chmod +rx /etc/security/limits.conf
vi /etc/security/limits.conf
新增如下内容:
5、创建用户/目录
id dmdba
groupadd dinstall -g 311
useradd -g dinstall -m -d /home/dmdba -s /bin/bash -u 312 dmdba
echo “Dameng@123” |passwd --stdin dmdba
chown dmdba:dinstall -R /data
mkdir -p /data/dmdba/dmdata
mkdir -p /data/dmdba/dmarch
mkdir -p /data/dmdba/dmcore
mkdir -p /data/dmdba/dmdbms
chown -R dmdba:dinstall /data
chmod 755 /data
6、修改/etc/sysctl.conf
内存充足时 32G
echo vm.overcommit_memory = 0 >> /etc/sysctl.conf && sysctl -p
echo kernel.core_pattern = /data/dmdba/dmcore/core-%e-%p-%s >> /etc/sysctl.conf && sysctl -p
echo vm.numa_stat = 0 >> /etc/sysctl.conf && sysctl -p
echo vm.min_free_kbytes = 131072 >> /etc/sysctl.conf && sysctl -p
echo vm.swappiness = 10 >> /etc/sysctl.conf && sysctl -p
系统内存 vm.dirty_background_ratio vm.dirty_ratio vm.min_free_kbytes
16 GB 5 10 65536 (64MB)
32 GB 3 6 131072 (128MB)
64 GB 2 4 262144 (256MB)
128 GB 1 3 524288 (512MB)
256 GB 1 2 1048576 (1GB)
vm.overcommit_memory=0 表示内核将检查是否有足够的可用内存供应用进程使用;如果有足够的可用内存,内存申请允许;否则,内存申请失败,并把错误返回给应用进程。
vm.overcommit_memory=1 表示内核允许分配所有的物理内存,而不管当前的内存状态如何。
vm.overcommit_memory=2 表示内核允许分配超过所有物理内存和交换空间总和的内存。
7、永久关闭swap
sed -ri ‘s/.swap./#&/’ /etc/fstab
检查:重启生效
free -h # Swap 应显示 total=0
8、调整系统服务配置 system.conf 参数
cat /etc/systemd/system.conf
echo DefaultLimitNOFILE=65536 >> /etc/systemd/system.conf && cat /etc/systemd/system.conf
echo DefaultLimitNPROC=10240 >> /etc/systemd/system.conf && cat /etc/systemd/system.conf
9、关闭numa +关闭透明大页 重启生效
cat /etc/default/grub
确认GRUB_CMDLINE_LINUX 行是否有numa=off transparent_hugepage=never
没有这执行下述命令修改:
vi /etc/default/grub
在 GRUB_CMDLINE_LINUX 那一行后面追加 numa=off transparent_hugepage=never
[ -d /sys/firmware/efi ] && echo UEFI || echo BIOS
grub2-mkconfig -o /boot/efi/EFI/kylin/grub.cfg
grub2-mkconfig -o /boot/grub2/grub.cfg
cat /sys/kernel/mm/transparent_hugepage/enabled
10、磁盘调度算法
cat /sys/block/{DEVICE-NAME}/queue/scheduler
cat /sys/block/sda/queue/scheduler
cat /sys/block/sdb/queue/scheduler
cat /sys/block/vda/queue/scheduler
cat /sys/block/vdb/queue/scheduler
cat /sys/block/vdc/queue/scheduler
永久更改
vi /etc/default/grub
更改到如下内容
GRUB_CMDLINE_LINUX="… elevator=deadline"
# 查询结果是 UEFI 或 BIOS
[ -d /sys/firmware/efi ] && echo UEFI || echo BIOS
grub2-mkconfig -o /boot/efi/EFI/kylin/grub.cfg
grub2-mkconfig -o /boot/grub2/grub.cfg
cat /sys/kernel/mm/transparent_hugepage/enabled
11、麒麟 V10sp1 检查 RemoveIPC 参数 (详情见上线规范)
查看麒麟版本命令: nkvers,非SP1 无需修改
grep RemoveIPC /etc/systemd/logind.conf
将#注释去掉,并修改 yes 为 no
systemctl daemon-reload
systemctl restart systemd-logind
grep RemoveIPC /etc/systemd/logind.conf
loginctl show-session | grep RemoveIPC
systemctl show systemd-logind | grep -i removeipc
12 关闭防火墙
关闭:
systemctl status firewalld
systemctl stop firewalld
systemctl disable firewalld
启用:
systemctl enable firewalld
systemctl start firewalld
systemctl status firewalld
不能关闭防火墙的,去开放端口
firewall-cmd --list-all
systemctl start firewalld
firewall-cmd --permanent --zone=public --add-port=5236/tcp
firewall-cmd --reload
firewall-cmd --list-all
13 关闭 SELinux(CentOS6.5) (详情见上线规范)
cat /etc/selinux/config
如果SELINUX=disabled是被注释状态,则修改
vi /etc/selinux/config
SELINUX=disabled 行放开注释
14 挂载镜像
cd /data
ll
挂载:
mount -o loop *.iso /mnt
返回:mount: /mnt: WARNING: source write-protected, mounted read-only
su - dmdba
cd /mnt
./DMInstall.sh -i
选择语音:回车默认
是否输入key 文件路径:回车默认
输入key 文件路径:/data/dm.key
是否设置时区:回车默认
选择安装模式:回车默认
输入软件安装路径:/data/dmdba/dmdbms
是否确认安装到这个目录:回车默认
是否确认安装:输入y 回车
安装完成后,切回到root用户
执行:
/data/dmdba/dmdbms/script/root/root_installer.sh
执行完后,再切回dmdba 用户
su - dmdba
修改环境变量
vi /home/dmdba/.bash_profile
export PATH=PATH:DM_HOME/bin:$DM_HOME/tool
生效
source /home/dmdba/.bash_profile
初始化实例
cd /data/dmdba/dmdbms/bin
./dminit path=/data/dmdba/dmdata port_num=5236 extent_size=32 page_size=32 log_size=2048 case_sensitive=0 charset=1 SYSDBA_PWD=Dameng@123 SYSAUDITOR_PWD=Dameng@123
–注册服务 一般写端口为服务名称
切换到 root用户执行:
/data/dmdba/dmdbms/script/root/dm_service_installer.sh -t dmserver -p 5236 -dm_ini /data/dmdba/dmdata/DAMENG/dm.ini
chmod +rx /etc/dm_svc.conf
切回到dmdba 用户
su - dmdba
启动实例:
cd /data/dmdba/dmdbms/bin
./DmService5236 start
反馈OK 表示启动成功
-配置审计开启审计
./disql SYSAUDITOR/’“Dameng@123”’
SP_SET_ENABLE_AUDIT(2);
SP_AUDIT_STMT(‘TABLE’, ‘NULL’, ‘ALL’);
COMMIT;
exit;
优化数据库参数
机器16C32G:
./disql SYSDBA/’“Dameng@123”’
SP_SET_PARA_VALUE(2,‘WORKER_THREADS’,16);
SP_SET_PARA_VALUE(2,‘IO_THR_GROUPS’,16);
SP_SET_PARA_VALUE(2,‘GEN_SQL_MEM_RECLAIM’,0);
SP_SET_PARA_VALUE(2,‘MAX_OS_MEMORY’, 100);
SP_SET_PARA_VALUE(2,‘MEMORY_POOL’, 2000);
SP_SET_PARA_VALUE(2,‘MEMORY_N_POOLS’, 11);
SP_SET_PARA_VALUE(2,‘MEMORY_TARGET’, 2000);
SP_SET_PARA_VALUE(2,‘BUFFER’, 10000);
SP_SET_PARA_VALUE(2,‘BUFFER_POOLS’, 37);
SP_SET_PARA_VALUE(2,‘RECYCLE’, 1000);
SP_SET_PARA_VALUE(2,‘RECYCLE_POOLS’, 7);
SP_SET_PARA_VALUE(2,‘FAST_POOL_PAGES’, 9999);
SP_SET_PARA_VALUE(2,‘FAST_ROLL_PAGES’, 1000);
SP_SET_PARA_VALUE(2,‘ENABLE_FREQROOTS’,1);
SP_SET_PARA_VALUE(2,‘MULTI_PAGE_GET_NUM’,1);
SP_SET_PARA_VALUE(2,‘PRELOAD_SCAN_NUM’,0);
SP_SET_PARA_VALUE(2,‘PRELOAD_EXTENT_NUM’,0);
SP_SET_PARA_VALUE(2,‘TASK_THREADS’,8);
SP_SET_PARA_VALUE(2,‘MEMORY_MAGIC_CHECK’, 1);
SP_SET_PARA_VALUE(1,‘HJ_BUF_GLOBAL_SIZE’, 2000);
SP_SET_PARA_VALUE(1,‘HJ_BUF_SIZE’, 250);
SP_SET_PARA_VALUE(1,‘HAGR_BUF_GLOBAL_SIZE’,2000);
SP_SET_PARA_VALUE(1,‘HAGR_BUF_SIZE’, 250);
SP_SET_PARA_VALUE(2,‘SORT_FLAG’,0);
SP_SET_PARA_VALUE(2,‘SORT_BLK_SIZE’,1);
SP_SET_PARA_VALUE(2,‘SORT_BUF_SIZE’, 10);
SP_SET_PARA_VALUE(2,‘SORT_BUF_GLOBAL_SIZE’, 2000);
SP_SET_PARA_VALUE(2,‘RLOG_POOL_SIZE’, 1024);
SP_SET_PARA_VALUE(2,‘CACHE_POOL_SIZE’, 1024);
SP_SET_PARA_VALUE(2,‘DICT_BUF_SIZE’, 512);
SP_SET_PARA_VALUE(2,‘VM_POOL_TARGET’, 8192);
SP_SET_PARA_VALUE(2,‘SESS_POOL_TARGET’, 8192);
SP_SET_PARA_VALUE(2,‘USE_PLN_POOL’, 1);
SP_SET_PARA_VALUE(2,‘ENABLE_MONITOR’, 1);
SP_SET_PARA_VALUE(2,‘SVR_LOG’, 0);
SP_SET_PARA_VALUE(2,‘TEMP_SIZE’, 1024);
SP_SET_PARA_VALUE(2,‘TEMP_SPACE_LIMIT’, 102400);
SP_SET_PARA_VALUE(2,‘MAX_SESSIONS’, 300);
SP_SET_PARA_VALUE(2,‘MAX_SESSION_STATEMENT’, 20000);
SP_SET_PARA_VALUE(2,‘PK_WITH_CLUSTER’, 1);
SP_SET_PARA_VALUE(2,‘ENABLE_ENCRYPT’,0);
SP_SET_PARA_VALUE(2,‘OLAP_FLAG’,2);
SP_SET_PARA_VALUE(2,‘VIEW_PULLUP_FLAG’,1);
SP_SET_PARA_VALUE(2,‘OPTIMIZER_MODE’,1);
SP_SET_PARA_VALUE(2,‘ADAPTIVE_NPLN_FLAG’,0);
SP_SET_PARA_VALUE(2,‘MONITOR_INDEX_FLAG’,2);
SP_SET_PARA_VALUE(2,‘ENABLE_CREATE_BM_INDEX_FLAG’,0);
SP_SET_PARA_VALUE(2,‘PARALLEL_PURGE_FLAG’,1);
SP_SET_PARA_VALUE(2,‘PARALLEL_POLICY’,2);
SP_SET_PARA_DOUBLE_VALUE(2,‘UNDO_RETENTION’,900);
SP_SET_PARA_VALUE(2,‘UNDO_EXTENT_NUM’,16);
SP_SET_PARA_VALUE(2,‘ENABLE_INJECT_HINT’,1);
SP_SET_PARA_VALUE(2,‘BTR_SPLIT_MODE’,1);
SP_SET_PARA_VALUE(2,‘FAST_LOGIN’,1);
SP_SET_PARA_VALUE(2,‘ENABLE_MONITOR_BP’,0);
SP_SET_PARA_VALUE(1,‘SLCT_OPT_FLAG’,0);
COMMIT;
机器24C32G:
SP_SET_PARA_VALUE(2,‘WORKER_THREADS’,24);
SP_SET_PARA_VALUE(2,‘IO_THR_GROUPS’,16);
SP_SET_PARA_VALUE(2,‘GEN_SQL_MEM_RECLAIM’,0);
SP_SET_PARA_VALUE(2,‘MAX_OS_MEMORY’, 100);
SP_SET_PARA_VALUE(2,‘MEMORY_POOL’, 2000);
SP_SET_PARA_VALUE(2,‘MEMORY_N_POOLS’, 11);
SP_SET_PARA_VALUE(2,‘MEMORY_TARGET’, 2000);
SP_SET_PARA_VALUE(2,‘BUFFER’, 10000);
SP_SET_PARA_VALUE(2,‘BUFFER_POOLS’, 37);
SP_SET_PARA_VALUE(2,‘RECYCLE’, 1000);
SP_SET_PARA_VALUE(2,‘RECYCLE_POOLS’, 7);
SP_SET_PARA_VALUE(2,‘FAST_POOL_PAGES’, 9999);
SP_SET_PARA_VALUE(2,‘FAST_ROLL_PAGES’, 1000);
SP_SET_PARA_VALUE(2,‘ENABLE_FREQROOTS’,1);
SP_SET_PARA_VALUE(2,‘MULTI_PAGE_GET_NUM’,1);
SP_SET_PARA_VALUE(2,‘PRELOAD_SCAN_NUM’,0);
SP_SET_PARA_VALUE(2,‘PRELOAD_EXTENT_NUM’,0);
SP_SET_PARA_VALUE(2,‘TASK_THREADS’,8);
SP_SET_PARA_VALUE(2,‘MEMORY_MAGIC_CHECK’, 1);
SP_SET_PARA_VALUE(1,‘HJ_BUF_GLOBAL_SIZE’, 2000);
SP_SET_PARA_VALUE(1,‘HJ_BUF_SIZE’, 250);
SP_SET_PARA_VALUE(1,‘HAGR_BUF_GLOBAL_SIZE’,2000);
SP_SET_PARA_VALUE(1,‘HAGR_BUF_SIZE’, 250);
SP_SET_PARA_VALUE(2,‘SORT_FLAG’,0);
SP_SET_PARA_VALUE(2,‘SORT_BLK_SIZE’,1);
SP_SET_PARA_VALUE(2,‘SORT_BUF_SIZE’, 10);
SP_SET_PARA_VALUE(2,‘SORT_BUF_GLOBAL_SIZE’, 2000);
SP_SET_PARA_VALUE(2,‘RLOG_POOL_SIZE’, 1024);
SP_SET_PARA_VALUE(2,‘CACHE_POOL_SIZE’, 1024);
SP_SET_PARA_VALUE(2,‘DICT_BUF_SIZE’, 512);
SP_SET_PARA_VALUE(2,‘VM_POOL_TARGET’, 8192);
SP_SET_PARA_VALUE(2,‘SESS_POOL_TARGET’, 8192);
SP_SET_PARA_VALUE(2,‘USE_PLN_POOL’, 1);
SP_SET_PARA_VALUE(2,‘ENABLE_MONITOR’, 1);
SP_SET_PARA_VALUE(2,‘SVR_LOG’, 0);
SP_SET_PARA_VALUE(2,‘TEMP_SIZE’, 1024);
SP_SET_PARA_VALUE(2,‘TEMP_SPACE_LIMIT’, 102400);
SP_SET_PARA_VALUE(2,‘MAX_SESSIONS’, 300);
SP_SET_PARA_VALUE(2,‘MAX_SESSION_STATEMENT’, 20000);
SP_SET_PARA_VALUE(2,‘PK_WITH_CLUSTER’, 1);
SP_SET_PARA_VALUE(2,‘ENABLE_ENCRYPT’,0);
SP_SET_PARA_VALUE(2,‘OLAP_FLAG’,2);
SP_SET_PARA_VALUE(2,‘VIEW_PULLUP_FLAG’,1);
SP_SET_PARA_VALUE(2,‘OPTIMIZER_MODE’,1);
SP_SET_PARA_VALUE(2,‘ADAPTIVE_NPLN_FLAG’,0);
SP_SET_PARA_VALUE(2,‘MONITOR_INDEX_FLAG’,2);
SP_SET_PARA_VALUE(2,‘ENABLE_CREATE_BM_INDEX_FLAG’,0);
SP_SET_PARA_VALUE(2,‘PARALLEL_PURGE_FLAG’,1);
SP_SET_PARA_VALUE(2,‘PARALLEL_POLICY’,2);
SP_SET_PARA_DOUBLE_VALUE(2,‘UNDO_RETENTION’,900);
SP_SET_PARA_VALUE(2,‘UNDO_EXTENT_NUM’,16);
SP_SET_PARA_VALUE(2,‘ENABLE_INJECT_HINT’,1);
SP_SET_PARA_VALUE(2,‘BTR_SPLIT_MODE’,1);
SP_SET_PARA_VALUE(2,‘FAST_LOGIN’,1);
SP_SET_PARA_VALUE(2,‘ENABLE_MONITOR_BP’,0);
SP_SET_PARA_VALUE(1,‘SLCT_OPT_FLAG’,0);
COMMIT;
–配置归档
select arch_mode from vdatabase;alterdatabasemount;alterdatabasearchivelog;ALTERDATABASEADDARCHIVELOG′DEST=/data/dmdba/dmarch,TYPE=local,FILESIZE=2048,SPACELIMIT=102400′;alterdatabaseopen;selectarchmodefromvdatabase;
exit;
配置sql日志
vi /data/dmdba/dmdata/DAMENG/sqllog.ini
内存大于等于32G调整如下3个参数
BUF_TOTAL_SIZE = 1024000 #SQLs Log Buffer Total Size(K)(1024~1024000)
BUF_SIZE = 10240
BUF_KEEP_CNT = 20
SWITCH_MODE = 2 ## 日志文件切换模式 2 按文件大小切换
SWITCH_LIMIT = 256 ## 文件大小限制,默认128,要求配置256,单位MB
FILE_NUM = 20 ## 打印日志文件个数,默认5,要求配置20
保存退出
登录数据库
./disql SYSDBA/’“Dameng@123”’
执行:
SP_SET_PARA_VALUE(1,‘SVR_LOG’,1);
SP_SET_PARA_VALUE(2,‘AUDIT_MAX_FILE_SIZE’,4096);
SP_SET_PARA_VALUE(2,‘AUDIT_SPACE_LIMIT’,204800);
COMMIT;
配置定时备份
SP_INIT_JOB_SYS(1);
call SP_CREATE_JOB(‘FULL-BACKUP’,1,0,’’,0,0,’’,0,‘全量备份’);
call SP_JOB_CONFIG_START(‘FULL-BACKUP’);
call SP_ADD_JOB_STEP_EX(‘FULL-BACKUP’, ‘SETP01-FULLBACKUP’, 6, ‘05000000/data/dmdba/dmdata/DAMENG/bak’, 3, 1, 0, 0, NULL, 0, ‘null’);
call SP_ADD_JOB_STEP_EX(‘FULL-BACKUP’, ‘STEP02-DELBACK’, 0, ‘call sf_bakset_backup_dir_add(’‘DISK’’,’’/data/dmdba/dmdata/DAMENG/bak’’);
call sp_db_bakset_remove_batch(’‘DISK’’,now()-14);’, 1, 1, 0, 0, NULL, 0, ‘null’);
CALL SP_JOB_STEP_SET_NEXT_STEP(‘FULL-BACKUP’, ‘SETP01-FULLBACKUP’, ‘STEP02-DELBACK’, NULL);
call SP_ADD_JOB_SCHEDULE(‘FULL-BACKUP’, ‘SCH01-FULLBACKUP’, 1, 1, 1, 0, 0, ‘02:00:46’, NULL, ‘2026-04-29 13:47:46’, NULL, ‘’);
call SP_JOB_CONFIG_COMMIT(‘FULL-BACKUP’);
call SP_JOB_SET_SCHEMA(‘FULL-BACKUP’, ‘SYSDBA’);
测试备份
查询备份作业
select id,name from sysjob.sysjobs;
手动执行备份
SP_DBMS_JOB_RUN(id);
–限制MAIN.DBF表空间TEMP.DBF表空间
alter tablespace “MAIN” datafile ‘MAIN.DBF’ autoextend on maxsize 102400;
SP_SET_PARA_VALUE(2,‘TEMP_SPACE_LIMIT’,204800);
COMMIT;
查询授权、实例、版本信息
select * from vlicense;select∗fromvinstance;
select * from v$version;
select ID_CODE;
exit;
关闭实例:
cd /data/dmdba/dmdbms/bin
./DmService5236 stop
反馈OK 表示关闭成功
./DmService5236 start
反馈ok 表示启动成功
切到root用户下
reboot
重启后查看进程
ps -ef|grep dms
文章
阅读量
获赞
