ORA-25408:无法安全重放调用

故障描述:通过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 导致的错误。                      
 

 如何解决:估计是出错的客户端的tns是配置了rac模式 并且指定了failover模式,所以调用存储过程时才导致出错,我使用连接单机tns是正常调用的。   

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值