Showing posts with label Oracle. Show all posts
Showing posts with label Oracle. Show all posts

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