4 Replies Latest reply: Sep 9, 2013 4:23 PM by user8894222 RSS

    Question about how SQL Developer Connects to DB

    user8894222

      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?