ORA-25408: cannot safely replay the call
754619Feb 18 2010 — edited Feb 18 2010We have the following error infrequently when our two clustered
applications call RAC.
Database #12002 - Database read failure. Reason: ODBC error:
state HY000, General error, [Oracle][ODBC][Ora]ORA-25408: cannot
safely replay the call
. SQL statement: select ALERT_CUSTOM_ATTRIBUTES_ID
FROM alerts WHERE alert_id= ?
The below shows our tnsnames.ora. Please see the file and what
caused this error.
AMLPRD1 =
(DESCRIPTION=
(ADDRESS_LIST =
(LOAD_BALANCE = ON)
(FAILOVER = ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = first_node_ip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = second_node_ip)(PORT =
1521))
)
(CONNECT_DATA =
(SERVICE_NAME = AMLPRD)
(SERVER = DEDICATED)
(
FAILOVER_MODE =
(BACKUP=AMLPRD2)(TYPE=SESSION)(METHOD=BASIC)
(RETRIES=12)(DELAY=5)
)
)
)
AMLPRD2 =
(DESCRIPTION=
(ADDRESS_LIST =
(LOAD_BALANCE = ON)
(FAILOVER = ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = second_node_id)(PORT =
1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = first_node_id)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = AMLPRD)
(SERVER = DEDICATED)
(
FAILOVER_MODE =
(BACKUP=AMLPRD1)(TYPE=SESSION)(METHOD=BASIC)
(RETRIES=12)(DELAY=5)
)
)
)
Thanks for your investigation.