Listener refused the connection with the following error: ORA-12514

Question

I am trying to connect to an Oracle Database using java and JDBC code. I can't do that because I get the error below:

java.sql.SQLException: Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

What is the reason for the error and how to fix it ?

PS- Out of all the DBMS, Oracle express 11g seems to be the most complicated and difficult to use. Is that really the case ?

Answer 1

Listener does not currently know of service requested in connect descriptor

Self explainatory. You're requesting connection to a service or instance in a DB that the DB's listener does not know, so it says "I have no clue".

Check the way you installed your Oracle 11g express. Remember that the service name there is often "xe".