patternMinor
Oracle TNS names configuration
Viewed 0 times
configurationoracletnsnames
Problem
I've edited added new TNS name to
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?
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
Please follow the below steps:
I think this will be very clear ,cheer
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.