HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Oracle TNS names configuration

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
configurationoracletnsnames

Problem

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?

Solution

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

  • Close toad/sqlplus



  • Create a folder TNS_ADMIN



  • Add tnsnames.ora in TNS_ADMIN



  • Add TNS_ADMIN in enviornment variable.



  • Open Toad/Sqlplus and login



I think this will be very clear ,cheer

Context

StackExchange Database Administrators Q#42196, answer score: 7

Revisions (0)

No revisions yet.