We have the application running locally where we are experiencing the below error:
“ORA-12514: TNS:listener does not currently know of service requested in connect descriptor”
I have already tested the connection using the TNSPing which resolved it correctly and when I tried the SQLPlus connecting, which failed unfortunately with the above error. I have used below syntax for my SQLPlus :
sqlplus username/password@addressname[or host name]
We have already verified that:
· My TNS Listener on my server is running.
· Also Oracle itself on my server is running.
We are unable to know of any changes that were made to my environment. Anything else that we can test?