3
Creating a New Oracle Service for MTS

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

Specific topics discussed are:

• What Do You Need to Configure?
• Verifying INIT.ORA File Parameter Values
• Verifying 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 Oracle8i 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 Oracle8i database is installed	It depends upon your database environment. There are two areas that you may want to verify:  Verify several Oracle8i database INIT.ORA file initialization parameter settings. See section:  "Verifying INIT.ORA File Parameter Values" Verify that the special Oracle Service for MTS user name MTSSYS exists in your Oracle8i database. See section:  "Verifying 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 Oracle8i database to which COM components can connect. See section:  "Creating a New Oracle Service for MTS"

 

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

Verifying INIT.ORA File Parameter Values

You may want to verify that several INIT.ORA file 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 INIT.ORA file parameter values:

1. Go to the computer on which the Oracle8i 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 Oracle8i 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 INIT.ORA File Parameter 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 Oracle8i 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 Oracle8i 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 Oracle8i database includes this user name:

If You Create Your Oracle8i Database Through These Methods...	MTSSYS is...
Through the Typical option of Oracle Universal Installer  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 your Getting Started guide.)  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	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 Oracle8i 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 Oracle8i 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 Oracle8i 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 or Net8 Easy Config to create a Net8 network connection (known as a net service name) named MTSDEMO to your Oracle8i 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 the 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 Net8 network connection (net service name) to the Oracle8i 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 Oracle8i database (NORMAL, SYSOPER, or SYSDBA).
Oracle Home	The unique home name for the Oracle8i 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 Net8 network connection 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.

 

---