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

操作系统：Oracle redhat 7.6

数据库版本：Oracle 12.2 （三节点RAC 没有使用多租户）

监控告警：

SCHEDULER JOBS FAIL WITH ORA-27468: ""."" IS LOCKED BY ANOTHER PROCESS (Doc ID

2485355.1)

Scheduler jobs using multitenant are failing with ORA-27468:""."" is locked by another process

Trace file /opt/oracle/diag/***/***_j000_15790.trc

Oracle Database 12c Standard Edition Release 12.2.0.1.0 - 64bit Production

Build label: RDBMS_12.2.0.1.0_LINUX.X64_170125

ORACLE_HOME: /opt/oracle/product/***/***

System name: Linux

Node name: ***

Release: 3.10.0-514.26.2.el7.x86_64

Version: #1 SMP Fri Jun 30 05:26:04 UTC 2017

Machine: x86_64

Instance name: ***

Redo thread mounted by this instance: 2

Oracle process number: 59

Unix 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:00

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

CHANGES

Version 12.2.0.1

CAUSE

This issue is caused by below bug:

BUG 28854733 - SCHEDULER JOBS FAIL WITH ORA-27468: ""."" IS LOCKED BY ANOTHER PROCESS

这个问题是间歇性的，不是一直报错，因不影响生产所以，没有打补丁，从描述看到20C才修复。