Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error failover rac

luix97Mar 10 2010 — edited Mar 10 2010
hello 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 !
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 7 2010
Added on Mar 10 2010
3 comments
1,221 views