B
Deleting or Modifying an Existing Oracle Service for MTS

This appendix describes how to delete or modify an existing Oracle Service for MTS.

Specific topics discussed are:

• How Do I Modify or Delete an Oracle Service for MTS?
• Preparing to Modify or Delete an Existing Oracle Service for MTS
• Deleting an Existing Oracle Service for MTS
• Modifying Oracle Service for MTS Connection Information
• Modifying Oracle Service for MTS Trace File and MS DTC Information
• Manually Deleting or Modifying the Oracle Service for MTS with the Registry
• Deleting Roles and Privileges of an Inactive Oracle Service for MTS User

How Do I Modify or Delete an Oracle Service for MTS?

You cannot modify an existing Oracle Service for MTS to connect to a different Oracle8i database. The Oracle8i database for which the Oracle Service for MTS was originally created must always remain the same. Instead, delete the existing Oracle Service for MTS and create a new one for the second Oracle8i database. If necessary, however, you can modify the database alias, Oracle home, user name, and password of an existing Oracle Service for MTS as long as the Oracle8i database remains the same. The table below describes the procedures to follow for deleting or modifying an existing Oracle Service for MTS:

On The...	What Procedures Must You Perform if You Want to...
	Delete the Oracle Service for MTS?	Modify the Oracle Service for MTS?
Client computer	None.	None.
Windows NT computer where Microsoft Transaction Server is installed	To delete an existing Oracle Service for MTS, see sections:  "Preparing to Modify or Delete an Existing Oracle Service for MTS"  "Deleting an Existing Oracle Service for MTS"  "Deleting Roles and Privileges of an Inactive Oracle Service for MTS User"  If Oracle Service for MTS deletion is unsuccessful, see section:  "Manually Deleting or Modifying the Oracle Service for MTS with the Registry"	To modify an existing Oracle Service for MTS, see sections:  "Preparing to Modify or Delete an Existing Oracle Service for MTS"  Then see the appropriate section:  "Modifying Oracle Service for MTS Connection Information"  "Modifying Oracle Service for MTS Trace File and MS DTC Information"  If Oracle Service for MTS modification is unsuccessful, see section:  "Manually Deleting or Modifying the Oracle Service for MTS with the Registry"
Computer where the Oracle8i database is installed	None.	None.

 

Preparing to Modify or Delete an Existing Oracle Service for MTS

Modifying a currently operating Oracle Service for MTS to connect to a different MS DTC; modifying the Net8 connection, Oracle home name, user name, or password; or deleting an Oracle Service for MTS may require the DBA to manually commit or abort transactions that did not successfully complete and/or recover.

For this reason, you must prepare the Oracle Service for MTS before it can be deleted or modified to access a different MS DTC or use different connection information. Follow these procedures to ensure that:

• all transactions are completed before deleting or modifying the Oracle Service for MTS
• no manual transaction commits or aborts are required

To prepare to modify or delete an existing Oracle Service for MTS:

1. Go to the computer from which to modify the Oracle Service for MTS. The Oracle Service for MTS can be running on this computer or on a remote computer that you can access from this computer.

2. Choose 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 modify in the Explorer window.

 
4. Right-click the Oracle Service for MTS icon to modify (MTSDEMO in this example):

 

A menu appears with several options.

5. Choose Stop Service.

A message indicates that the Oracle Service for MTS has stopped.

6. Click OK.

 
7. Go to the computer on which the Oracle8i database is running.

 
8. Start SQL*Plus:

C:\> SQLPLUS

9. Connect with the INTERNAL user name:

ENTER USER-NAME: INTERNAL

10. Shut down the Oracle8i database:

SQL> SHUTDOWN

11. Restart the Oracle8i database:

SQL> STARTUP

12. Exit SQL*Plus:

SQL> EXIT

13. Return to the computer on which to start the Oracle Service for MTS.

 
14. Choose Start > Programs > Oracle - HOME_NAME > Application Development > Oracle Manager for Microsoft Transaction Server.

The Microsoft Management Console appears.

15. Find the Oracle Service for MTS to start in the Explorer window.

 
16. Right-click the Oracle Service for MTS icon.

A menu appears with several options.

17. Choose Start Service.

A message indicates that the Oracle Service for MTS has started.

18. Click OK.

 
19. Do not allow any new transactions to use the Oracle Service for MTS.

 
20. Monitor the Oracle Service for MTS trace file for a message indicating that recovery has completed successfully. This file is located in ORACLE_BASE\ ORACLE_HOME\ORAMTS\TRACE.

 
21. Right-click the Oracle Service for MTS icon.

 
22. Choose Stop Service.

A message indicates that the Oracle Service for MTS has stopped.

23. Click OK.

 
24. Go to the computer on which the Oracle8i database is running.

 
25. Start SQL*Plus:

C:\> SQLPLUS

26. Connect with the INTERNAL user name:

ENTER USER-NAME: INTERNAL

27. Delete this information from the following table:

SQL> DELETE FROM MTS_PROXY_INFO;
SQL> COMMIT;

Deleting an Existing Oracle Service for MTS

This section describes how to delete an existing Oracle Service for MTS. You must use 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 your keyboard's Delete button) can cause data inconsistencies in the Oracle8i database. These inconsistencies require the DBA to manually commit or abort transactions that did not successfully complete and/or recover.

To delete an existing Oracle Service for MTS:

1. Follow the procedures described in section "Preparing to Modify or Delete an Existing Oracle Service for MTS" to ensure that all transactions are resolved before deleting an existing Oracle Service for MTS.

2. Go to the computer from which to delete the Oracle Service for MTS. The Oracle Service for MTS can be running on this computer or on a remote computer that you can access from this computer.

 
3. Choose Start > Programs > Oracle - HOME_NAME > Application Development > Oracle Manager for Microsoft Transaction Server.

The Microsoft Management Console appears.

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

 
5. Right-click the Oracle Service for MTS icon.

A menu appears with several options.
 

6. Choose Stop Service.

A message indicates that the Oracle Service for MTS has stopped.

7. Click OK.

 
8. Right-click the same Oracle Service for MTS again.

A menu appears with several options.

9. Choose Delete.

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

If unsuccessful, a message indicates that the Oracle Service for MTS has not been deleted. See section "Manually Deleting or Modifying the Oracle Service for MTS with the Registry". After completing those procedures, retry steps 8 and 9 above.

Modifying Oracle Service for MTS Connection Information

The Oracle Service for MTS includes a Database tab in the Properties dialog box that enables you to modify the Net8 network connection, Oracle home, user name, and password of an existing Oracle Service for MTS.

To modify Oracle Service for MTS connection information:

1. Follow the procedures described in section "Preparing to Modify or Delete an Existing Oracle Service for MTS" to ensure that all transactions are resolved before modifying an existing Oracle Service for MTS.

2. Go to the computer from which to modify the Oracle Service for MTS. The Oracle Service for MTS can be running on this computer or on a remote computer that you can access from this computer.
3. Choose Start > Programs > Oracle - HOME_NAME > Application Development > Oracle Manager for Microsoft Transaction Server.

The Microsoft Management Console appears.

4. Find the Oracle Service for MTS to modify in the Explorer window.

 
5. Right-click the Oracle Service for MTS icon to modify.

A menu appears with several options.
 

6. Choose Stop Service.

A message indicates that the Oracle Service for MTS has stopped.

7. Right-click the same Oracle Service for MTS icon again.

A menu appears with several options.

8. Choose Properties.

The Properties dialog box appears.

9. Click the Database tab.

The Database tab of the Properties dialog box displays the following information:
 

10. Modify the following information, as appropriate:

 

Attention:  The user name, password, database alias, and Oracle home that you specify must still connect to the same Oracle8i database for which the Oracle Service for MTS was originally created.

   


Field	Displays the...
User Name	Oracle Service for MTS user name. This user name is either MTSSYS, a custom name you manually created, or no name (if using operating system authentication).
Password	Password for the Oracle Service for MTS user name (or none if using operating system authentication).
Connect As	Privilege with which the service connects to the Oracle8i database (NORMAL, SYSOPER, or SYSDBA).
Database Alias	Net8 network connection (net service name) to the Oracle8i database. Changing the Net8 network connection causes the display name of the service to change. For example, if the Oracle home directory was C:\ORACLE\ORA81 (home name ORA81) and the Net8 network connection was changed from FINAPS_TEST.WORLD to FINAPS_PROD.WORLD, then the display name changes from FINAPS_TEST.WORLD(ORA81) to FINAPS_PROD.WORLD(ORA81).
Oracle Home	Oracle home directory for this service. Changing the Oracle home directory for a service causes the service's display name to change. For example, if the Net8 network connection for the service is FINAPS.WORLD and the home directory was changed from C:\ORANT81_TEST (home name ORANT81TST) to C:\ORANT81_PROD (home name ORANT81PRD), then the display name changes from FINAPS.WORLD(ORANT81TST) to FINAPS.WORLD(ORANT81PRD).

 
11. Click OK.

If successful, the Oracle Service for MTS can now connect to the Oracle8i database with the information specified in step 10.

If not successful, the Oracle Service for MTS is unable to connect to the Oracle8i database with the information specified in step 10. See section "Manually Deleting or Modifying the Oracle Service for MTS with the Registry". After completing those procedures, retry steps 7 through 11 above.

Modifying Oracle Service for MTS Trace File and MS DTC Information

The Oracle Service for MTS includes an Advanced tab in the Properties dialog box that enables you to modify the following information:

• trace file name and level of trace detail
• MS DTC location

To modify trace file and MS DTC information:

1. Follow the procedures described in section "Preparing to Modify or Delete an Existing Oracle Service for MTS" to ensure that all transactions are resolved before modifying an existing Oracle Service for MTS.

2. Go to the computer from which to modify the Oracle Service for MTS. The Oracle Service for MTS can be running on this computer or on a remote computer that you can access from this computer.

 
3. Choose Start > Programs > Oracle - HOME_NAME > Application Development > Oracle Manager for Microsoft Transaction Server.

The Microsoft Management Console appears.

4. Find the Oracle Service for MTS to modify in the Explorer window.

 
5. Right-click the Oracle Service for MTS icon to modify (MTSDEMO in this example):

A menu appears with several options.
 

6. Choose Properties.

The Properties dialog box appears.

7. Click the Advanced tab.

The Advanced tab of the Properties dialog box displays the following information:

8. Make appropriate changes.



Field	Displays the...
DTC Host	Hostname of the computer on which MS DTC is running. You can change this value. If this field is blank, the Oracle Service for MTS uses the local computer's MS DTC. Exercise care when altering this setting. Recovery of any in-doubt transactions in the database is impossible once the MS DTC to which the service connects is changed. Ensure that all in-doubt transactions are resolved before changing the MS DTC to which the service connects.
Trace Level	Level of detail for trace recording. The range of values are NOTRACE (for no tracing), LEVEL1, LEVEL2, LEVEL3, and LEVEL4 (for highest tracing). The information provided includes:  Any errors  Enlistment requests and outcomes  Prepare, commit, and abort requests and outcomes  LEVEL1 only records errors in the trace file. If no errors occur, no information is written to the trace file and Oracle Service for MTS performance is not impacted. LEVEL2 (the default setting) records both errors and minimal transaction information. This means that Oracle Service for MTS performance can be impacted, particulary in a high traffic environment. Test Oracle Service for MTS performance in your Oracle8i database environment to determine the proper trace level. Resetting the trace level to LEVEL1 is typically sufficient for most Oracle8i database environments. Note: The higher you set the trace level, the more Oracle Service for MTS performance is impacted. See section "Using Trace Files" for additional information on trace settings.
Trace Filename	Trace file name. If a directory path is not provided, the file is created in ORACLE_BASE\ORACLE_HOME\ORAMTS\TRACE.

 
9. Click OK.

Manually Deleting or Modifying the Oracle Service for MTS with the Registry

Before the Oracle Service for MTS can be deleted or modified to connect to a different Oracle8i database, it must be cleanly disassociated from the Oracle8i database to which it has been connecting. Sometimes this disassociation fails. Follow the instructions in this section only if the following procedures were unsuccessful:

• deletion procedures in section "Deleting an Existing Oracle Service for MTS"
• modification procedures in section "Modifying Oracle Service for MTS Connection Information"

The Microsoft Management Console Explorer can fail to delete or modify the Oracle Service for MTS if any of the following occur:

Issue	Solution
The Explorer cannot connect to the Oracle8i database using the information in the registry.	Ensure that the Oracle8i database and its listener are started. Use SQL*Plus or a different tool to verify that the Oracle8i database accepts new connections.
The information in the Oracle8i database does not match the information in the registry.	The Explorer is connecting to a different Oracle8i database than the one to which the Oracle Service for MTS connects. If the Explorer and the Oracle Service for MTS run on the same computer, they may be using TNSNAMES.ORA files from different Oracle homes. If they run on different computers (for example, the Explorer is configuring a service on a remote computer), the entry in the TNSNAMES.ORA file that they use points to different databases. Whether it is a local or remote problem, resolve it by ensuring that the entry in the TNSNAMES.ORA file for both the Explorer and the Oracle Service for MTS points to the same database instance.
The Explorer cannot delete the service information stored in the Oracle8i database.	The Oracle8i database is unstable or is not working properly. Check if any database trace files are being created that indicate a database process crash.

 

To manually delete or modify Oracle Service for MTS with the registry:

1. Start the registry from the MS-DOS command prompt:

C:\> REGEDT32

The Registry Editor window appears.

2. Navigate to HKEY_LOCAL_MACHINE\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 the following:

Parameter	This Parameter Contains the...
ORAMTS_SUNAME	Oracle Service for MTS user name.
ORAMTS_SUPWD	Password for the above account (encrypted in the registry). Do not change the password in the registry. You can only change the password from within the Database tab of the Oracle Service for MTS Properties dialog box in the Oracle Manager for MTS Services snap-in. See section "Modifying Oracle Service for MTS Connection Information" for instructions.
ORAMTS_ORADB	Database alias for connecting with the Oracle Service for MTS to the Oracle8i database.

   

3. Start SQL*Plus:

C:\> SQLPLUS

4. Connect to the Oracle8i database with the same user name and Net8 network connection with which the Oracle Service for MTS connects:

ENTER USER-NAME: USERNAME/PASSWORD@NET_SERVICE_NAME

where NET_SERVICE_NAME is the database alias. The password is stored in the registry in encrypted form. Use plain text passwords when connecting with SQL*Plus.

5. Verify that the Oracle8i 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 (for ORCL) and ORAMTS_DBID (for 12345678).

 
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 not all values match, the Oracle8i 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 breaks. This can leave the database in an inconsistent state that requires DBA intervention to correct. The reason SQL*Plus connected to a different database than the Oracle Service for MTS is mismatching TNSNAMES.ORA files.

10. Delete the service information stored in the database.

SQL> DELETE FROM MTS_PROXY_INFO; 
SQL> COMMIT;

11. Exit from SQL*Plus.

SQL> EXIT

12. Delete the OracleMTSServicen service.

 
13. Reboot your computer.

 
14. Return to your previous section:



If You Were...	Return to...
Deleting Oracle Service for MTS	Steps 8 and 9 of section "Deleting an Existing Oracle Service for MTS".
Modifying Oracle Service for MTS to access a different Oracle8i database	Steps 7 through 11 of section "Modifying Oracle Service for MTS Connection Information".

   

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 want to use.

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

1. Go to ORACLE_BASE\ORACLE_HOME\ORAMTS\ADMIN.

2. Open the file REVOKEUSER.SQL with an ASCII editor.

 
3. Replace MTS_USER with the user name from which to revoke roles and privileges.

 

Note:  This script uses the user name MTSSYS and the password MTSSYS. If you have changed the password or are using an Oracle Service for MTS user name other than MTSSYS, you need to substitute the correct user name and password.

 
4. Start SQL*Plus:

C:\> SQLPLUS

5. Connect with the INTERNAL user name:

ENTER USER-NAME: INTERNAL

6. Run the modified script:

SQL> @ORACLE_BASE\ORACLE_HOME\ORAMTS\ADMIN\REVOKEUSER.SQL;

7. Exit SQL*Plus:

SQL> EXIT

---