操作系统:Oracle redhat 7.6
数据库版本:Oracle 12.2 (
三节点RAC 没有使用多租户)
监控告警:
SCHEDULER JOBS FAIL WITH ORA-27468: ""."" IS LOCKED BY ANOTHER PROCESS (Doc ID2485355.1)
Scheduler jobs using multitenant are failing with ORA-27468:""."" is locked by another processTrace file /opt/oracle/diag/***/***_j000_15790.trcOracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit ProductionBuild label: RDBMS_12.2.0.1.0_LINUX.X64_170125ORACLE_HOME: /opt/oracle/product/***/***System name: LinuxNode name: ***Release: 3.10.0-514.26.2.el7.x86_64Version: #1 SMP Fri Jun 30 05:26:04 UTC 2017Machine: x86_64Instance name: ***Redo thread mounted by this instance: 2Oracle process number: 59Unix process pid: 15790, image: *** (J000)*** 2018-12-09T08:13:26.286604+09:00*** SESSION ID:(247.39973) 2018-12-09T08:13:26.286630+09:00*** CLIENT ID:() 2018-12-09T08:13:26.286637+09:00*** SERVICE NAME:(SYS$USERS) 2018-12-09T08:13:26.286644+09:00*** MODULE NAME:(DBMS_SCHEDULER) 2018-12-09T08:13:26.286650+09:00*** ACTION NAME:(CLEANUP_NON_EXIST_OBJ) 2018-12-09T08:13:26.286657+09:00*** CLIENT DRIVER:() 2018-12-09T08:13:26.286663+09:00ORA-27468: ""."" IS LOCKED BY ANOTHER PROCESS
CHANGESVersion 12.2.0.1CAUSEThis issue is caused by below bug:BUG 28854733 - SCHEDULER JOBS FAIL WITH ORA-27468: ""."" IS LOCKED BY ANOTHER PROCESS
这个问题是间歇性的,不是一直报错,因不影响生产所以,没有打补丁,从描述看到20C才修复。
ORA-27468: ""."" IS LOCKED BY ANOTHER PROCESS
来源:这里教程网
时间:2026-03-03 15:09:42
作者:
编辑推荐:
下一篇:
相关推荐
-
雷神推出 MIX PRO II 迷你主机:基于 Ultra 200H,玻璃上盖 + ARGB 灯效
2 月 9 日消息,雷神 (THUNDEROBOT) 现已宣布推出基于英
-
制造商 Musnap 推出彩色墨水屏电纸书 Ocean C:支持手写笔、第三方安卓应用
2 月 10 日消息,制造商 Musnap 现已在海外推出一款 Oce
热文推荐
- ORA-27468: ""."" IS LOCKED BY ANOTHER PROCESS
- Oracle轻量级实时监控工具-oratop
Oracle轻量级实时监控工具-oratop
26-03-03 - Oracle Database 20c 官方文档以及云端版本已发布
Oracle Database 20c 官方文档以及云端版本已发布
26-03-03 - DB2数据库适配NC65
DB2数据库适配NC65
26-03-03 - ISO 镜像安装oracle 10g
ISO 镜像安装oracle 10g
26-03-03 - ORA-01555 快照太旧
ORA-01555 快照太旧
26-03-03 - ORACLE数据库之大数据量TRUNCATE和DELETE操作对表空间的影响
- Oracle 12C新特性-数据泵新参数(LOGTIME)
Oracle 12C新特性-数据泵新参数(LOGTIME)
26-03-03 - Oracle性能优化-SQL优化(案例一)
Oracle性能优化-SQL优化(案例一)
26-03-03 - number----char(to_char)
number----char(to_char)
26-03-03
