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".
Posted by at
Labels: , ,

90 comments:

  1. AnonymousOctober 10, 2011 at 4:17 PM

    Thank you!!

    ReplyDelete
  2. AltemorNovember 23, 2011 at 6:22 AM

    Thx, it works fine;- )

    ReplyDelete
  3. MorseeDecember 9, 2011 at 12:53 PM

    thx really hope it help me

    ReplyDelete
  4. Moo_RadDecember 22, 2011 at 3:41 AM

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

    ReplyDelete
  5. Oleg_1987March 17, 2012 at 9:14 AM

    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. UnknownJanuary 12, 2016 at 10:03 AM

      Thank you Oleg and Yuan!

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

      Delete
    2. dueretaJuly 8, 2016 at 5:23 AM

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

      where else did u edit?

      Delete
    3. khanbaMarch 23, 2017 at 9:58 PM

      HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE\OracleMTSRecoveryService\Protid_0
      "Host"="your_machine_name"

      Delete
    4. AlexApril 4, 2017 at 1:29 PM

      Thank you kind sir.

      Delete
    5. UnknownFebruary 21, 2019 at 10:15 PM

      my host name is correct but i am still getting the "incorrect function" error. pls help

      Delete
  6. RamalingamMay 29, 2012 at 3:01 AM

    wonderful

    ReplyDelete
  7. BletaJuly 18, 2012 at 12:45 PM

    I love you!

    ReplyDelete
  8. UnknownJuly 23, 2012 at 3:20 AM

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

    ReplyDelete
  9. UnknownAugust 4, 2012 at 12:56 AM

    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
  10. PraneethAugust 6, 2012 at 11:21 AM

    This was perfect!!
    Thanks a lot.

    -Rama

    ReplyDelete
  11. KasireddyAugust 22, 2012 at 7:10 PM

    Very Helpful! Thank you :)

    ReplyDelete
  12. Sindhu KadiyalaAugust 27, 2012 at 12:16 PM

    This was perfect, resolved my issue..thanks!

    ReplyDelete
  13. KomalSeptember 4, 2012 at 11:06 PM

    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
  14. rameshSeptember 27, 2012 at 2:32 PM

    great.. it worked for me as well

    ReplyDelete
  15. rameshSeptember 27, 2012 at 2:35 PM

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

    ReplyDelete
  16. Alejo FergusonOctober 4, 2012 at 3:03 PM

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

    ReplyDelete
  17. Avinash SangleOctober 9, 2012 at 4:48 AM

    thanks a lot....it worked perfectly

    ReplyDelete
  18. gunduNovember 21, 2012 at 2:23 AM

    Thank you, it works perfectly

    ReplyDelete
  19. UnknownNovember 21, 2012 at 6:54 AM

    Thank you men)

    ReplyDelete
  20. debDecember 13, 2012 at 7:16 AM

    Thanx a lot...

    ReplyDelete
  21. Ismail YusufJanuary 13, 2013 at 3:32 AM

    Thanks, You helped me

    ReplyDelete
  22. UnknownMarch 13, 2013 at 2:45 AM

    Thanks...

    ReplyDelete
  23. UnknownMarch 21, 2013 at 8:51 PM

    thanks!

    ReplyDelete
  24. workingclassmediaMay 11, 2013 at 8:21 AM

    You, sir, are a star! Perfect.

    ReplyDelete
  25. CubiclesRCoolJune 4, 2013 at 8:51 PM

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

    ReplyDelete
  26. AdminJune 15, 2013 at 10:12 PM

    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
  27. UnknownJune 25, 2013 at 3:32 AM

    It worked for me. Thank you

    ReplyDelete
  28. PankajJune 26, 2013 at 9:37 PM

    Thanks a lot it worked for me :)

    ReplyDelete
  29. UnknownJuly 16, 2013 at 8:49 AM

    Thanks, this helped......

    ReplyDelete
  30. BuyanaaAugust 1, 2013 at 6:45 PM

    Thank you.

    ReplyDelete
  31. OmahAugust 18, 2013 at 5:33 PM

    Thank you...worked like a charm.

    ReplyDelete
  32. RamAugust 20, 2013 at 3:29 AM

    Thanks... It worked...

    ReplyDelete
  33. Alone In the DarkSeptember 30, 2013 at 12:28 AM

    thanks it works

    ReplyDelete
  34. UnknownNovember 4, 2013 at 1:14 PM

    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
  35. Gaurav Kant GoelNovember 14, 2013 at 9:32 AM

    Thanks.. :)

    ReplyDelete
  36. maheshNovember 22, 2013 at 11:33 PM

    thanks

    ReplyDelete
  37. VincentDecember 6, 2013 at 5:42 AM

    Thanks!!!

    ReplyDelete
  38. UnknownDecember 13, 2013 at 10:14 AM

    :-*

    ReplyDelete
  39. Manu TandonJanuary 3, 2014 at 3:49 AM

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

    ReplyDelete
  40. UnknownJanuary 10, 2014 at 12:52 PM

    thanks it helped...

    ReplyDelete
  41. SivaJanuary 22, 2014 at 11:34 PM

    Great.. Thanks a lot

    ReplyDelete
  42. AnshumanJanuary 30, 2014 at 4:19 AM

    Thanks buddy...

    ReplyDelete
  43. Ahmed Amine GargouraMarch 1, 2014 at 3:04 AM

    good

    ReplyDelete
  44. aunsineMarch 4, 2014 at 12:41 AM

    Thank you so much , this help me a lot

    ReplyDelete
  45. AnonymousMarch 28, 2014 at 8:44 AM

    Great! Thanks for the assist!

    ReplyDelete
  46. UnknownMarch 28, 2014 at 12:31 PM

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

    ReplyDelete
  47. UnknownMay 13, 2014 at 7:28 AM

    THANKS!!!

    ReplyDelete
  48. UnknownMay 14, 2014 at 9:01 AM

    Awesome man. Thanks.

    ReplyDelete
  49. UnknownJune 5, 2014 at 6:49 AM

    You´re the man, thanks

    ReplyDelete
  50. UnknownJuly 10, 2014 at 5:15 PM

    thanksss

    ReplyDelete
  51. Shibaji PaulAugust 24, 2014 at 11:34 PM

    Thanks a lot.

    ReplyDelete
  52. VenkiSeptember 22, 2014 at 8:55 PM

    Resolved...!

    ReplyDelete
  53. UnknownOctober 9, 2014 at 2:17 PM

    THAAAAAAAAAAAAAAAAAAAAANKS ILU

    ReplyDelete
  54. Arun DhamaNovember 6, 2014 at 7:44 PM

    Thanks a lot.

    ReplyDelete
  55. AnonymousJanuary 19, 2015 at 11:38 PM

    Many thanks, it's working nicely

    ReplyDelete
  56. UnknownFebruary 7, 2015 at 7:49 PM

    Thank you so very much.

    ReplyDelete
  57. ardinalMarch 30, 2015 at 9:09 PM

    keren.. sangat membantu.. from indonesia

    ReplyDelete
  58. kuriandunguApril 8, 2015 at 2:55 AM

    Thank you very much

    ReplyDelete
  59. obsa.amboAugust 6, 2015 at 3:29 AM

    Tnxs!!!!!!!!!

    ReplyDelete
  60. UnknownSeptember 3, 2015 at 11:14 AM

    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. Sushant ChaturvediOctober 4, 2015 at 4:34 AM

      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. UnknownOctober 22, 2015 at 10:15 PM

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

      Delete
    3. khanbaMarch 23, 2017 at 9:59 PM

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

      Delete
  61. ASeada Tech TipsNovember 15, 2015 at 3:53 AM

    Many thanks!

    ReplyDelete
  62. UnknownDecember 5, 2015 at 10:25 AM

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

    ReplyDelete
  63. anveshJanuary 4, 2016 at 11:10 PM

    thank u working...

    ReplyDelete
  64. Máté SinkóJanuary 10, 2016 at 3:03 AM

    This comment has been removed by the author.

    ReplyDelete
  65. TariqueMay 19, 2016 at 1:51 AM

    Thaaaaaaaaaaaaaaaaaanks buddy :)

    ReplyDelete
  66. UnknownAugust 9, 2016 at 6:07 AM

    Thank you!!!!!

    ReplyDelete
  67. SmrutiOctober 14, 2016 at 9:13 AM

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

    ReplyDelete
  68. xiohoixNovember 23, 2016 at 11:03 PM

    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
  69. UnknownNovember 28, 2016 at 4:00 AM

    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
  70. evansJanuary 3, 2017 at 1:23 AM

    Good work! keep up

    ReplyDelete
  71. FARAN ASLAMMarch 22, 2017 at 8:52 AM

    Thanx bro..

    ReplyDelete
  72. UnknownJuly 17, 2017 at 12:58 AM

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

    ReplyDelete
  73. UnknownOctober 23, 2017 at 11:20 PM

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

    ReplyDelete
  74. UnknownMay 28, 2018 at 4:10 AM

    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
  75. UnknownJuly 30, 2018 at 7:25 AM

    thanks it worked just fine for me

    ReplyDelete
  76. UnknownOctober 11, 2018 at 3:21 AM

    thank you. it worked. thumbs up

    ReplyDelete
  77. BAL PETEKİMMay 12, 2019 at 6:04 AM

    Thank you bro.

    ReplyDelete
  78. Rahul pawarMay 25, 2019 at 10:21 AM

    Hi,

    I also have correct file name to image path still facing same error any other check please let me know.

    ReplyDelete
  79. Emma ParkerOctober 9, 2019 at 11:45 PM

    Nice Article, Thanks, and it is really nice post.

    Download the MTS Recovery Software to recover your lost video files from your personal computer.

    Thanks a lot...

    ReplyDelete
  80. VenkateshMay 26, 2020 at 7:58 AM

    Hi any one can suggest me, it is showing the correct path only. Even though the same error is facing

    ReplyDelete
  81. varunSeptember 28, 2020 at 11:52 AM

    i m still getting error

    ReplyDelete
  82. karthikMarch 24, 2021 at 11:42 PM

    my image path C:\oraclexe\app\oracle\product\11.2.0\server\bin\omtsreco.exe "OracleMTSRecoveryService" but shown windows could not start OracleMTSRecovery service on loacal computer and also error function please help me wait for valuable reply

    ReplyDelete

Subscribe to: Post Comments (Atom)