1

I have installed the Oracle Client 10.2.1 32bit in an X64 WIN7 laptop. I have Installed also TOAD and PLSQLDeveloper but both of them are not working and the error is: ORA-12154:TNS could not resolved the connection idebrified. While with the NET MANAGER I can connect with the database. Any idea how can I resolve this big issue?

Thanks

ekekakos
  • 53
  • 1
  • 7

2 Answers2

1

This is probably due to the parenthesis in the folder in which the client application has been installed (x86).

More detail and solutions can be found here

vc 74
  • 37,131
  • 7
  • 73
  • 89
0

The error TNS could not resolve service name usually means that the client is not able to find the tnsnames.ora file. There are several locations where the clients tries to find it, one of the first locations is in %ORACLE_HOME%/network/admin Better is to define a environment variable TNS_ADMIN and make that point to a directory where the sql*net files are located. you can use tnsping your_service_name to check the resolution.