告警日志中出现ORA-48132 ORA-48170
更新时间: 2022-06-12 09:01
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