I'm trying to test TAF and client connection failover, for a 3 node cluster db by faking the first entry in my tnsnames.ora file and connecting with SQL Developer.
In theory SQL Developer should failover to the second node listed in my tnsnames.ora file.
The problem is that no matter what I put in my tnsnames.ora file, SQL Developer still connects to the first listed database, proddb1, EVEN when I 1) remove that entry from TNS and 2) when I misspell the entry so it doesn't resolve in DNS.
So how does SQL Developer connect to the DB? Is there a cache somewhere that I'm not seeing?
So how does SQL Developer connect to the DB?
It connects the way you told it to when you created the connection.
If you create a connection using the default 'Basic' connection type Sql Developer doesn't even use the TNSNAMES.ORA file so it doesn't matter what is in it or if it even exists.
You have to post ALL of the connection settings that you used when you created the connection before anyone can answer your question.
Did you specify the TNSnames directory in the preferences? It's possible it's using the wrong tns file to do the connect. It's even possible it found multiple TNS files in that directory and it's not using the one you intend for it to. You can see this if you follow this 'trick.'