Forum Stats

  • 3,815,638 Users
  • 2,259,064 Discussions
  • 7,893,194 Comments

Discussions

Oracle XE 18c installation issue - OracleXEService missing

2»

Answers

  • L. Fernigrini
    L. Fernigrini Data Engineer Sr Consultant Member Posts: 3,801 Silver Crown
    edited Jun 29, 2020 2:11PM

    I have both 18c XE and  a 19c instance installed on my PC, and both of them appear on services:

    pastedImage_0.png

    Since you do not have the service, that is a sign that the installation process went wrong.

    You will need to fix the install process (I do not know how to help with that) and then you should be able to connect with no issues :-).

  • JJJameson
    JJJameson Member Posts: 9 Green Ribbon
    edited Jun 29, 2020 2:39PM

    @!Dude,

    I did not realize that I do not need to be connected.to the database to get into SQL*Plus so thanks for highlighting that.  Still, the way I read the chapter 6 documentation is that I do not have to adjust any user properties or permissions; that Oracle will do that on installation.  When you say I need an account with the right privileges that belongs to the OSDBA system group, are you suggesting that I need to create a new user account and assign it to that group?  The only information I can find on the OSDBA group is specific to linux and AIX systems .  My installations have been done under my Microsoft user account, which is how I login to my machine.  That account is an administrator on my machine.

    In both installation attempts I have right-clicked on the setup.exe file and "Run as administrator."  The post you referred to that mentions a windows patch doesn't provide any specifics on what that patch is.  In upgrading my laptop to Windows 10 Pro prior to the XE installation attempts I did update it to the latest version of Windows 10.  But without any further clarity on which patch and some corroborating evidence that there really is a problem I'm reluctant to start removing patches.

    I see what you mean about the success banner referencing localhost, but no localhost being referenced in the listener.  However I'm not sure what action to take with regard to that, if any.  My belief is that the reason my database isn't running is because the OracleXEService does not exist.  Does that sound right?

    I will attempt another uninstall/install cycle as soon as I can dedicate some time to it.  If there's anything you think I should change prior to the next install please spell out your recommended changes for me clearly so that I can implement them precisely and correctly.  I appreciate your input.

    Thanks again.

  • JJJameson
    JJJameson Member Posts: 9 Green Ribbon
    edited Jun 29, 2020 2:42PM

    @ L. Fernigrini, as I just indicated to @Dude! I will be attempting another install as soon as I get some time to dedicate to it.  I believe this whole thing comes down to a bad installation.  Thanks for your input.

  • JJJameson
    JJJameson Member Posts: 9 Green Ribbon
    edited Jun 29, 2020 6:41PM Answer ✓

    @Dude!, @L. Fernigrini, and anyone else who's been watching this post (or who might come across it with a similar issue in the future),

    After a couple more unsuccessful attempts to install Oracle XE I thought as a last-ditch effort I would try replacing the installation source file (OracleXE184_Win64.zip).  I deleted the one I had downloaded last Friday, which I'd been using over and over, and downloaded a new one, this time using the new version of Microsoft Edge instead of Firefox, which I had used for the original download.  The subsequent installation took a lot longer than all previous tries (in excess of 20 minutes), and when it was done, I had six Oracle services instead of just the two I'd had before:

    Oracle Services.PNG

    I'm able to logon to SQL*Plus without a problem now and at this point am positioned to proceed with my original project.

    I did verify the original file (and the second one) against the sha256sum provided by Oracle, and both matched their key value.  So...it's hard to say exactly what went wrong, but apparently there was something amiss in the original file.  At any rate I'm considering this complete.

    Thanks for all your help - I truly appreciate that you would choose to spend you valuable time to help me.

  • L. Fernigrini
    L. Fernigrini Data Engineer Sr Consultant Member Posts: 3,801 Silver Crown
    edited Jun 29, 2020 7:14PM

    Glad to know that the issue is fixed! It is really strange, since the sha256 checksum matched.... but you never know!

    JJJameson
  • Dude!
    Dude! Member Posts: 22,828 Black Diamond
    edited Jun 29, 2020 7:38PM
    I did verify the original file (and the second one) against the sha256sum provided by Oracle, and both matched their key value.  So...it's hard to say exactly what went wrong, but apparently there was something amiss in the original file. 

    How can there possibly be something wrong when the checksum matches? If you also installed it the same way.... I guess it's mission impossible to find two identical MS Windows installations.

    JJJameson
  • user603182
    user603182 Member Posts: 12 Blue Ribbon

    I know it's an old post, but I have exactly the same issue: OracleXEService is missing and never get installed, even if installation seems OK. It was all working untill I uninstalled it to change installation directory (hard disk space was limited): only recovery service and listener service get installed. It's about 2 days of frustrating tries, but without success. It seems that the uninstaller does not uninstall all required entries. How can I solve this issue?

  • User_H93H2
    User_H93H2 Member Posts: 1 Green Ribbon

    @user603182 I think this is something @oracle needs to look into and fix this as many of us are facing the same issue with this version. #Oracle please provide some insight on how to fix this issue.

  • JJJameson
    JJJameson Member Posts: 9 Green Ribbon

    @user603182, based on my experience, if you don't have all the services installed after your installation, you don't have a good installation, even if it seemed to complete without errors. In my case there was apparently something wrong with the zip file, even though it appeared sound. I used a different browser to download a new copy of the file. Using the new zip file I got a good installation and from that point forward didn't have any issues. Oracle did seem to leave bits and pieces of itself on my system after uninstalling, but I don't think that was really the problem, because even after cleaning them up manually I had the same problem until I got a good zip file.

  • user603182
    user603182 Member Posts: 12 Blue Ribbon

    I came across a solution, following Manish Sharma video on https://www.youtube.com/watch?v=V4mOL5o_o68

    , but adding 2 point (without them it did not work for me). This is what I did:

    1) Uninstall Oracle 18c Express (Control Panel > Programs > Programs and Features > Press and hold (or right-click) on Oracle 18c Express app)

    2) Remove all Oracle 18c environment variables: Right-click on My Computer > Properties > Go to the Advanced system settings tab > Click the Environment Variables button. The Environment Variables dialog opens. Click on System variables > Path and delete the Oracle installation path , that you choose when you installed Oracle 18c Express, from the list (example c:\app\yourname\Oracle\...)

    3) Open windows registry (In the search box on the taskbar, type regedit, then select Registry Editor (Desktop app) from the results):

    From HKEY_LOCAL_MACHINE->System->CurrentControlSet->Services remove all entries starting with Oracle string

    From HKEY_LOCAL_MACHINE->Software remove Oracle folder (be carefull if you have other oracle product installed)

    Now ,in windows registry, click to "Computer" and search and remove all entries starting with ORADB18 (it requires a lot of time; this point was not suggested in the video above). If you find that all entries in the same node are related to ORADB18, delete the node itself (BE CAREFUL, at your own risk)

    4) Delete Oracle User/Groups: Press Windows + R, type lusrmgr.msc, press ENTER. If you have Windows 10 Home, lusrmgr app is limited. You have to download a file from the web, googling "lusrmgr windows 10 home". From the "Users" entry, delete the user you created when installing Oracle 18c (in express edition I did not find any new user created anyway). Now click on "Groups" entries and delete all groups starting with "ORA". Close lusrmgr.

    5) delete Oracle 18c installation folder you choose when installed ((example c:\app\yourname\Oracle\...)

    6) delete Oracle folder from c:\Program Files (be careful if you have other oracle products installed)

    7) Delete "Oracle - OraDB18Home1"folder from start groups from file explorer, typing

    %ProgramData%\Microsoft\Windows\Start Menu\Programs\

    8) RESTART the system

    9) clean registry with a registry cleaner software (I used ccleaner, free)

    10) RESTART the system and reinstall Oracle 18c express