告警日志中出现ORA-48132 ORA-48170

最新推荐文章于 2025-02-17 16:02:54 发布

cqszpx

最新推荐文章于 2025-02-17 16:02:54 发布

阅读量584

点赞数

文章标签： oracle 数据库 database

本文链接：https://blog.csdn.net/cqszpx/article/details/125395351

版权

alert 告警提示信息
ORA-48132: requested file lock is busy, [HM_FINDING] [
/db1/XXXXX/oraadmin/diag/rdbms/XXXXXX/XXXXX/lck/ ]
ORA-48170: unable to lock file - already in use
Linux-x86_64 Error: 11: Resource temporarily unavailable
处理方法
MMON Process Fails with Errors ORA-48132 and ORA-48170 (Doc ID 2265173.1)
Caused by OS level locks on the files being accessed by Oracle.
1. To release the OS level locks on the files being accessed by Oracle, please restart the database
2. If restarting the database does not work, then restart the server so that all OS level locks will be cleared