Hi, I run Oracle XE 12c locally on Windows 64 and access it through SQL Developer. This has always worked well, but this morning, the Oracle listener failed to start (it's set to start automatically). I had not made any changes to my system. When I try to restart it manually, I get the error: "The OracleOraDB12Home1TNSListener service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs"
When I went to look at my tnsnames.ora and listener.ora files, they were not present in the ADMIN folder. Only the sqlnet.ora file was there. I created a listener.ora file with the following contents:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
And a tnsnames.ora file with the contents:
orcl =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
But this didn't help.
The database service is up and running. It's just the listener that I can't get to run. Any help would be greatly appreciated.