2 Installing and Migrating Oracle Products

Deleting an Oracle Service for MTS with Oracle Manager for MTS Services

You must use Oracle Manager for MTS Services snap-in in the Microsoft Management Console Explorer to delete the Oracle Service for MTS. Deleting the Oracle Service for MTS in any other way (such as with the Delete button on the keyboard) causes data inconsistencies in the database. These inconsistencies require the database administrator to manually commit or terminate transactions that did not successfully complete or recover. Before deleting the Oracle Service for MTS, ensure that all transactions are resolved by performing the following tasks.

• Task 1: Stopping the Oracle Service for MTS

• Task 2: Stopping and Restart the Database

• Task 3: Restarting the Oracle Service for MTS

• Task 4: Monitoring the Oracle Service for MTS Trace Files

• Task 5: Deleting Oracle Service for MTS Table Information

• Task 6: Deleting the Oracle Service for MTS

Deleting Roles and Privileges of an Inactive Oracle Service for MTS User

Ensure that you delete the roles and privileges assigned to an Oracle Service for MTS user that you no longer use or whose service you have deleted.

To delete roles and privileges of an inactive Oracle Service for MTS user:

1. Go to ORACLE_BASE\ORACLE_HOME\oramts\admin.

2. Open the file revokeuser.sql with a text editor.

3. Replace mts_user with the username from which to revoke roles and privileges.

   
   

   Note: This script uses the username mtssys and the password mtssys. If you have changed the password or are using an Oracle Service for MTS username other than mtssys, you must substitute the correct username and password.

   
   

4. Save the changes and exit revokeuser.sql.

5. Start SQL*Plus:

   C:\> sqlplus /NOLOG
   
   

6. Connect to the database as SYSDBA:

   SQL> CONNECT / AS SYSDBA
   
   

7. Run the modified script:

   SQL> @ORACLE_BASE\ORACLE_HOME\oramts\admin\revokeuser.sql;
   
   

   The roles and privileges for the user are deleted.

8. Exit SQL*Plus:

   SQL> EXIT
   

   
   

   See Also: Oracle Database Installation Guide for Windows for instructions on installing the latest Oracle Services For Microsoft Transaction Server release

   
   

Task 1: Manually Deleting Oracle Service for MTS with the Registry

To manually delete Oracle Service for MTS with the registry:

1. Start the registry from the command prompt:

   C:\> regedt32
   
   

   The Registry Editor window appears.

2. Select the HKEY_LOCAL_MACHINE.

   Go to System\CurrentControlSet\Services\OracleMTSServicen.

   where n is the number of the Oracle Service for MTS.

   The right-hand side of the window shows various parameters and values associated with OracleMTSServicen, including those listed in the following table:

   Parameter	This Parameter Contains...
   ORAMTS_SUNAME	The Oracle Service for MTS username.
   ORAMTS_SUPWD	The password for the Oracle Service for MTS username (encrypted in the registry).
   ORAMTS_OCI_OBJ_MODE	Initializes OCI in object mode or threaded mode
   ORAMTS_ORADB	The net service name for the Oracle Service for MTS to use in connecting to the Oracle database.

   
   

3. Start SQL*Plus:

   C:\> sqlplus /NOLOG
   
   

4. Connect to the Oracle database with the same username and net service name with which the Oracle Service for MTS connects:

   CONNECT as username/password@net_service_name
   
   

   where net_service_name is the net service name for connecting to the database. The password is stored in the registry in encrypted form. Use plain text passwords when connecting with SQL*Plus.

5. Verify that the Oracle database is the same one to which the Oracle Service for MTS connects by checking the following database information:

   SQL> SELECT NAME, DBID FROM V$DATABASE; 
   
   

   which displays information similar to the following:

   NAME      DBID 
       --------------------- 
       ORCL      12345678 
   
   

6. Check that these values match the registry values ORAMTS_DBNAME (ORCL in this example) and ORAMTS_DBID (12345678 in this example).

7. Check the service information:

   SQL> SELECT rmguid FROM mts_proxy_info; 
   
   

   which displays information similar to the following:

   RMGUID 
   ------------------------- 
   2320b23e93e09fff02a231974 
   
   

8. Check that this information matches the registry value ORAMTS_RMGUID.

9. Proceed only if all values match.

   If all values do not match, the Oracle database is not the same one to which the Oracle Service for MTS connects. If you continue, Oracle Service for MTS installation on the database fails. This can leave the database in an inconsistent state that requires database administrator intervention to correct. Because of mismatched tnsnames.ora files, SQL*Plus and Oracle Service for MTS did not connect to the same database.

10. Delete the service information stored in the database:

    SQL> DELETE FROM mts_proxy_info; 
    SQL> COMMIT; 
    
    

11. Exit from SQL*Plus.

    SQL> EXIT
    

Task 2: Deleting the OracleMTSServicen Service

To delete the OracleMTSServicen service:

1. Restart the computer.

2. Click Start > Programs > Oracle - HOME_NAME > Application Development > Oracle Manager for Microsoft Transaction Server.

   The Microsoft Management Console appears.

3. Find the Oracle Service for MTS to delete in the Explorer window.

4. Right-click Oracle Service for MTS.

   A menu appears with several options.

5. Click Delete.

   If successful, a message indicates that the Oracle Service for MTS was deleted.

6. If unsuccessful, a message indicates that the Oracle Service for MTS was not deleted. In this case, use the registry to delete the service's registry entry. In the HKEY_LOCAL_MACHINE, delete the following key:

   \System\CurrentControlSet\Services\OracleMTSServicen.

   where n is the number of the Oracle Service for MTS.

7. Go to "Deleting Roles and Privileges of an Inactive Oracle Service for MTS User".