操作系统: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