|Transparent Application Failover issue [message #430026]
||Sat, 07 November 2009 01:22
Registered: October 2009
i have setup 10g RAC (2node namely RAC1 & RAC2 ) on OEL4 using VMWARE on my laptop. (host o/s is windows XP)
i m not clear with Transparent Application Failover (TAF) concept.
i created one service named CRS on RAC1.
then i loggined as scott user on CRS service.
then i deleted 10 rows from EMP table.
then i issued shutd abort cmd against CRS service on one new session.
on the another new session (CRS), while issuing this query against CRS service
SYS@crs> select instance_number,instance_name,host_name from v$instance;
it returns like this
2 devdb2 rac2.mycorpdomain.com
but after the node failure occurs on CRM service, oracle server wants the active transaction should be rolled back that currently running on CRS service
i m getting this error on scott schema when i m trying to access the emp table, after the node failure occur on CRM service
ORA-25402 transaction must roll back,
without rollback the transaction on emp table i could not access it.
my question is when the node gets failed what happes to the transaction that is currently running on failed node. will it be active or should be rolled back
but the scott user on CRM service can be accessable even after the node failure. but only the active transaction need to be rolled back...
this is my situation ...
i need your valuable suggestion regarding this issue....