Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Still using an old tnsnames.ora even though it was erased

442223Dec 10 2007 — edited Dec 14 2007
I downloaded and unzipped 1.2.1-32.13. But it is not reading my new tnsnames.ora.

My operating system is XP pro.

Initially I had just the oracle client installed with it's own tnsnames.ora and added sqldeveloper 1.0.0 and then later 1.2.1. I couldn't get my connections to work at all in either one. Unfortunately this was a corporate install that had some "wrapper" on it, not just the Oracle install tool and I removed it by running Oracle install tool and then removing oracle_home from the registry - something initially fishy here because Oracle couldn't completely get rid of it.

I then installed a full oracle 10g and put a good tnsnames.ora there. Now sqlplus and the database work fine, but sql-developer 1.2.1 still has the old (bad) tnsnames even though the file no longer exists. I did a full search of both C and D drives including system and hidden files for a file with a string that existed only in the old tnsnames file that sqldeveloper still shows and it came up with no matching files. I also can't find it in the registry (didn't expect to tho).

My previous version of sqldeveloper (1.0.0.15.57) finds the new tnsnames.ora just fine and works well, but the new one is stuck with the old entries and I can't figure out how to tell it to get the new file.

Thanks for any help.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 11 2008
Added on Dec 10 2007
7 comments
4,205 views