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错误。