[20190313]备份问题.txt --//生产系统遇到备份问题,同事请求检查看看,提示应该是ulimit参数限制. --//首先我不熟悉这套备份系统,我心里很反感这套备份模式,我开始以为修改/etc/security/limits.conf就ok了. # grep -v "^#" /etc/security/limits.conf oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 65536 oracle hard nofile 65536 oracle soft memlock 2457600 oracle hard memlock 2457600 --//发现还是不行,问了一些细节,发现通过root进程下的一个服务完成备份: # ps -ef | grep avata[r] root 23601 1 0 2018 ? 00:00:06 /usr/local/avatar/client_server/sbin/avatardevice -v -c /usr/local/avatar/client_server/etc/avatardevice.conf root 23613 1 0 2018 ? 05:16:39 /usr/local/avatar/client_server/sbin/avatarclient -v -c /usr/local/avatar/client_server/etc/avatarclient.conf --//而这两个进程是root用户的,这样应该修改root用户对于参数加入如下: * soft nofile 65536 * hard nofile 65536 --//我在猜想为什么该进程要打开如此之多的文件句柄. # ls -l /proc/23613/fd |wc 591 4902 47629 --//昏,已经使用591个文件句柄. # ls -l /proc/23613/fd | cut -f2 -d ">" | sort | uniq -c 3 /dev/null 1 socket:[76605529] 1 total 0 292 /usr/local/avatar/client_server/data 292 /usr/local/avatar/client_server/data/ora_scripts 1 /usr/local/avatar/client_server/log 1 /usr/local/avatar/client_server/log/avatarclient20181022.log --//很明显这家公司的产品写的程序有问题,大量的重复打开相同的文件句柄,!!估计每次备份打开1次,292天就292次,并且完成后竟然不 --//写关闭句柄的语句,国内的水平就是这样!!打着所谓的高科技骗人, --//这样再大的参数设置最终也会撑爆的,也许最佳的方式定时重启这个服务. # service avatarclient restart Stopping the Avatar Client daemon Stopping the Avatar Device daemon Starting the Avatar Device daemon Starting the Avatar Client daemon # ps -ef | grep avata[r] root 5414 1 0 15:53 ? 00:00:00 /usr/local/avatar/client_server/sbin/avatardevice -v -c /usr/local/avatar/client_server/etc/avatardevice.conf root 5425 1 0 15:53 ? 00:00:00 /usr/local/avatar/client_server/sbin/avatarclient -v -c /usr/local/avatar/client_server/etc/avatarclient.conf # ls -l /proc/5425/fd total 0 lr-x------ 1 root root 64 2019-03-13 15:53:52 0 -> /dev/null lr-x------ 1 root root 64 2019-03-13 15:53:52 1 -> /dev/null lr-x------ 1 root root 64 2019-03-13 15:53:52 2 -> /dev/null lrwx------ 1 root root 64 2019-03-13 15:53:52 3 -> socket:[86753325] lr-x------ 1 root root 64 2019-03-13 15:53:52 4 -> /usr/local/avatar/client_server/log lrwx------ 1 root root 64 2019-03-13 15:53:52 5 -> /usr/local/avatar/client_server/log/avatarclient20190313.log --//现在没有前面看到的2个文件句柄. # cat /proc/5425/limits Limit Soft Limit Hard Limit Units Max cpu time unlimited unlimited seconds Max file size unlimited unlimited bytes Max data size unlimited unlimited bytes Max stack size 10485760 unlimited bytes Max core file size 0 unlimited bytes Max resident set unlimited unlimited bytes Max processes 1024 30148 processes Max open files 1024 1024 files ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Max locked memory 65536 65536 bytes Max address space unlimited unlimited bytes Max file locks unlimited unlimited locks Max pending signals 30148 30148 signals Max msgqueue size 819200 819200 bytes Max nice priority 0 0 Max realtime priority 0 0 Max realtime timeout unlimited unlimited us --//注:可以发现我这样操作不行,必须注销root用户然后再重新启动服务才生效.以下是退出重启后的情况: ps -ef | grep avata[r] root 5905 1 0 16:00 ? 00:00:00 /usr/local/avatar/client_server/sbin/avatardevice -v -c /usr/local/avatar/client_server/etc/avatardevice.conf root 5916 1 0 16:00 ? 00:00:00 /usr/local/avatar/client_server/sbin/avatarclient -v -c /usr/local/avatar/client_server/etc/avatarclient.conf # cat /proc/5916/limits Limit Soft Limit Hard Limit Units Max cpu time unlimited unlimited seconds Max file size unlimited unlimited bytes Max data size unlimited unlimited bytes Max stack size 10485760 unlimited bytes Max core file size 0 unlimited bytes Max resident set unlimited unlimited bytes Max processes 1024 30148 processes Max open files 65536 65536 files Max locked memory 65536 65536 bytes Max address space unlimited unlimited bytes Max file locks unlimited unlimited locks Max pending signals 30148 30148 signals Max msgqueue size 819200 819200 bytes Max nice priority 0 0 Max realtime priority 0 0 Max realtime timeout unlimited unlimited us
[20190313]备份问题.txt
来源:这里教程网
时间:2026-03-03 13:03:20
作者:
编辑推荐:
- [20190313]备份问题.txt03-03
- [20190314]理解TRANSPORT_CONNECT_TIMEOUT RETRY_COUNT参数在tnsnames.ora.tx03-03
- awr报告03-03
- 如何清除创建失败的索引03-03
- OGG参数详解03-03
- 安装oracle11g碰到“无法访问临时位置”的问题03-03
- [20190306]奇怪的查询结果.txt03-03
- [20190306]11g health monitor.txt03-03
下一篇:
相关推荐
-
雷神推出 MIX PRO II 迷你主机:基于 Ultra 200H,玻璃上盖 + ARGB 灯效
2 月 9 日消息,雷神 (THUNDEROBOT) 现已宣布推出基于英
-
制造商 Musnap 推出彩色墨水屏电纸书 Ocean C:支持手写笔、第三方安卓应用
2 月 10 日消息,制造商 Musnap 现已在海外推出一款 Oce
热文推荐
- exp报错与exp为何导不出某些表结构原因
exp报错与exp为何导不出某些表结构原因
26-03-03 - 2-plsql开发工具安装
2-plsql开发工具安装
26-03-03 - 【kingsql分享】Oracle Database 19c的各种新特性介绍
- Oracle RMAN两种库增量备份的差别及实验增量差异和累积增量备份的区别
- 故障排除 | enq:TX - index contention等待事件
故障排除 | enq:TX - index contention等待事件
26-03-03 - oracle 12c 多租户体系结构概念
oracle 12c 多租户体系结构概念
26-03-03 - Debian Samba域控制器配置(手把手教你用Debian搭建Samba Active Directory域控制器)
- 审计表 aud$ 清理
审计表 aud$ 清理
26-03-03 - Data Guard备库日志的实时应用与非实时应用
Data Guard备库日志的实时应用与非实时应用
26-03-03 - 安装ORACLE 12.2.0.1 GI 时遇到INS-44002错误
安装ORACLE 12.2.0.1 GI 时遇到INS-44002错误
26-03-03
