Toad World® Forums

Getting ORA-12154 error with SQL Navigator 6.3 and Oracle 11g client

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.


Hi Raghu,

Thanks for leaving us the message. For your questions about getting ORA-12154 error with SQL Navigator 6.3 and Oracle 11g client, Shirly has provided some suggestion as a workaround in SQL Navigator community page, please check .

Please don’t hesitate to contact us again if you have any further questions or if you have encountered any issue for SQL Optimizer for Oracle, please feel free to leave your message here.

Thanks and Regards,