Shulou(Shulou.com)06/01 Report--

Operating system: Oracle redhat 7.6

Database version: Oracle 12.2 (three-node RAC does not use multi-tenancy)

Monitoring alarm:

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

This problem is intermittent, not always reported errors, because it does not affect production, so there is no patch, from the description to see 20C to fix.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.