Oracle MTSRecovery Service not found Issue

Oracle MTSRecovery Service not found Issue



I was installing an Oracle 11g database for one of the client in the server , and came out of this error ,

which said OracleMTSRecoveryServicewas not found. 



Initially got confused , later understood that there is an Oracle software already installed in the same server and I was trying to install that again , due to which we encountered this error ,

Initial investigations ,

1. Try retry and check once , if did not work ,

2, Check for the location of old software installation , and New software installation both and check if omtsreco.exe file is present or not.

3. Once after that , go and check the registry , here is the main challenge

Now install the oracle. If you already installed the oracle once. It should taken some path like below.
In my system it took "E:\app\product\11.2.0\dbhome_1..."
If you are installing second time installation will take path, "E:\app\product\11.2.0\dbhome_2..."
Now the above erorr will come because of registry. So, now yo need to edit the registry value like below.
  • ctrl+R will bring the run window. Type regedit and press ok
  • Then Under Computer, select HKEY_LOCAL_MACHINE -> SYSTEM ->ControlSet001-> Services -> OracleMTSRecoveryService.
  • Double click on ImagePath. It will prompt a window with old path or with wrong path under value data.
  • Now, you need to edit it with your curent path like below.
  • E:\app\INDP\product\11.2.0\dbhome_2\bin\omtsreco.exe OracleMTSRecoveryService 

Now press "retry" button of the window, which shown that error. Now, it will work like charm.

Comments

Post a Comment

Popular posts from this blog

Space_Count **   select user_bytes/1024/1024 from dba_data_files         where tablespace_name='<tbs_name>'; ** select sum(user_bytes)/1024/1024 from dba_data_files       where tablespace_name='<tbs_name>';            This will give us the space used in a particular datafile..... Tablespace_Size ** select bytes/1024/1024 from dba_data_files       where tablespace_name='<tbs_name>'; ** select sum(bytes)/1024/1024 from dba_data_files       where tablespace_name='<tbs_name>';             This command will give the tablespace size what size is the tablespace created of..
Read more
Index Re-building.. ALTER INDEX <IDX_NAME> REBUILD ONLINE; If your issue is its huge table and it might take more time to execute then you can use Parallel execution method. 1. Take your session in Parallel DML mode. ALTER SESSION ENABLE PARALLEL DML; 2. Take your table in Parallel Mode ALTER TABLE <TABLE_NAME> PARALLEL; 3. Run Rebuild Index command. ALTER INDEX <IDX_NAME> REBUILD ONLINE; 4.  Take your session back to normal mode. ALTER SESSION DISABLE PARALLEL DML; That is it !!!
Read more
Renaming Database Well Rename your database in a very easy way..without affecting the DBID or to the SID... Step 1 :  Backup Controlfile to text Step 2:  Create  a pfile of your database Step 3:  Edit your controlfile with database name...keeping only resetlogs Step 4:  Edit pfile with dbname and controlfile parameter.. Step 5:  Startup with nomount option with the updated pfile.. Step 6:  Create a new controlfile Step 7:  Update the new controlfile in pfile and Startup with that pfile Step 8:  Create a new Spfile from the updated Pfile....               Thats it Database is renamed.......... Sql > alter database backup controlfile to trace as '/home/oracle/control.txt [ oracle@localhost :~ ]  vi control.txt CREATE CONTROLFILE REUSE DATABASE "ORACLE" RESETLOGS  ARCHIVELOG     MAXLOGFILES 16     MAXLOGMEMBERS 3     MAXDATAFILES 100 ...
Read more