TNS-12547: TNS:lost contact. Oracle XE 18c was installed on Windows 10 computer, the installation and configuration were good, I was able to icreate users and other database objects, no problem to login to XE, the second day, I can no longer login to the database, it happened twice on 2 computers, the erros are the same (from SQLplus):
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
Checking Listener log file, found Listener lost contact to database:
---------Listener Log file -----------------------------------------
2019-04-09T12:18:16.254111-04:00
09-APR-2019 12:18:16 * service_update * xe * 0
2019-04-09T12:18:22.050293-04:00
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=127.0.0.1)(PORT=5500))(Security=(my_wallet_directory=C:\ORACLEXE\admin\XE\xdb_wallet))(Presentation=HTTP)(Session=RAW))
09-APR-2019 12:18:22 * service_died * xe * 12547
TNS-12547: TNS:lost contact
2019-04-09T12:19:01.033294-04:00
-------------------------------------------------------------------
XE and Listener are still running, restarting them didn't fix the problem.