ORA-27468: ""."" IS LOCKED BY ANOTHER PROCESS

来源:这里教程网 时间:2026-03-03 15:09:42 作者:

操作系统: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才修复。

相关推荐