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".

82 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. Спасибо из России Вы умный человек!!

    ReplyDelete
  20. keren.. sangat membantu.. from indonesia

    ReplyDelete
  21. 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
  22. thank you so much! this fixed my problem. thanks for posting!

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

    ReplyDelete
  24. Thaaaaaaaaaaaaaaaaaanks buddy :)

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

    ReplyDelete
  26. 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
  27. 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
  28. Every thing is set as you said. But still Oracle Installer cant find OracleMTSRecoeryService

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

    ReplyDelete