暂无图片
oracle服务宕机了,日志如下,请问各位大佬如何处理?
我来答
分享
手机用户5704
2022-12-06
oracle服务宕机了,日志如下,请问各位大佬如何处理?

sat Dec 03 02:33:27 2022WARNING: Heavy swapping observed on system in last 5 mins .pct of memory swapped in [0.15%] pct of memory swapped out [5.65%].please make sure there is no memory pressure and the SGA and PGAare configured correctly. Look at DBRM trace file for more details .sat Dec 03 02:34:15 2022PMON (ospid: 45569): terminating the instance due to error 471sat Dec 03 02:34:15 2022System state dump requested by instance=l, osid-45569 (PMON)), summary=[abnormal instance termination].5ystem State dumped to trace file /opt/oracle/diag/rdbms/orcl/orcl/trace/orcl_diag_45579_20221203023415.trcInstance terminated by PMON, pid = 45569sat Dec 03 17:52:17 2022Adjusting the default value of parameter parallel max serversfrom 640 to 570 due to the value of parameter processes (600.Starting ORACLE instance (normal)

我来答
添加附件
收藏
分享
问题补充
2条回答
默认
最新
游湖

你这日志太乱了,看起来是swap被占用导致,pct of memory swapped in [0.15%] pct of memory swapped out [5.65%].

可能是数据库大页的问题。

1检查内存占用率。

2根据下ulimit -l,如果是64的话,应该就有问题。执行ulimit -l unlimited,并修改/etc/security/limits.conf下的以下两行,后面的值是内存的大小,单位k。重启oracle应该可以得到解决。

* soft memlock 33554432

* hard memlock 33554432

暂无图片 评论
暂无图片 有用 4
暂无图片
游湖
答主
2022-12-06
求采纳
Ty3306
2022-12-06
T
Ty3306

学习了

暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏