3
Creating a New Oracle Service for MTS

This chapter describes how to create a new Oracle Service for MTS that connects to the Oracle8 database with the user name MTSSYS.

Specific topics discussed are:

• What Do You Need to Configure?

• Verifying Initialization Parameter File Values

• Verifying the Oracle Service for MTS User Name

• Creating a New Oracle Service for MTS

What Do You Need to Configure?

You must configure your Microsoft Transaction Server and Oracle8 database environments after installing the Oracle Services for Microsoft Transaction Server. Review this table to identify what you need to configure:

On The...	Is Any Configuration Required?
Client computer	No.
Computer where the Oracle8 database is installed	It depends upon your database environment. There are two areas that you may want to verify: Verify several Oracle8 database initialization parameter file settings. See section: "Verifying Initialization Parameter File Values" Verify that the special Oracle Service for MTS user name MTSSYS exists in your Oracle8 database. See section: "Verifying the Oracle Service for MTS User Name"
Windows NT computer where Microsoft Transaction Server is installed	Yes. Create a new Oracle Service for MTS for each Oracle8 database to which COM components can connect. See section: "Creating a New Oracle Service for MTS"

Additional Information: Non-Oracle products may also require configuration. See the documentation that came with those products for any configuration responsibilities.

Verifying Initialization Parameter File Values

You can verify that several initialization parameters are set to sufficient values. The values to which to set these parameters are determined by the workload environment of your database.

To verify initialization parameter file values:

1. Go to the computer on which the Oracle8 database is installed.

2. Start SQL*Plus:

   C:\> SQLPLUS
   

3. Connect with the INTERNAL user name:

   ENTER USER-NAME: INTERNAL
   

4. Check the value for the SESSIONS parameter:

   SQL> SHOW PARAMETER SESSIONS
   

5. Check the value for the PROCESSES parameter:

   SQL> SHOW PARAMETER PROCESSES
   

   The current settings for both parameters should be sufficient for running the Microsoft application demo described in Chapter 4, "Using the Microsoft Application Demo". For creating and deploying your own COM-based applications, the values to which to set these parameters depend upon the anticipated workload for your database environment. For example, if you anticipate 100 concurrent connections to your Oracle8 database, consider setting both values to 200 to account for any system overload. Ensure that you do not set these parameters too high, as they are resource-intensive. See Oracle8i Reference and Oracle8i Administrator's Guide for information on these parameters.

6. If you want to set these parameters to different values, see section "Changing Initialization Parameter File Settings" for instructions.

Verifying the Oracle Service for MTS User Name

You must assign a user name to the new Oracle Service for MTS. A special Oracle Service for MTS user name is typically included in your Oracle8 database for Windows NT:

User Name	Password	Description
MTSSYS	MTSSYS	User name with: CONNECT, RESOURCE, and SELECT_CATALOG_ROLE database roles FORCE ANY TRANSACTION, CREATE PUBLIC SYNONYM, and DROP PUBLIC SYNONYM database privileges SELECT, INSERT, UPDATE, and DELETE rights on the Oracle Service for MTS table in the Oracle8 database

This section describes how to connect as user name MTSSYS with the new Oracle Service for MTS. Review the table below to determine if your Oracle8 database includes this user name:

If You Create Your Oracle8 Database Through These Methods...	MTSSYS is...
Through the Typical or Minimal installation type of the Oracle8i Enterprise Edition or Oracle8i database type Through the Typical option of the Oracle Database Configuration Assistant where you select to copy existing database files from the CD Manually using the database creation script available on your Oracle 8.1 CD-ROM (On Windows NT, this script is named BUILDALL.SQL and is described in the Oracle8i Administrator's Guide for Windows NT) Manually using your own SQL script, and then run the SCOTT.SQL and ORAMTS.SQL scripts in that order against the database1	Automatically included on Windows NT
Through the Custom option of the Oracle Database Configuration Assistant Through the Typical option of the Oracle Database Configuration Assistant where you select to create new database files Manually using your own SQL script, and do not run ORAMTS.SQL against the database Using the CREATE DATABASE syntax in SQL*Plus line mode In any available method on Solaris or any other operating system other than Windows NT In any available method with Oracle8 database release 8.0.6. Note: Release 8.0.6 users must obtain and run the ORAMTS.SQL script included with release 8.1.x.	Not created. See "Manually Creating the MTSSYS User" or "Manually Creating a Custom Oracle Service for MTS User"

1 If you run ORAMTS.SQL before SCOTT.SQL or do not run SCOTT.SQL at all, numerous error messages appear when running ORAMTS.SQL. Ignore these messages. The product functions properly, but the sample application demo described in section "Using OCI with the Microsoft Application Demo" will not work.

To ensure that your Oracle8 database includes MTSSYS, try to log on with this user name. In addition, Oracle Corporation strongly recommends that you change the MTSSYS password.

To verify the MTSSYS user name and change the password:

1. Go to the computer on which your Oracle8 database is installed.

2. Start SQL*Plus:

   C:\> SQLPLUS
   

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

   ENTER USER-NAME: MTSSYS/MTSSYS
   

   If the connection is successful, this verifies that MTSSYS is included in your Oracle8 database. If the connection is not successful, you must create an Oracle Service for MTS user name. See section "Manually Creating the MTSSYS User" or section "Manually Creating a Custom Oracle Service for MTS User".

4. Change the password for the MTSSYS user:

   SQL> ALTER USER MTSSYS IDENTIFIED BY NEW_PASSWORD;
   

   This changes your MTSSYS user name password.

   Note: You can also have your Oracle Service for MTS user name authenticated by the operating system. In this case, your Windows NT domain user name is used instead of MTSSYS. See "Creating a New Operating System-Authenticated Oracle Service for MTS" for instructions.

Creating a New Oracle Service for MTS

Follow the procedures below to create a new Oracle Service for MTS to which to assign the MTSSYS user name.

To create a new Oracle Service for MTS:

1. Go to the computer where you installed Oracle Services for Microsoft Transaction Server.

   Note: You can configure the Oracle Service for MTS on this computer or use this computer to configure the Oracle Service for MTS on a remote computer.

2. Use Net8 Assistant to create the net service name MTSDEMO that connects to your Oracle8 database. See the Net8 Administrator's Guide for instructions. The MTSDEMO connection enables you to quickly use the Microsoft application demo described in section "Using OCI with the Microsoft Application Demo".

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

   The Microsoft Management Console Explorer appears:

   
   
4. Right-click Computers.

   A menu appears with several options.

5. Choose New > Computer.

   The Add Computer dialog box appears:

   
   
6. Enter the domain and name of the computer on which to configure the Oracle Service for MTS and click OK.

   Note: You must have Administrator privileges on this computer.

   Note: If creating an Oracle Service for MTS on a remote computer, Microsoft Transaction Server and Oracle Services for Microsoft Transaction Server must already be installed on the remote computer.

   A new icon is created under Computers in the Microsoft Management Console Explorer:

   
   
7. Double-click the new icon.

   The Oracle Manager for MTS Services snap-in appears:

   
   
8. Right-click the Oracle Manager for MTS Services snap-in.

   A menu appears with several options.

9. Choose New > Service.

   The Service Information dialog box appears.

   
   
10. Enter the following information:

    Where...	Is...
    User Name	MTSSYS
    Password	MTSSYS
    Database Alias	The net service name that connects to the Oracle8 database created in step 2. For this example, the network connection name MTSDEMO is entered.
    Connect As	The privileges with which to connect to the Oracle8 database (NORMAL, SYSOPER, or SYSDBA).
    Oracle Home	The unique home name for the Oracle8 database installation.

    When complete, the Service Information dialog box appears as follows:

    
    
11. Click OK.

    The following message indicates that the Oracle Service for MTS was created and started:

    
    
12. Click OK.

    A new Oracle Service for MTS icon named MTSDEMO appears beneath the Oracle Manager for MTS Services snap-in. This icon is named after the net service name entered in the Database Alias field of the Service Information dialog box in step 10.

    
    
13. If the Oracle Service for MTS does not start, follow these instructions:
    1. Right-click the new Oracle Service for MTS icon (for example, MTSDEMO) in the Microsoft Management Console Explorer.

       A menu appears with several options:

       
       
    2. Choose Start Service.

       The Oracle Service for MTS starts.

       Note: If the Oracle Service for MTS still does not start, see "Identifying Oracle Service for MTS Startup Problems" for troubleshooting information.