ORA-15503: cannot startup instance when procedures in “DBMS_WORKLOAD_CAPTURE” or “DBMS_WORKLOAD_REPLAY” are in the middle of their execution ORACLE 报错 故障修复 远程处理

文档解释

ORA-15503: cannot startup instance when procedures in “DBMS_WORKLOAD_CAPTURE” or “DBMS_WORKLOAD_REPLAY” are in the middle of their execution

Cause: The new instance could not be started because the database was executing a procedure in either the DBMS_WORKLOAD_CAPTURE or DBMS_WORKLOAD_REPLAY package.

Action: Start the new instance after such procedures in the given packages have finished execution.

df

这个错误消息表明，不能当存在正在执行DBMS_WORKLOAD_CAPTURE或DBMS_WORKLOAD_REPLAY（基于工作负荷的复制）的过程时，启动实例。

官方解释

常见案例

一般处理方法及步骤

步骤1 – 使用DBMS_WORKLOAD_REPLAY包中的“终止”过程终止正在运行的工作负荷复制过程

步骤2 – 删除util_file_dir文件夹中的所有文件

步骤3 – 现在尝试再次启动实例