A developer is having a problem getting Oracle 18 XE to work.
There error message is: "Windows could not start the OracleServiceXE service on Local Computer.
Error 1069: The service did not start due to a logon failure."
screenshot:
What is the best way to solve this issue?
The following is a solution to this error:
@gmerrill - This happens quite often on the local machine where it is using this account: NT SERVICE\OracleServiceXE
and needs the default password, which probably is being stored incorrectly somewhere. Is there a place to permanently correct this?
@rabram I have had some luck changing my oracle service and oracle tns listener service to use Local System, which doesn't require a password. Not 100% sure it will work on all envs, but it works for me.
@gmerrill - it seemed to run well until I started loading data, and it did not work okay unless sqlplus loads. Also saw some server errors in the log as it ran. But I will try it out.