A
Manually Creating Oracle Service for MTS Users

This appendix describes how to manually create the MTSSYS user, a custom user, or an operating system-authenticated user on Windows NT.

Specific topics discussed are:

• Manually Creating the MTSSYS User

• Manually Creating a Custom Oracle Service for MTS User

• Creating a New Operating System-Authenticated Oracle Service for MTS

• Enabling an Existing Oracle Service for MTS to be Operating System-Authenticated

Manually Creating the MTSSYS User

This section describes how to manually create the MTSSYS user (if it is not included in your Oracle8 database) and execute the scripts that enable you to run the sample application demo described in section "Using OCI with the Microsoft Application Demo". See section "Verifying the Oracle Service for MTS User Name" to determine if your Oracle8 database includes this user.

To manually create an MTSSYS user:

1. Log on to the computer where your Oracle8 database is installed.

2. Start SQL*Plus:

   C:\> SQLPLUS
   

3. Connect with the INTERNAL user name:

   ENTER USER-NAME: INTERNAL
   

4. If you want to use the Microsoft application demo described in section "Using OCI with the Microsoft Application Demo", go to step 4a. Otherwise, go to step 5.
   1. Verify that you can connect with the SCOTT user name.

      SQL> CONNECT SCOTT/PASSWORD
      

      where PASSWORD is TIGER after installation, unless you changed it.

   2. Follow the steps below based on whether or not you connected to the Oracle8 database:

      If You...	Then...
      Connected as user SCOTT	Go to step 5.
      Did not connect as user SCOTT	Go to step 4c.

   3. Run the following script:

      SQL> @ORACLE_BASE\ORACLE_HOME\RDBMS\ADMIN\SCOTT.SQL;
      

      This creates the user SCOTT, which is used by the sample application demo.

   4. Go to step 5.

5. Run the ORAMTS.SQL script:

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

   Note: Oracle database release 8.0.6 does not include the ORAMTS.SQL script. You must obtain this script from Oracle database release 8.1.x.

   This creates the user MTSSYS and two tables (ACCOUNT and RECEIPT) under user SCOTT that are used by the Microsoft application demo.

   Note: If your Oracle8 database did not include user SCOTT and you did not run SCOTT.SQL, error messages appear when running ORAMTS.SQL. Ignore these messages. The product functions properly, but the sample application demo will not work.

6. Connect with the MTSSYS user name and MTSSYS password:

   SQL> CONNECT MTSSYS/MTSSYS
   

7. Change the password for the MTSSYS user:

   SQL> ALTER USER MTSSYS IDENTIFIED BY NEW_PASSWORD
   

   This changes your MTSSYS user password.

8. Exit SQL*Plus:

   SQL> EXIT
   

9. Follow the procedures in section "Creating a New Oracle Service for MTS" to create an Oracle Service for MTS user. When you get to step 10, enter the MTSSYS user name and password in the Service Information dialog box:

   
   

10. Complete the remaining procedures (steps 11 through 13) in section "Creating a New Oracle Service for MTS".

    When complete, this creates an MTSSYS user for the Oracle Service for MTS.

Manually Creating a Custom Oracle Service for MTS User

This section describes how to manually create a custom Oracle Service for MTS user (if you do not want to use the user MTSSYS) and execute the scripts that enable you to run the Microsoft application demo described in section "Using OCI with the Microsoft Application Demo".

To manually create a custom user:

1. Go to the computer where your Oracle8 database is installed.

2. Start SQL*Plus:

   C:\> SQLPLUS
   

3. Connect with the INTERNAL user name:

   ENTER USER-NAME: INTERNAL
   

4. If you want to use the Microsoft application demo described in section "Using OCI with the Microsoft Application Demo", go to step 4a. Otherwise, go to step 5.
   1. Verify that you can connect with the SCOTT user name.

      SQL> CONNECT SCOTT/PASSWORD
      

      where PASSWORD is TIGER after installation, unless you changed it.

   2. Follow the steps below based on whether or not you connected to the Oracle8 database:

      If You...	Then...
      Connected as user SCOTT	Go to step 5.
      Did not connect as user SCOTT	Go to step 4c.

   3. Run the following script:

      SQL> @ORACLE_BASE\ORACLE_HOME\RDBMS\ADMIN\SCOTT.SQL;
      

      This creates the user SCOTT, which is used by the sample application demo.

   4. Go to step 5.

5. Verify that you can connect with the MTSSYS user name:

   SQL> CONNECT MTSSYS/PASSWORD
   

   where PASSWORD is MTSSYS after installation, unless you changed it. The MTSSYS user name is required to run the script that enables you to create a custom Oracle Service for MTS user.

6. Follow the steps below based on whether or not you connected to the Oracle8 database:

   If You...	Then...
   Connected as user MTSSYS	Go to step 7.
   Did not connect as user MTSSYS	Go to step 6a.

   1. Run the ORAMTS.SQL script:

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

      This creates the user MTSSYS and two tables (ACCOUNT and RECEIPT) under user SCOTT that are used by the Microsoft application demo.

      Note: If your Oracle8 database did not include user SCOTT and you did not run SCOTT.SQL, error messages appear when running ORAMTS.SQL. Ignore these messages. The product functions properly, but the Microsoft application demo will not work.

   2. Go to step 7.

7. Go to the computer where your Oracle Services for Microsoft Transaction Server is installed.

8. Go to the ORACLE_BASE\ORACLE_HOME\ORAMTS\ADMIN directory.

9. Use an ASCII editor to open the file MTSUSER.SQL.

10. Replace all occurrences of MTS_USER with a custom user name (in this example, the user name entered is FRANK).

11. Replace all occurrences of MTS_PASSWORD with a custom password.

12. Save your changes and close the file.

13. Start SQL*Plus:

    C:\> SQLPLUS
    

14. Connect with the INTERNAL user name:

    ENTER USER-NAME: INTERNAL
    

15. Run the MTSUSER.SQL script:

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

    This creates a custom Oracle Service for MTS user.

16. Exit SQL*Plus:

    SQL> EXIT
    

17. Follow the procedures in section "Creating a New Oracle Service for MTS". When you get to step 10, enter the custom user name and password in the Service Information dialog box:

    
    

18. Complete the remaining procedures (steps 11 through 13) in section "Creating a New Oracle Service for MTS".

    When complete, this creates a custom user for the Oracle Service for MTS.

Creating a New Operating System-Authenticated Oracle Service for MTS

Your Oracle Service for MTS user name can be authenticated by the Windows NT operating system. This provides you with the advantage of not having to enter a user name and password when creating your Oracle Service for MTS.

Note: These instructions assume you are familiar with enabling Oracle8 database users to be authenticated by Windows NT. See the following documentation for additional information: For Oracle release 8.1.6, see your Oracle8i Administrator's Guide for Windows NT For Oracle release 8.0.6, see your Getting Started guide

To create an operating system-authenticated Oracle Service for MTS user:

1. Authenticate a Windows NT user name by following the instructions in the above-mentioned guides. Ensure that you grant the following roles and privileges to the user:
   • CONNECT, RESOURCE, and SELECT_CATALOG_ROLE roles

   • FORCE ANY TRANSACTION, CREATE PUBLIC SYNONYM, and DROP PUBLIC SYNONYM privileges

2. Log onto Windows NT with the authenticated user name.

3. Follow the procedures in section "Creating a New Oracle Service for MTS". When you get to step 10, leave the User Name and Password fields blank in the Service Information dialog box:

   
   

4. Complete the remaining procedures (steps 11 through 13) in section "Creating a New Oracle Service for MTS".

5. Choose Start > Settings > Control Panel.

   The Control Panel window appears.

6. Double-click Services.

7. The Services dialog box appears.

8. Select OracleMTSServicen and click Startup.

   where n is the Oracle Service for MTS number you want to modify.

   The Service dialog box appears:

   
   
9. Select This Account.

10. Specify the operating system authenticated user name with which you logged onto the computer in step 2.

11. Enter the password in the Password field.

12. Enter the password a second time in the Confirm Password field.

13. Click OK to exit the Service dialog box.

14. Click Close to exit the Services dialog box.

15. Exit the Control Panel window.

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

    The Microsoft Management Console appears.

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

18. Right-click the new Oracle Service for MTS icon.

    A menu appears with several options.

19. Choose Stop Service.

    The service stops.

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

    A menu appears with several options.

21. Choose Start Service.

    The service starts.

Enabling an Existing Oracle Service for MTS to be Operating System-Authenticated

You can modify an existing Oracle Service for MTS to be associated with an operating system-authenticated user on Windows NT.

To modify an existing user to be operating system-authenticated:

1. Authenticate a Windows NT user name by following the instructions in the above-mentioned guides. Ensure that you grant the following roles and privileges to the user:
   • CONNECT, RESOURCE, and SELECT_CATALOG_ROLE roles

   • FORCE ANY TRANSACTION, CREATE PUBLIC SYNONYM, and DROP PUBLIC SYNONYM privileges

2. Log onto Windows NT with the authenticated user name.

3. Choose Start > Settings > Control Panel.

   The Control Panel window appears.

4. Double-click Services.

5. The Services dialog box appears.

6. Select OracleMTSServicen and click Startup.

   where n is the Oracle Service for MTS number you want to modify.

   The Service dialog box appears:

   
   
7. Select This Account.

8. Specify the operating system authenticated user name with which you logged onto the computer in step 2.

9. Enter the password in the Password field.

10. Enter the password a second time in the Confirm Password field.

11. Click OK to exit the Service dialog box.

12. Click Close to exit the Services dialog box.

13. Exit the Control Panel window.

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

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

    The Microsoft Management Console appears.

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

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

    A menu appears with several options.

18. Choose Properties.

    The Properties dialog box contains a Database tab that displays the following information:

    
    
19. Remove all information from the User Name and Password fields.

20. Click OK.

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

    A menu appears with several options.

22. Choose Stop Service.

    The service stops.

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

    A menu appears with several options.

24. Choose Start Service.

    The service starts.