Monday, August 29, 2011

An Oracle standard DB install issue with OracleMTSRecoveryService

I got too busy with work, lots things happened that I should post it here. Let me start with a small one.

During Oracle 11g DB (standard version) install, I run into an error, "Error in starting the service. The service OracleMTSRecoveryService was not found".

If I check the service panel, i can see this:

I ignored it a few times. Then I decided to take a closer look and found a work around. here is my solution.
When this error box pops up, keep it there. Fire up regedit go to "computer\hkey_local_machine\system\controlset001\service\OracleMTSRecoveryService". Double click on ImagePath, then change the path to where your Oracle is actually installed.

In my case, the ImagePath has a value of
C:\Oracle\product\11.2.0\dbhome_1\bin\omtsreco.exe "OracleMTSRecoveryService"
I had to change it to:
C:\app\myaccount\product\11.2.0\dbhome_1\bin\omtsreco.exe "OracleMTSRecoveryService"

then click on "retry". that solved my problem.

You may need to look around to see where your DB is actually installed. By defatul, it is installed under "c:\app\yourAcctName".

84 comments:

  1. it not working for me. error that am getting is "Incorrect Function"

    ReplyDelete
  2. Another point: check the values in \HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\OracleMTSRecoveryService node. Pay special attention at the Host key in ..\Protid_0 sub-node. And look at the paths in other keys of this sub-tree.

    ReplyDelete
    Replies
    1. Thank you Oleg and Yuan!

      I needed to edit both registry keys in order to fix my issue.

      Delete
    2. Hi, pls apart from C:\app\myaccount\product\11.2.0\dbhome_1\bin\omtsreco.exe "OracleMTSRecoveryService"

      where else did u edit?

      Delete
    3. HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE\OracleMTSRecoveryService\Protid_0
      "Host"="your_machine_name"

      Delete
  3. Thanks a lot!!!Yuan...you solved my problem..you have described it so simply..thankyou very much!!!

    ReplyDelete
  4. hey Yuan, Thank you for posting this. would be able to share how did you figured it out, and how one can approach such issues. thank you.-Manoj

    ReplyDelete
  5. This was perfect!!
    Thanks a lot.

    -Rama

    ReplyDelete
  6. This was perfect, resolved my issue..thanks!

    ReplyDelete
  7. THANKS A BUNCH!! This did work and resolved my problem! However, I feel this should not be left in the hands of the user to change the registry settings manually to start the service. The installer should be able to locate the exe file from the oracle_home being configured at the beginning of the installation! :(

    -Komal

    ReplyDelete
  8. great.. it worked for me as well

    ReplyDelete
  9. yeah.. I agree Komal, this should be a part of installation itself.

    ReplyDelete
  10. Amigo muchas gracias!! te mandaste! me habia hecho pedazos este software! Abrazos amigo!

    ReplyDelete
  11. thanks a lot....it worked perfectly

    ReplyDelete
  12. Thanks so much for the post, it solved the problem for me.

    ReplyDelete
  13. Hola YUAN me funciona tal cual mi error se soluciono a travez del Regedit.... Durante la instalacion le cambie el Path y continuo con la instalacion de la version 11g version 2

    ReplyDelete
  14. Thanks a lot it worked for me :)

    ReplyDelete
  15. Thank you...worked like a charm.

    ReplyDelete
  16. Thanks a lot it worked, in my i messed up by deleting services manually and re installed oracle many times as i am a beginner, that resolve my problem of TNS listener...

    ReplyDelete
  17. Great help!!!!. You are the man!!!!

    ReplyDelete
  18. Thank you so much , this help me a lot

    ReplyDelete
  19. Great! Thanks for the assist!

    ReplyDelete
  20. Спасибо из России Вы умный человек!!

    ReplyDelete
  21. Many thanks, it's working nicely

    ReplyDelete
  22. keren.. sangat membantu.. from indonesia

    ReplyDelete
  23. This did not work for me. The path in the registry is already pointing to the correct install directory. I do not have any sub nodes in the registry either. I still get this error when installing 11gR2. Any othe fix out there?

    ReplyDelete
    Replies
    1. Steve Same with me, It's still showing the correct path in MTSrecovery Service Image path. Can anyone suggest? I installed the product, by mistake someone removed my folder where I installed it, then I stopped all the servics and deleted all the registry which was in Hkey Local Machine>Services>Ora*
      Another question is that should i remove ODBC too from registry??

      Delete
    2. Same here. I deleted the ODBC folders from the registry though.

      Delete
    3. Try this:-
      HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE\OracleMTSRecoveryService\Protid_0
      "Host"="your_machine_name"

      Delete
  24. thank you so much! this fixed my problem. thanks for posting!

    ReplyDelete
  25. This comment has been removed by the author.

    ReplyDelete
  26. Thaaaaaaaaaaaaaaaaaanks buddy :)

    ReplyDelete
  27. Great!! Thanks for the resolution... :)

    ReplyDelete
  28. Thanks!! Still working in 2016 and Win 2k8.
    For those who think path is right, compare each character of current path and the path in the registry.

    ReplyDelete
  29. Please help me out this error ,,wen im installing oracle 11g i'm not able to completely installed its throws error as "Error in starting service.The service OracleMTSRecoveryService does not exit"

    ReplyDelete
  30. Every thing is set as you said. But still Oracle Installer cant find OracleMTSRecoeryService

    ReplyDelete
  31. It shows the error 'the oracleMTSRecoveryService does not exists' please help me in solving this problem.

    ReplyDelete
  32. Best Way to Solve Oracle Database Startup Problemwith Remote DBA Services
    In the event that you are attempted to startup the Oracle database and got some specialized blunders at that point don't stress, simply attempt these beneath ventures to take care of your concern. To begin with you need to check every one of the organizers in the way as of now exist and furthermore check the consent on record way you are utilizing enable the database to peruse/keep in touch with it. All things considered, if as yet standing up to this issue at that point contact to Database Administration for Oracle or Online Oracle DB Support for fast and dependable help.
    For More Info: https://cognegicsystems.com/
    Contact Number: 1-800-450-8670
    Email Address- info@cognegicsystems.com
    Company’s Address- 507 Copper Square Drive Bethel Connecticut (USA) 06801

    ReplyDelete
  33. How to Solve Oracle Database Starting Issue? Contact to Remote DBA Services
    Shockingly, this issue is mostly looked by a huge number of clients once a day yet absence of good master bolster they can't get right help with respect to Oracle. Yet, with Cognegic's Online Oracle DB Support and Database Administration for Oracle, you can without much of a stretch bring the best and fitting help. Our IT experts can catch thorough perspectives of general Oracle condition, by giving you world-class bolster. On the off chance that you have any issue or question at that point get in touch with us and investigate all issues.
    For More Info: https://cognegicsystems.com/
    Contact Number: 1-800-450-8670
    Email Address- info@cognegicsystems.com
    Company’s Address- 507 Copper Square Drive Bethel Connecticut (USA) 06801

    ReplyDelete