What does the error mean and how to fix it - ORA-12514: TNS:listener does not currently know of service requested in connect descriptor?

R

run1822022-04-05 10:16:57

Oracle

run182, 2022-04-05 10:16:57

Connection error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Database server version - 11.2
Client version 19.3

What does this error mean, if in more detail and how to overcome it?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

E

Evgeny Komarov, 2022-04-05
@maNULL

The error means that the listener (it's on the server) doesn't know the service you want to connect to. Check that the parameters in tnsnames.ora are correct on both the server and the client, and what exactly the listener is listening on. Did the DBMS really start?