SARM Server Terminates and ORA-25408 Appears When RAC Switches The Database Due to Failover

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 ： 13764045638 QQ号:47079569 邮箱：[email protected]

症状

当RAC因故障转移切换数据库时，SARM服务器终止，且在SARM/NEP诊断文件上出现ORA-25408错误。

SARM diag:

>> 131654.052:36:PROG:ASC_cprpcexec()          :1424:control/libasc/ctlib.c
RPC SSP_ne_log failed. Error code:[25408]
>> 131654.052:39:PROG:checkerr_returning_errcod:1707:control/libasc/ocilib.c
Error – ORA-25408: can not safely replay call
errcode[25408]
>> 131654.053:35:PROG:checkerr_returning_errcod:1707:control/libasc/ocilib.c
Error – ORA-25408: can not safely replay call
errcode[25408]
>> 131654.053:47:PROG:ASC_cprpcexec()          :1424:control/libasc/ctlib.c
RPC SSP_ne_log failed. Error code:[25408]
>> 131654.053:36:SANE:ASC_cprpcexec()          :3114:control/libasc/ctlib.c
Error: DB Connection re-established by TAF. Warning recieved:[25408]
>> 131654.053:36:PROG:System Event             :7475:sarm/sarm/sarm/nep_driver.c
ASAP System Event: SYS_TERM
‘SSP_ne_log’ Failed, Can’t Update NE Monitor for ‘CS2K’
>> 131654.054:35:PROG:check_status             :1113:control/libasc/ocilib.c
Error: OCIStmtExecute [ORA-25408] Failure…

>> 131654.054:35:PROG:ASC_cprpcexec()          :1424:control/libasc/ctlib.c
RPC SSP_ne_log failed. Error code:[25408]
>> 131654.055:7: LOW:ASC_cppalloc             :348 :control/libcontrol/ctlib.c
Successfully obtained a Session from the Pool
>> 131654.055:7: LOW:RPC Param                :1683:control/libasc/ctlib.c
Sending RPC [log_event] with 6 Parameters
1  : appl_cd                   = SARMDEj1
2  : file                      = sarm/sarm/sarm/nep_driver.c
3  : reason                    = ‘SSP_ne_log’ Failed, Can’t Update NE Monitor for ‘CS2K’
4  : line                      = 7475
5  : event                     = SYS_TERM
6  : event_log                 = 1
>> 131654.055:47:SANE:ASC_cprpcexec()          :3114:control/libasc/ctlib.c
Error: DB Connection re-established by TAF. Warning recieved:[25408]

NEP Diag:

>> 131222.761:15: LOW:ASC_ocicreate_cmd        :289 :control/libasc/ocilib.c
Created PL/SQL statement as follows : begin :retval :=SSP_check_blackout(:curday,:host_clli,:curr_dt_tm,:ret); end;
>> 131222.796:15:SANE:ORACLE ERROR             :1227:control/libasc/ocilib.c

— ORACLE error OCIStmtExecute

>> 131222.796:15:PROG:checkerr_returning_errcod:1707:control/libasc/ocilib.c
Error – ORA-25408: can not safely replay call
errcode[25408]
>> 131222.797:15:SANE:ASC_cprpcexec_nobind()   :2934:control/libasc/ctlib.c
Error: RPC SSP_check_blackout failed. Error code [25408]
>> 131222.797:15:SANE:ASC_cprpcexec_nobind()   :3114:control/libasc/ctlib.c
Error: DB Connection re-established by TAF. Warning recieved:[25408]
>> 131222.797:15: LOW:load_prov                :196 :sarm/libnep/blackout.c
ASC_cprpcexec_nobind() Failed !!
>> 131222.797:15: LOW:blackout                 :534 :sarm/libnep/blackout.c
NE ‘Apr 10 13:12:22 2015’ is not in blackout
>> 131222.797:15: LOW:Port Bind                :3140:sarm/libnep/sess_mgr.c
Binded to Port 08245740, Device [K06GWC_dev1] from Pool [K06GWCPL].
>> 131222.797:15: LOW:Connect                  :2915:sarm/libnep/sess_mgr.c
Connect Request: Port 08245740, Device ‘K06GWC_dev1’, Host ‘K06GWC’
>> 131222.797:16: LOW:Command Proc             :297 :sarm/libnep/cmd_proc.c
K06GWC_dev1 326: Connect K06GWC

原因

SARM 或 NEP 诊断文件中的ORA 错误’ORA-25408’是预期行为。SARM 会终止，因为它在一个存储程序SSP_ne_log failed执行过程中收到ORA 25408错误。

当数据库事务执行INSERT/UPDATE/DELETE/SELECT操作时发生了故障转移，所以出现了ORA-25408。其设计意图是让CTRL在这种情况下重启SARM。
解决方案

不需要采取措施。SARM或NEP中的 ORA 错误 ‘ORA-25408’是RAC数据库故障转移的预期行为。