TAF FUN - Call me crazy

From: steve montgomerie <stmontgo_at_gmail.com>
Date: Mon, 5 May 2008 09:17:03 -0400
Message-ID: <5d4504220805050617k2ee79c24v34c497f0b98f11d5@mail.gmail.com>

I'm seeing TAF fail me over to a different database. As anyone seen this behavior? Can anyone reproduce this?
Here's the simple test case......

OEL 4.5 / Oracle 10.2.0.4

4 nodes
3 databases
Each node has an instance of all db's so 3 instances per node * 4

1.connect to db_A from my client
2.select * from all objects from my client
3.from the server kill the instance that is running the query
4.query stops for a second or two and then continues on a different instance

on a different node

6.Yeah TAF works!!
7.From same session conn user_at_db_B *note different database
8.select * from all objects from my client
9.from the server kill the instance that is running the query resulting

ora-1555
10.from the same client session in step 7&8 select instance name from v$instance
results in db_A <= It failed me over to a completely different database 11 TAF no work - bummer

--
http://www.freelists.org/webpage/oracle-l

Received on Mon May 05 2008 - 08:17:03 CDT