ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

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:

sqlplus username/password@addressname[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?

28 Answers
28

Leave a Comment