Question about how SQL Developer Connects to DB

user8894222 Sep 9, 2013 6:59 PM

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?

1. Re: Question about how SQL Developer Connects to DB

rp0428 Sep 9, 2013 8:15 PM (in response to user8894222)

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.
Like Show 0 Likes(0)

Actions
2. Re: Question about how SQL Developer Connects to DB

user8894222 Sep 9, 2013 8:33 PM (in response to rp0428)

I'm telling SQL Developer to connect through TNS.
Like Show 0 Likes(0)

Actions
3. Re: Question about how SQL Developer Connects to DB

thatJeffSmith-Oracle Sep 9, 2013 8:47 PM (in response to user8894222)

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.'
Like Show 0 Likes(0)

Actions
4. Re: Question about how SQL Developer Connects to DB

user8894222 Sep 9, 2013 9:23 PM (in response to thatJeffSmith-Oracle)

Thanks Jeff. I double checked my preferences and the directory wasn't even set. It was using the wrong tnsnames.ora file.
Like Show 0 Likes(0)

Actions

Go to original post