We have an application running locally where we’re experiencing the following error:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
I’ve tested the connection using
TNSPing which resolved correctly and I tried
SQLPlus to try connecting, which failed with the same error as above. I used this syntax for
sqlplus username/[email protected][or host name]
We have verified that:
- the TNS Listener on the server is running.
- Oracle itself on the server is running.
We don’t know of any changes that were made to this environment. Anything else we can test?