ORA-25408 Error

Last morning I get the next error

 
ORA-25408: can not safely replay call

I was taking a snapshot with the follow command;

 
EXEC DBMS_WORKLOAD_REPOSITORY.create_snapshot; 

Looking for the error using the oerr utility

 
jupiter> oerr ora  25408
25408, 00000, "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.

In this case the core problem is because of I have disable the commit in procedure. It can be enable by using the next command.

 
alter session enable commit in procedure;

The error ORA-25408 is get because of the error ORA-00034. This is a RAC and I suppose it fails and try again in other node in the RAC.

HTH – Antonio NAVARRO

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s