Oracle Developer's Guide for Microsoft Transaction Server Release 9.0.1 for Windows Part Number A90170-01 |
|
This chapter describes installation and migration requirements for the Microsoft Transaction Server and Oracle database server environment.
This chapter contains these topics:
Figure 2-1 shows a typical Microsoft Transaction Server and multiple database server installation layout.
Table 2-1 lists the Oracle and non-Oracle products you must install. After reviewing the installation requirements, see the Oracle9i Database installation guide for Windows for instructions on installing the required Oracle products. Key guidelines to understand are:
What Products Must Be Installed? | ||
---|---|---|
On This Computer... | Oracle Products | Non-Oracle Products |
Client computer |
||
Windows NT computer where Microsoft Transaction Server is installed
|
|
|
Computer where the database server is installed |
|
1
See the Oracle9i Database installation guide for Windows for installation instructions. During installation, you are prompted to enter the port number on which the Oracle MTS Recovery Service will listen for requests to resolve in-doubt transactions. 2 Oracle Net Services is automatically installed with Oracle Services for Microsoft Transaction Server. 3 The 9.0 releases of OO4O, Oracle ODBC Driver, Oracle Provider for OLE DB, and OCI are only required if you are building or using components with which they are required. 4 An applications server like IIS is not required, but is beneficial if using Microsoft Transaction Server. Install the applications server on the same computer as Microsoft Transaction Server. The applications server you choose must support extensions. 5 Microsoft Transaction Server is currently available as part of the Microsoft Windows NT 4.0 Option Pack. Microsoft Management Console is automatically installed with Microsoft Transaction Server. 6 After installing Microsoft Transaction Server 2.0, Oracle Corporation recommends that you install Windows NT 4.0 Service Pack 5 or higher. You must re-install any service packs installed prior to Microsoft Transaction Server 2.0 installation. 7 If the database server is a release prior to 8.0.6, you cannot use the integration described in this guide. See "Using Microsoft's Oracle ODBC Driver" for a description of what functionality is available for pre-8.0.6 database servers. |
Starting with Oracle9i release 9.0, you no longer have to create the Oracle Service for MTS. However, before proceeding to uninstall Oracle Services for Microsoft Transaction Server, you must use the Oracle Manager for MTS Services snap-in in the Microsoft Management Console Explorer to delete the existing Oracle Service for MTS. Table 2-2 shows the procedures to follow.
Table 2-2 Migration Requirements
If You... | Then... | See... |
---|---|---|
Migrate the release 8.1.x database server to the current release and create a new installation of release 9.0 |
|
"Deleting an Oracle Service for MTS with the Oracle Manager for MTS Services Snap-In" "Using the Registry to Manually Delete the Oracle Service for MTS" if you have already deleted the database server |
|
"Deleting Roles and Privileges of an Inactive Oracle Service for MTS User" |
|
|
|
|
|
You must use the 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 keyboard's Delete button) causes data inconsistencies in the database server. These inconsistencies require the database administrator to manually commit or abort 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.
To stop the Oracle Service for MTS:
The Microsoft Management Console appears.
MTSDEMO
in this example):
Text description of the illustration ch22.gif
A menu appears with several options.
A message indicates that the Oracle Service for MTS has stopped.
To stop and restart the database server:
C:\> sqlplus /NOLOG
SYSDBA
:
ENTER USER-NAME: / AS SYSDBA
SQL> SHUTDOWN
SQL> STARTUP
SQL> EXIT
To restart the Oracle Service for MTS:
The Microsoft Management Console appears.
A menu appears with several options.
A message indicates that the Oracle Service for MTS started.
To monitor the Oracle Service for MTS trace files:
2515156: [2096] OracleMTSService - Accepting new enlistment requests.
This file is located in ORACLE_BASE
\
ORACLE_HOME
\oramts\trace
.
A message indicates that the Oracle Service for MTS stopped.
To delete Oracle Service for MTS table information:
C:\> sqlplus /NOLOG
SYSDBA
:
ENTER USER-NAME: / AS SYSDBA
SQL> DROP TABLE mtsadmin_username.mts_proxy_info;
where mtsadmin_username
is the Oracle Service for MTS user (for example, mtssys
).
SQL> COMMIT;
To delete the Oracle Service for MTS:
The Microsoft Management Console appears.
A menu appears with several options.
If a Message Indicates That... | Go To... |
---|---|
The Oracle Service for MTS was successfully deleted. |
"Deleting Roles and Privileges of an Inactive Oracle Service for MTS User" |
The Oracle Service for MTS was not deleted. |
"Using the Registry to Manually Delete the Oracle Service for MTS" |
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:
ORACLE_BASE\ORACLE_HOME
\oramts\admin
.
revokeuser.sql
with a text editor.
mts_user
with the username from which to revoke roles and privileges.
revokeuser.sql
.
C:\> sqlplus /NOLOG
SYSDBA
:
ENTER USER-NAME: / AS SYSDBA
SQL> @ORACLE_BASE\ORACLE_HOME\oramts\admin\revokeuser.sql;
The roles and privileges for the user are deleted.
SQL> EXIT
Before deleting the Oracle Service for MTS, it must be cleanly disassociated from the database server to which it connects. Sometimes this disassociation fails. Follow the instructions in this section only if:
Table 2-3 describes the scenarios in which the Oracle Manager for MTS Services snap-in of the Microsoft Management Console Explorer can fail to delete or modify the Oracle Service for MTS.
Table 2-3 Oracle Service for MTS Deletion or Modification Failures
To manually delete the Oracle Service for MTS with the registry:
C:\> regedt32
The Registry Editor window appears.
HKEY_LOCAL_MACHINE\System\CurrentControlSet\ Services\OracleMTSService
n
.
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 OracleMTSService
n
, including those listed in the following table:
Parameter | This Parameter Contains... |
---|---|
|
The Oracle Service for MTS username |
|
The password for the Oracle Service for MTS username (encrypted in the registry) |
|
The net service name for the Oracle Service for MTS to use in connecting to the database server |
C:\> sqlplus /NOLOG
ENTER USER-NAME: 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.
SQL> SELECT NAME, DBID FROM V$DATABASE;
which displays information similar to the following:
NAME DBID --------------------- ORCL 12345678
ORAMTS_DBNAME
(ORCL
in this example) and ORAMTS_DBID
(12345678
in this example).
SQL> SELECT rmguid FROM mts_proxy_info;
which displays information similar to the following:
RMGUID ------------------------- 2320b23e93e09fff02a231974
ORAMTS_RMGUID
.
If not all values match, the database server is not the same one to which the Oracle Service for MTS connects. If you continue, Oracle Service for MTS installation on the database server fails. This can leave the database server in an inconsistent state that requires database administrator intervention to correct. The reason SQL*Plus connected to a different database server than the Oracle Service for MTS is mismatching tnsnames.ora
files.
SQL> DELETE FROM mts_proxy_info; SQL> COMMIT;
SQL> EXIT
To delete the OracleMTSServicen service:
The Microsoft Management Console appears.
A menu appears with several options.
If successful, a message indicates that the Oracle Service for MTS was deleted.
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services \OracleMTSService
n
.
where n
is the number of the Oracle Service for MTS.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|