RE: TAF FUN - Call me crazy

From: <krish.hariharan_at_quasardb.com>
Date: Mon, 5 May 2008 08:37:59 -0600
Message-ID: <001e01c8aebd$a059a2a0$6501a8c0@BHAIRAVIPC01>

I would suggest ruling out the following, if you haven't already:  

1. The same service is not advertised in multiple instances/databases
2. The same user/password does not work with multiple databases (just for the purity of the test)

Please post the TNS names entry and the secondary entry if you are using a backup TNS names.  

-Krish
   

---

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of steve montgomerie
Sent: Monday, May 05, 2008 7:17 AM
To: oracle-l_at_freelists.org
Subject: TAF FUN - Call me crazy  

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 - 09:37:59 CDT