Re: ORA-25408 consistently

From: Tim Gorman <tim_at_evdbt.com>
Date: Sun, 09 Mar 2008 09:51:57 -0600
Message-ID: <47D4079D.2070906@evdbt.com>


YRC (you recall correctly) -- TAF does not work for program units (i.e. PL/SQL), DML (i.e. INSERT, UPDATE, DELETE, SELECT ... FOR UPDATE), DDL (i.e. CREATE, ALTER, DROP, TRUNCATE, GRANT, REVOKE, etc), but only for idle sessions and SELECT statements...

Yechiel Adar wrote:
> IIRC (and I mean a big if) - TAF works only for select statements.
>
> Adar Yechiel
> Rechovot, Israel
>
>
>
> Ujang Jaenudin wrote:
>> all,
>>
>> I have a simple procedure which contain only select statement and
>> print a result.
>> when executing that procedure let say on node 1 (RAC - 3 nodes), and
>> I shutdown abort on node 1 (failover simulatiion),
>> I got ORA-25408 consistently.
>>
>> session successfully failedover to other node, but the execution of
>> procedure is stopped.
>>
>> Is it expected behavior or a bug?? i found bug no. 6767933 so far...
>> thanks for your sharing...
>>
>> --
>> regards
>> ujang
>>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Sun Mar 09 2008 - 10:51:57 CDT

Original text of this message