I was using Oracle 9 client and SQL Navigator 5 to connect to an Oracle 10 database before.
Our database got upgraded to 11g and I couldn’t connect to it using SQL Nav 5. I read that it is incompatible and hence I installed 6.3 and Oracle 11g Client.
When I opened SQL Nav 6.3 for the first time, it asked me the previous version’s properties should be imported and I said YES. But since then I get the below error when I try to connect to the database through the TNS entry.
ORA-12154: TNS:could not resolve the connect identifier specified
I am able to connect and query the tables using the “Direct” option. Please suggest.