OraFAQ Forum: RAC & Failsafe » RAC and its behaviour

Home » Server Options » RAC & Failsafe » RAC and its behaviour

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

RAC and its behaviour [message #567299]

Wed, 26 September 2012 06:12

piotrtal
Messages: 168
Registered: June 2011
Location: Poland/Czestochowa

Senior Member

Hi,

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:

Code: [Select all] [Show/ hide]

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:

Code: [Select all] [Show/ hide]

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

when i do:

Code: [Select all] [Show/ hide]

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?

thanks

Report message to a moderator

Re: RAC and its behaviour [message #570520 is a reply to message #567299]

Sun, 11 November 2012 16:52

mkounalis
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.

Report message to a moderator

Previous Topic:	Clusterware installation
Next Topic:	how to prevent VIP transfer back to it's original node location

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 13:10:30 CDT 2025