故障描述:通过PLSQL客户端执行调用某一存储过程,提示 ORA-25408:无法安全重放调用错误。
错误说明(摘自Oracle 社区https://community.oracle.com/message/1439962 ):
ORA-25408 can not safely replay call
Cause: The connection was lost while doing this call. It may not be safe to replay it after failover.
Action: Check to see if the results of the call have taken place, and then replay it if desired.
When testing FailOver Behavior on another machine.
At the time there the system was calling a procedure that only has a very simple query.
=======
You may receive "ORA-25408 can not safely replay call" when using Failover. This will depend on the failover type and on what you are executing.
For example if you are doing an insert and the database goes down and failover occurs, "ORA-25408 can not safely replay call" is expected and the application should handle this exception and re-execute the insert.
If you are in a transaction and failover occurs you will also receive an error message and you have to handle this and issue a rollback.
In case you have configured failover to be of type SESSION, you will not able able to recover your selects either and you will need to replay them.
=========
由于配置了failover 导致的错误。
当在PLSQL客户端执行存储过程时遇到ORA-25408错误,可能是因为配置了Failover且在会话中发生故障转移。错误处理建议检查调用结果,如果需要,重新执行。在事务中发生故障转移时,应处理错误并进行回滚。配置为SESSION级别的Failover可能影响SELECT操作,也需要重新执行。
385

被折叠的 条评论
为什么被折叠?



