Home » Server Options » RAC & Failsafe » RAC and its behaviour
RAC and its behaviour [message #567299] Wed, 26 September 2012 06:12 Go to next message
Messages: 168
Registered: June 2011
Location: Poland/Czestochowa
Senior Member

i did some test with my RAC environment (2 nodes, 10g).

i am using TAF, and users connect with PRECONNECT method and SELECT option.
so teorethically if i invoke something like this on the first node:

select * from test;

where test contains 3 milions rows, and simulate crash of this node. my session will be reconnected on the other one and select will be reinvoked.
and this behaves in my enviromnent as i suspected.


but second test was with procedure. i know that DML reinvoking is not supported in RAC so i even didnt try to do this but i thought that maybe procedures execution could be reinvoked in RAC.

lets try this exemplary procedure:

create or replace procedure dotest is
v1 date;
for i in 1..1000000 loop
select sysdate into v1 from dual;
end loop;
end dotest;

when i do:

exec dotest;

and crash node on which this procedure was executed, the session hangs and nothing happens. i thought that maybe some ORA will be displayed but during such simulation nothing happened.

is it normal behavior that RAC is not reinvoking procedures after node crash?

Re: RAC and its behaviour [message #570520 is a reply to message #567299] Sun, 11 November 2012 16:52 Go to previous message
Messages: 147
Registered: October 2009
Location: Dallas, TX
Senior Member
Procedure execution does not failover. As stated in the Oracle documentation for SELECT failover, only simple select statements fail over.
Previous Topic: Clusterware installation
Next Topic: how to prevent VIP transfer back to it's original node location
Goto Forum:

Current Time: Wed Mar 29 21:59:41 CDT 2023