Error failover rac
luix97Mar 10 2010 — edited Mar 10 2010hello everybody , i have a rac with 2 nodes, the problem is when i executed a select from client , and instance where the operation is running is down i have this error ORA-25402: transaction must roll back
i think the select could be executing in the other instance
this is my tnsnames
DANPRO =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = mxcpm9kh1101dc4-vip)(PORT = 1524))
(ADDRESS = (PROTOCOL = TCP)(HOST = mxcpm9kh1401dc4-vip)(PORT = 1524))
(FAILOVER=ON)
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = danpro)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
)
)
)
any idea??
thanks for the help !