Search code examples
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:

    • Shutdown database by command "shutdown"
    • Start the database but by"startup mount" to prevent that it is tried to open it
    • Make a "select * from v$log" to see the redo logs
    • Make a recovery by "recover database until time 'YYYY-MM-DD HH:MM:SS';" with a datetime that is inside the redo log that is marked as "CURRENT".
    • The system should report "Media recovery complete"
    • Then make a "alter database open resetlogs;". This resets all active redologs and opens the database.
    • Then shutdown database
    • Then start database by comment "startup" (w/o option)
    • The system should now report "Database open"