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