ORA-23621: Operation corresponding to script string is in progress. ORACLE 报错 故障修复 远程处理

文档解释

ORA-23621: Operation corresponding to script string is in progress.

Cause: The script was already being run in a different session or was terminated before status for the script was updated to ERROR or EXECUTED.

Action: Make sure the script is not being run in a parallel session. Then call the RECOVER_OPERATION API in the DBMS_STREAMS_ADM package with the appropriate OPERATION_MODE argument.

ORA-23621:操作与脚本字符串对应。

官方解释

常见案例

一般处理方法及步骤

1、检查正在允许的操作的进程的ID,有可能进程仍未完全关闭而造成的ORA-23621错误。可以调用v$process和v$session视图进行查询,关闭该进程及会话,或调用alter system kill session ‘sid,serial#’语句关闭其他会话连接,如果没有立即释放时可以再调用此语句。

2、检查数据库表和索引进行重建,并关注正在进行的表空间任务,有可能会出现ORA-23621错误。

3、如果仍无法解决ORA-23621问题,可尝试重新启动服务器,以解决解决ORA-23621错误。


数据运维技术 » ORA-23621: Operation corresponding to script string is in progress. ORACLE 报错 故障修复 远程处理