Hi,
I am trying to install and run Oracle XE v18.0.0 on my Windows 10 Pro laptop. This is a fairly new machine (February 2020) with 16GB RAM and 373GB of free disk space. There's just one drive (C:), no partitions.
Just for context, I initially experienced the installation "rollback" problem noted by several others in the community. I tried a number of things to resolve that (full list available on request) and finally got what appeared to be a successful installation:
However, when I attempted to connect via SQL*Plus from a command line, I received an "ORA-12560: TNS:protocol adapter error." I ran "lsnrctl status" and the listener appeared to be running:
Upon further investigation I found that there were only two Oracle services present: OracleOraDB18Home1MTSRecoveryService and OracleOraDB18Home1TNSListener, as shown below:
Research into other conversations about XE issues indicated that a service called OracleXEService should have been installed as well and is mandatory for proper function. That service is nowhere to be found on my machine.
After a good while researching and not finding any solution I decided to uninstall and reinstall Oracle XE 18c. The uninstall hung at about 25% complete (according to the progress bar) and after about an hour I killed the process, manually cleaned up the remains (removed the HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE key, uninstalled the two services shown above, deleted the install directory, deleted the C:\Program Files\Oracle directory [which had been part of my original installation rollback problem], and restarted the machine) and installed again, with identical results: an apparently successful install, but the OracleXEService is still missing.
My installation log (C:\Program Files\Oracle\Inventory\logs\InstallActions<date><time>.log) shows several warnings but no errors that I can see. Here are the warnings:
The log shows an exit status of 0. Does that indicate success or failure?
The "output" log (C:\Program Files\Oracle\Inventory\logs\InstallActions<date><time>.out) did show what appeared to be a problem:
[Clone API Thread] [ 2020-06-26 16:33:18.539 PDT ] [nativesystem.WindowsNative.Native] Opening registry key...
[Clone API Thread] [ 2020-06-26 16:33:18.539 PDT ] [nativesystem.WindowsNative.Native] Key 'Software\Oracle\Olr' does not exist
[Clone API Thread] [ 2020-06-26 16:33:18.556 PDT ] [cluster.ClusterCmd.runCmd:-1] srcLoc can't be determined: PRCI-1144 : Failed to retrieve Oracle Grid Infrastructure home path
PRKN-1036 : Windows registry key "HKEY_LOCAL_MACHINE\Software\Oracle\Olr" not found on node "localnode"
[Clone API Thread] [ 2020-06-26 16:33:18.560 PDT ] [cluster.ClusterCmd.runCmd:-1] Calling RuntimeExec to execute the command -->C:\Oracle\XE\18.0.0\dbhomeXE\bin\registerDll.bat
[Thread-7] [ 2020-06-26 16:33:18.571 PDT ] [StreamReader.run:62] In StreamReader.run
[Thread-6] [ 2020-06-26 16:33:18.571 PDT ] [StreamReader.run:62] In StreamReader.run
[Clone API Thread] [ 2020-06-26 16:33:22.463 PDT ] [WindowsSystem.getCRSHome:2110] olrKey = HKEY_LOCAL_MACHINE\Software\Oracle\Olr
[Clone API Thread] [ 2020-06-26 16:33:22.467 PDT ] [WindowsSystem.regKeyExists:1618] WindowsSystem.regKeyExists: mainkey= HKEY_LOCAL_MACHINE subkey = Software\Oracle\Olr
[Clone API Thread] [ 2020-06-26 16:33:22.468 PDT ] [nativesystem.WindowsNative.Native]
Native function: inside RegKeyExists Software\Oracle\Olr HKEY_LOCAL_MACHINE
[Clone API Thread] [ 2020-06-26 16:33:22.468 PDT ] [nativesystem.WindowsNative.Native] InitializeSecurity - successful
[Clone API Thread] [ 2020-06-26 16:33:22.468 PDT ] [nativesystem.WindowsNative.Native] Opening registry key...
[Clone API Thread] [ 2020-06-26 16:33:22.468 PDT ] [nativesystem.WindowsNative.Native] Key 'Software\Oracle\Olr' does not exist
[Clone API Thread] [ 2020-06-26 16:33:22.488 PDT ] [cluster.ClusterCmd.runCmd:-1] srcLoc can't be determined: PRCI-1144 : Failed to retrieve Oracle Grid Infrastructure home path
PRKN-1036 : Windows registry key "HKEY_LOCAL_MACHINE\Software\Oracle\Olr" not found on node "localnode"
I'm not sure what this means or if I'm supposed to add this key to the registry and try again.
I am at the end of day 2 in trying to get this software installed. I plopped down $99 to upgrade to Windows 10 Pro just to be able to install Oracle XE and am quite disappointed with the time and effort required so far.
Any advice, thoughts, comments, or SOLUTIONS are welcome.
Thanks!