Oracle TNS names configuration

oracle

I've edited added new TNS name to tnsnames.ora.
Toad for Oracle started to work at once. SQL Plus doesn't work even after logoff/logon, the same problem with my build scripts.

Getting the error: ORA-12154: TNS:could not resolve the connect identifier specified

How could I fix it?

Best Answer

There are various methods of achieving this ,one of them as suggested by Yasir. Please follow the below steps:

  1. Close toad/sqlplus
  2. Create a folder TNS_ADMIN
  3. Add tnsnames.ora in TNS_ADMIN
  4. Add TNS_ADMIN in enviornment variable.
  5. Open Toad/Sqlplus and login

I think this will be very clear ,cheer

Related Question