oracle-databaselistenertnsnames

Oracle 19c: Oracle Error 12514, no connection to DB possible


on my local oracle 19c installation (Windows Server 2016) everything was running fine until a Windows update from this week. Since then I get the error ORA-12514 – TNS:listener does not currently know of service requested in connect descriptor whenever I try to connect to the DB.

My listener.ora:

listener.ora

My listener Windows service is running: enter image description here

What is suspicious is that the lsnrctl utility does NOT listen my service name, it just lists the EXTPROC1521: enter image description here

Whenever I try to connect to the database I get: enter image description here

I cannot connect by any way to the Database, neither with the normal user name, than with sys or system. I tried to play with listener.ora and restarted the Windows service but all without impact :-( Can you please help me?


Solution

  • Finally solved my problem by following this instruction: https://www.programmersought.com/article/48144147987/

    The summary: