¢éÍÁÙÅà¡ÕèÂǡѺ¡ÒÃãªé Oracle ¡Ñº¤ÍÁâ¾à¹¹µì¢Í§ Microsoft Server ·Ãҹ᫤ªÑ¹áÅÐ COM +

ã¹ÊèǹµèÍ仹ÕéáÊ´§ÃÒ¡ÒÃÅӴѺá¹Ð¹Ó¢Í§¡ÒõԴµÑ駫ͿµìáÇÃìÊÓËÃѺ¡ÒÃãªé COM + áÅФÍÁâ¾à¹¹µì MTS ¡Ò÷ӧҹ¡Ñº°Ò¹¢éÍÁÙÅ Oracle ¶éҤسäÁè·Ó¡ÒõԴµÑ駷Õèã¹ãºÊÑ觷Õèá¹è¹Í¹¹Õé ¤ÍÁâ¾à¹¹µìÍÒ¨äÁè·Ó§Ò¹ÍÂèÒ§·Õè¤Ò´äÇéà¹×èͧ¨Ò¡¡ÒõÑ駤èҤ͹¿Ô¡»Ñ­ËÒ

Windows 2000:

àÁ×è͵éͧ¡ÒõÃǨÊͺãËéá¹èã¨ÇèÒ â¾à¹¹µì COM + ¢Í§·Ãҹ᫤ªÑ¹·Õè·Ó§Ò¹¡Ñº Oracle ´Óà¹Ô¹¡ÒôѧµèÍ仹Õé:

1. µÔ´µÑé§ Windows 2000
2. µÔ´µÑé§ä¤ÅàÍç¹µì¢Í§ Oracle 8.1.7 ¾ÃéÍÁ¡Ñº¡ÒÃÍѾഠ8.1.7.1.5 ÊÓËÃѺ¢éÍÁÙÅà¡ÕèÂǡѺÇÔ¸Õ¡ÒõԴµÑ駡ÒûÃѺ»ÃاÅèÒÊØ´ µÔ´µèÍ Oracle
3. µÔ´µÑé§ Oracle Net8 ´éÇÂâ»Ãá¡ÃÁ»ÃѺ»ÃاÅèÒÊØ´
4. ¡ÒõԴµÑé§ Microsoft Data Access ¤ÍÁâ¾à¹¹µì (MDAC) 2.6 Service Pack 1 (SP1) ËÃ×Íã¹ÀÒÂËÅѧ
5. »ÃѺ»Ãا¤ÕÂìÃÕ¨ÔÊ·ÃÕ«Í¿µìáÇÃì¢Í§ä¤ÅàÍç¹µì ´Ù¢éÍÁÙÅà¾ÔèÁàµÔÁ "¢Ñ鹵͹·Õè 7: ä¤ÅàÍç¹µì¢Í§ Oracle »ÃѺ»Ãا«Í¿µìáÇÃìÃÕ¨ÔʵÃÕ¤ÕÂì"

Windows NT 4.0

àÁ×è͵éͧ¡ÒõÃǨÊͺãËéá¹èã¨ÇèÒ ¤ÍÁâ¾à¹¹µì MTS ¢Í§·Ãҹ᫤ªÑ¹·Õè·Ó§Ò¹¡Ñº Oracle ´Óà¹Ô¹¡ÒôѧµèÍ仹Õé:

1. ¡ÒõԴµÑé§ Windows NT SP6a ËÃ×Íã¹ÀÒÂËÅѧ
2. µÔ´µÑé§ä¤ÅàÍç¹µì¢Í§ Oracle 8.1.7 ¾ÃéÍÁ¡Ñº¡ÒÃÍѾഠ8.1.7.1.5 ÊÓËÃѺ¢éÍÁÙÅà¡ÕèÂǡѺÇÔ¸Õ¡ÒõԴµÑ駡ÒûÃѺ»ÃاÅèÒÊØ´ µÔ´µèÍ Oracle
3. µÔ´µÑé§ Oracle Net8 ´éÇÂâ»Ãá¡ÃÁ»ÃѺ»ÃاÅèÒÊØ´
4. µÔ´µÑ駪شµÑÇàÅ×Í¡¢Í§ Windows NT
5. µÔ´µÑé§ Windows NT SP6a
6. µÔ´µÑé§ MDAC 2.6 SP1 ËÃ×Íã¹ÀÒÂËÅѧ
7. »ÃѺ»Ãا¤ÕÂìÃÕ¨ÔÊ·ÃÕ«Í¿µìáÇÃì¢Í§ä¤ÅàÍç¹µì ´Ù¢éÍÁÙÅà¾ÔèÁàµÔÁ "¢Ñ鹵͹·Õè 7: ä¤ÅàÍç¹µì¢Í§ Oracle »ÃѺ»Ãا«Í¿µìáÇÃìÃÕ¨ÔʵÃÕ¤ÕÂì"

ÊÓËÃѺ¢éÍÁÙÅà¾ÔèÁàµÔÁà¡ÕèÂǡѺ¢Ñ鹵͹àËÅèÒ¹Õé ãËé´Ù·ÕèÊèǹ "µÑé§ Oracle ʹѺʹع"

ËÁÒÂà˵Ø:ËÁÒÂàÅ¢àÇÍÃìªÑ¹·Ñé§ËÁ´·ÕèÃкØäÇé㹺·¤ÇÒÁ¹Õé¶Ù¡»Ñ¨¨ØºÑ¹ã¹¢³Ð·ÕèÁÕà¢Õ¹º·¤ÇÒÁ àÃÒ¢Íá¹Ð¹ÓÍÂèÒ§ÂÔè§ãËé ¤Ø³ãªéÃØè¹ÅèÒÊØ´áÅлÃѺ»Ãا¢Í§ Oracle «Í¿µìáÇÃì·Ñé§ËÁ´áÅЫͿµìáÇÃì¢Í§ Microsoft ÃØ蹡è͹˹éÒºÒ§¤ÍÁâ¾à¹¹µì·ÕèÃкØäÇé㹺·¤ÇÒÁ¹ÕéÍÒ¨·Ó§Ò¹ adequately 㹺ҧʶҹ¡Òóì áµèäÁèÍÂÙè ã¹¼ÙéÍ×è¹

µÑ駤èÒ¡ÒÃʹѺʹع¢Í§ Oracle

¡ÒõÑ駤èÒ Oracle à¾×èÍ·Ó§Ò¹¡Ñºâ¾à¹¹µì COM + ¢Í§·Ãҹ᫤ªÑ¹áÅФÍÁâ¾à¹¹µì MTS ·ÓµÒÁ¢Ñ鹵͹àËÅèÒ¹Õé

¢Ñ鹵͹·Õè 1: «Í¿µìáÇÃìà«ÔÃì¿àÇÍÃì°Ò¹¢éÍÁÙÅ Oracle µÔ´µÑé§

µÔ´µÑ駫ͿµìáÇÃìÊÓËÃѺà«ÔÃì¿àÇÍÃì°Ò¹¢éÍÁÙÅ Oracle ã¹Ãкº¢Í§à«ÔÃì¿àÇÍÃì°Ò¹¢éÍÁÙŢͧ¤Ø³ ¶éҤس COM +/ à¢éÒá;ÅÔपѹ MTS ¶Ö§°Ò¹¢éÍÁÙÅ oracle º¹ Windows NT, Windows 2000 ËÃ×Í UNIX ·ÓãËéá¹èã¨ÇèÒ·ÕèÁÕ¡ÒõԴµÑ駡ÒûÃѺ»ÃاÅèÒÊØ´¢Í§ Oracle º¹Ãкº·Õè ¡ÒâÍÃѺ¡ÒûÃѺ»ÃاÅèÒÊØ´¢Í§ Oracle ÊÓËÃѺ Windows NT ËÃ×Í Windows 2000 ä»·Õè Oracle àÇçºä«µìµèÍ仹Õé:à¢éÒÊÙèÃкºä»Âѧ䫵ì áÅШҡ¹Ñé¹ àÅ×Í¡á¾·ªìº¹á¶º¹Ó·Ò§«éÒ àÁ×è͵éͧ¤é¹ËÒ¡ÒûÃѺ»ÃاÅèÒÊØ´ ¤ÅÔ¡à«ÔÃì¿àÇÍÃì oracleà·èÒ¹Ñé¹µÃСÙżÅÔµÀѳ±ìáÅéÇ àÅ×Í¡ms Windows NT/2000à»ç¹Ãкº»¯ÔºÑµÔ¡Òà ÊÓËÃѺ¢éÍÁÙÅà¡ÕèÂǡѺÇÔ¸Õ¡ÒõԴµÑ駡ÒûÃѺ»ÃاÅèÒÊØ´ µÔ´µèÍ Oracle

ËÁÒÂà˵Ø:àÃÒ¢Íá¹Ð¹ÓãËé ¤Ø³µÔ´µÑé§à«ÔÃì¿àÇÍÃì Oracle áÅÐ COM +/ MTS º¹¤ÍÁ¾ÔÇàµÍÃì·ÕèᡵèÒ§ËÒ¡

¡ÒÃà»Ô´ãªé§Ò¹¡ÒÃʹѺʹع¢Í§¸ØáÃÃÁ Oracle XA

¶éҤس¡ÓÅѧãªé Oracle 8 ËÃ×Í Oracle 8i ãËéÅͧµèÍ仹Õé:

• µÃǨÊͺãËéá¹èã¨ÇèÒÁͧ$ V $ XATRANS áÅÐÁØÁÁͧ DBA_PENDING_TRANSACTIONS ä´é¶Ù¡ÊÃéҧ㹠Oracle 8 ËÃ×Íà»ç¹°Ò¹¢éÍÁÙÅ oracle 8i ¢Í§¤Ø³ ¶éÒÁØÁÁͧ¹ÕéäÁèÁÕÍÂÙè ¼Ùé´ÙáÅÃкº Oracle µéͧÊÃéÒ§¢Öé¹ä´é â´Â¡ÒÃàÃÕ¡ãªéʤÃÔ»µì¡ÒáÓ˹´ãËé Oracle XAVIEW.SQL ¡ÒõÑ駪×èÍ á¿éÁ¹ÕéÊÒÁÒö¾ºä´éã¹¹Ñé¹â¿Åà´ÍÃì¡ÒõԴµÑé§\ADMIN â¿Åà´ÍÃì ʤÃÔ»µì¹Õé SQL µéͧÊÒÁÒö´Óà¹Ô¹¡ÒÃà»ç¹¼Ùéãªé "SYS" Oracle
• ¼Ùé´ÙáÅÃкº Oracle µéͧ͹حҵà¢éÒ SELECT ÊÒ¸ÒóÐÊÓËÃѺÁØÁÁͧ DBA_PENDING_TRANSACTIONS

¡ÒõÑ駤èҤ͹¿Ô¡¸ØáÃÃÁ¡ÒáÃШÒ¾ÃéÍÁ¡Ñ¹·Õèà¾Õ§¾Í

㹡Òà Oracle ÍÂèÒ§ Manager ·ÓµÒÁ¢Ñ鹵͹àËÅèÒ¹Õé:

1. 㹡ÒÃÁØÁÁͧàÁ¹Ù ãËéªÕéä»·ÕèâËÁ´¢Ñé¹ÊÙ§áÅéÇ ¤ÅÔ¡¾ÒÃÒÁÔàµÍÃì¡ÒÃàµÃÕÂÁãªé§Ò¹ã¹ºÒ¹Ë¹éÒµèÒ§´éÒ¹«éÒÂ
2. 㹺ҹ˹éÒµèÒ§´éÒ¹¢ÇÒ àÅ×Í¡¢Ñé¹ÊÙ§¡ÒûÃѺ¤èÒáÅÐà¾ÔèÁáÅéÇ ¹Õédistributed_transactions¾ÒÃÒÁÔàµÍÃì¡ÒÃ͹حҵ MTS ¾ÃéÍÁ¡Ñ¹ÁÒ¡·Õè¸ØáÃÃÁ¡ÒûÃѺ»Ãا°Ò¹¢éÍÁÙÅã¹àÇÅÒà´ÕÂǡѹ

For more information, see the "Configure Oracle to support many connections" section.

Configure integrated security

ËÁÒÂà˵Ø:If your COM+/MTS components always supply a login ID and a password when they connect to Oracle databases, you are not using integrated security. This is true whether your applications specify the login ID and the password directly or indirectly through a DSN. In either case, you do not use integrated security, and you can skip this step.

If you use integrated security, you must configure Microsoft Distributed Transaction Coordinator (MSDTC) to run under a login ID and a password that is authorized to connect to your Oracle database. This is required because during database recovery, MSDTC opens your Oracle database to tell it the outcome of in-doubt transactions.

Integrated security permits an Oracle database to rely on Windows NT or Windows 2000 authentication to validate database users. This enables a user to log on to Oracle without supplying a separate login ID or password. Users can maintain one login ID and one password for both Windows NT or Windows 2000 and Oracle.

ËÁÒÂà˵Ø:For integrated security, the user ID in the connection string must to be a slash (/). Otherwise, all logins fail:If you run the MSDTC/COM+ system on a Microsoft Cluster Server cluster, the account where MSDTC runs must also be a member of the Cluster Administrator Group for Microsoft Cluster Server.

To configure the login ID for MSDTC, follow these steps:

1. ¤ÅÔ¡àÃÔèÁ¡Ò÷ӧҹªÕéä»·Õè¡ÒõÑ駤èÒáÅéÇ ¤Åԡἧ¤Çº¤ØÁ.
2. Start theºÃÔ¡ÒÃutility.
3. ¤ÅÔ¡Êͧ¤ÃÑé§MSDTC.
4. ¤ÅÔ¡Log On As, and then specify a login ID and a password.
   
   ËÁÒÂà˵Ø:Use the Oracle security administration tools to make sure that the login ID that you specify is authorized to open your Oracle database.

For more information about Oracle integrated Windows NT and Windows 2000 security facilities, see your Oracle documentation.

Configure Oracle Multi-Threaded Server support

You must configure the Oracle Multi-Threaded Server feature if you want to open a database link to a remote Oracle database. You must complete this step because the Oracle database uses XA transaction support. The Oracle database must be able to move the XA transaction between processes (in the general case), so that it cannot have any operating system file descriptors open. Instead, it must use a virtual circuit to connect to the remote database. Virtual circuits are only supported with Oracle Multi-Threaded Server.

If the Oracle Multi-Threaded Server feature is not configured correctly, Oracle reports the following error message:ËÁÒÂà˵Ø:Oracle refers to the Multi-Threaded Server feature with the acronym MTS. Microsoft documentation sometimes refers to Microsoft MTS with the acronym MTS.

Configure Oracle to support more connections

If you want to create more than several dozen connections to an Oracle database, you must configure the Oracle server to support additional database connections. For more information, see "Configure Oracle to support many connections" in the "Administer Oracle and MSDTC" section.

Step 2: Install Oracle client software with the latest updates

Install Oracle client software with the latest updates on your COM+/MTS system. Oracle Client 8.1.7, with the latest update, 8.1.7.1.5, works correctly with transactional COM+/MTS components.

ÊÔè§ÊӤѭMake sure that you install Oracle Net8 when you install Oracle Client 8.1.7. Additionally, when you use Oracle 8.1.7, do not install Oracle Services for MTS if you are using Microsoft OLEDB/ODBC drivers. Oracle Services for MTS is not required for COM+/MTS components to work correctly with Oracle Database.

ÅÙ¡¤éÒÃØ蹡ÒûÃѺ»ÃاàËÅèÒ¹Õé Oracle º¹Ãкº·Õè»ÃСͺ´éÇ°ҹ¢éÍÁÙÅ Oracle ¢Í§¡ÒûÃѺÃØ蹺èÍ æ áµè¨ÐäÁèÊÒÁÒöµÔ´µÑé§ÃØ蹡ÒûÃѺ»Ãا Oracle º¹Ãкº·Õè»ÃСͺ´éÇ COM ¢Í§¾Ç¡à¢Ò +/ ¤ÍÁâ¾à¹¹µì MTS oracle ä´éá¡é䢺ѡµèÒ§ æ ·ÕèÁռŵèÍ¡ÒÃʹѺʹع¢Í§ä¤ÅàÍç¹µì¢Í§·Ãҹ᫤ªÑ¹ XA ¤Ø³µéͧµÔ´µÑ駡ÒûÃѺ»ÃاÃØè¹ÅèÒÊØ´¢Í§ Oracle º¹ COM ¢Í§ +/ MTS Ãкº ¡ÒâÍÃѺ¡ÒûÃѺ»ÃاÅèÒÊØ´¢Í§ Oracle ÊÓËÃѺ Windows NT ä»·Õè Oracle àÇçºä«µìµèÍ仹Õé:à¢éÒÊÙèÃкºä»Âѧ䫵ì áÅШҡ¹Ñé¹ àÅ×Í¡á¾·ªìº¹á¶º¹Ó·Ò§«éÒ àÁ×è͵éͧ¤é¹ËÒ¡ÒûÃѺ»ÃاÅèÒÊØ´ ¤ÅÔ¡à«ÔÃì¿àÇÍÃì oracleà·èÒ¹Ñé¹µÃСÙżÅÔµÀѳ±ìáÅéÇ àÅ×Í¡ms Windows NT/2000à»ç¹Ãкº»¯ÔºÑµÔ¡Òà ÊÓËÃѺ¢éÍÁÙÅà¡ÕèÂǡѺÇÔ¸Õ¡ÒõԴµÑ駡ÒûÃѺ»ÃاÅèÒÊØ´ µÔ´µèÍ Oracle

¢Ñ鹵͹·Õè 3: MTS 2.0 ·ÕèµÔ´µÑé§

µÔ´µÑé§ MTS 2.0 àÁ×è͵éͧ¡Ò÷Óàªè¹¹Õé µÔ´µÑ駪شµÑÇàÅ×Í¡¡Òà 4 ¢Í§ Windows NT àÁ×èͤسµÔ´µÑé§ MTS 2.0 «Í¿µìáÇÃìµèÍ仹Õé¶Ù¡µÔ´µÑé§:

• 2.0 MTS ÃÇÁ·Ñé§á¿éÁ.dll Microsoft Oracle àÃÕ¡ÍÔ¹à·ÍÃìà¿« (OCI) (Mtxoci.dll)
• µÑǨѴ¡ÒÃâ»Ãá¡ÃÁ¤Çº¤ØÁ Microsoft ODBC 3.5
• â»Ãá¡ÃÁ¤Çº¤ØÁ Microsoft ODBC ÊÓËÃѺ Oracle
• Çѵ¶Ø activex ¢éÍÁÙÅ (ADO)

ËÁÒÂà˵Ø:ÅÐàÇé¹¢Ñ鹵͹¹ÕéÊÓËÃѺ Windows 2000

¢Ñ鹵͹·Õè 4: µÔ´µÑé§ Windows NT 4.0 SP 6a

µÔ´µÑé§ Windows NT 4.0 SP 6a ¼ÅÔµÀѳ±ì·ÕèÁÕ¡ÒÃá¡éä¢ÊÓËÃѺ»Ñ­ËÒ·Õèà¡ÕèÂǡѺ XA MSDTC ËÅÒÂ

ÊÔè§ÊӤѭ¤Ø³µéͧµÔ´µÑ駪شµÑÇàÅ×Í¡ 4.0 Windows NT ¡è͹·Õè¤Ø³µÔ´µÑé§ Windows NT 4.0 SP 6a à¹×èͧ¨Ò¡Ë¹éÒµèÒ§ NT 4.0 Service Pack à«çµâ»Ãá¡ÃÁ¨ÐÍѾ੾ÒÐà´ MTS áÅÐ MSDTC ¶éҪشµÑÇàÅ×Í¡ 4.0 Windows NT ¶Ù¡µÔ´µÑé§áÅéÇ

ËÁÒÂà˵Ø:ÅÐàÇé¹¢Ñ鹵͹¹ÕéÊÓËÃѺ Windows 2000

¡ÒõԴµÑ駢Ñ鹵͹·Õè 5: MDAC 2.6 SP1 ËÃ×ÍãËÁè¡ÇèÒ

µÔ´µÑé§ MDAC 2.6 SP1 ËÃ×ÍÃØè¹ãËÁè¡ÇèÒÊÓËÃѺ¤ÍÁ¾ÔÇàµÍÃì·Õèãªé Windows 2000 àÁ×è͵éͧ¡ÒâÍÃѺ MDAC 2.6 SP1 ËÃ×Íã¹ÀÒÂËÅѧ àÂÕèÂÁªÁàÇçºä«µìµèÍ仹Õé¢Í§ Microsoft:

¢Ñ鹵͹·Õè 6: ãªé¤ÍÁâ¾à¹¹µì Checker à¾×èÍ´ÙÇèÒ ÁջѭËÒ¡ÒõԴµÑé§

ËÅѧ¨Ò¡·Õè¤Ø³µÔ´µÑé§ MDAC ¤Ø³ÊÒÁÒöãªéµÑǵÃǨÊͺ¤ÍÁâ¾à¹¹µìà¾×èÍ´ÙÇèÒ ÁջѭËÒ¡ÒõԴµÑé§ µÑǵÃǨÊͺ¤ÍÁâ¾à¹¹µì¶Ù¡Í͡ẺÁÒà¾×èͪèǤس㹡ÒõÃǨÊͺ¢éÍÁÙÅÃØè¹ áÅÐÇÔà¤ÃÒÐËì»Ñ­ËÒ¡ÒõԴµÑ駡Ѻ MDAC µÑǵÃǨÊͺ¤ÍÁâ¾à¹¹µì·Ó§Ò¹º¹Ãкº»¯ÔºÑµÔ¡ÒõèÍ仹Õé:

• windows 95
• windows 98
• Windows NT 4.0
• Windows 2000:

ÁÕʹѺʹع੾ÒÐÃØè¹ 32 ºÔµ áÅÐ 64 ºÔµÃкº»¯ÔºÑµÔ¡Òà µÑǵÃǨÊͺ¤ÍÁâ¾à¹¹µìä´éÃѺ¡ÒûÃѺ»Ãا¡ÒÃÃÇÁ¢éÍÁÙŢͧ MDAC 2.6 àÁ×è͵éͧ¡ÒôÒǹìâËÅ´à¤Ã×èͧÁ×͹Õé áÇÐä»·ÕèàÇçºä«µìµèÍ仹Õé¢Í§ Microsoft:

¢Ñ鹵͹·Õè 7: ä¤ÅàÍç¹µì¢Í§ Oracle »ÃѺ»Ãا«Í¿µìáÇÃìÃÕ¨ÔÊ·ÃÕ¤ÕÂì

ÊÔè§ÊӤѭ¹ÕéÊèǹ ÇÔ¸Õ ËÃ×ͧҹ»ÃСͺ´éÇ¢Ñ鹵͹·ÕèºÍ¡ÇÔ¸Õ¡ÒÃá¡éä¢ÃÕ¨ÔÊ·ÃÕ ÍÂèÒ§äáçµÒÁ »Ñ­ËÒÃéÒÂáçÍÒ¨à¡Ô´¢Öé¹ËÒ¡¤Ø³»ÃѺà»ÅÕè¹ÃÕ¨ÔÊ·ÃÕäÁè¶Ù¡µéͧ ´Ñ§¹Ñé¹ â»Ã´µÃǨÊͺãËéá¹èã¨ÇèҤسä´é·ÓµÒÁ¢Ñ鹵͹àËÅèÒ¹ÕéÍÂèÒ§ÃÐÁÑ´ÃÐÇѧ ÊÓËÃѺ¡Òûéͧ¡Ñ¹à¾ÔèÁàµÔÁ ãËéÊÓÃͧÃÕ¨ÔÊ·ÃÕ¡è͹·Ó¡ÒûÃѺà»ÅÕè¹ à¾×èÍ·Õè¤Ø³¨ÐÊÒÁÒö¤×¹¤èÒÃÕ¨ÔÊ·ÃÕä´éËÒ¡ÁջѭËÒà¡Ô´¢Öé¹ ÊÓËÃѺ¢éÍÁÙÅà¾ÔèÁàµÔÁà¡ÕèÂǡѺÇÔ¸Õ¡ÒÃÊÓÃͧ¢éÍÁÙÅáÅФ׹¤èÒÃÕ¨ÔÊ·ÃÕ â»Ã´¤ÅÔ¡·ÕèËÁÒÂàÅ¢º·¤ÇÒÁµèÍ仹Õé à¾×èÍ´Ùº·¤ÇÒÁã¹°Ò¹¤ÇÒÁÃÙé¢Í§ Microsoft::
ÊÓËÃѺ¢éÍÁÙÅà¡ÕèÂǡѺÇÔ¸Õ¡ÒÃá¡éä¢ÃÕ¨ÔÊ·ÃÕ ´ÙËÑÇ¢é͵èÍ仹Õéã¹'ÇÔ¸Õãªé'µÑÇá¡éä¢ÃÕ¨ÔÊ·ÃÕ:

• ¡ÒÃà»ÅÕè¹á»Å§¤ÕÂìáÅФèÒ
• à¾ÔèÁ áÅÐź¢éÍÁÙÅã¹ÃÕ¨ÔÊ·ÃÕ
• á¡é䢢éÍÁÙÅÃÕ¨ÔÊ·ÃÕ

ËÁÒÂà˵Ø:¤Ø³µéͧÊÓÃͧ¤èÒÃÕ¨ÔÊ·ÃÕ¡è͹·Õè¤Ø³á¡éä¢ ¶éҤس¡ÓÅѧàÃÕ¡ãªé Windows NT ËÃ×Í Windows 2000 ¤Ø³µéͧÂѧ»ÃѺ»Ãا¢Í§¤Ø³ Emergency «èÍÁá«Á Disk (ERD)

¶éҤسãªé«Í¿µìáÇÃì¢Í§ä¤Åà͹µì Oracle 8.1.7 »ÃѺà»ÅÕ蹤èҢͧ¤ÕÂìÃÕ¨ÔÊ·ÃÕµèÍ仹Õéà¾×è͵ÃǨÊͺãËéá¹èã¨ÇèÒ ¾Ç¡à¢ÒµÃ§¡Ñº·Õè·ÕèÃкØà»ç¹´Ñ§¹Õé:

·´Êͺ¡ÒõԴµÑé§áÅСÒõÑ駤èҤ͹¿Ô¡¢Í§ COM +/ MTS ʹѺʹعÊÓËÃѺ Oracle

ËÅѧ¨Ò¡·Õè¤Ø³µÔ´µÑé§ áÅСÒõÑ駤èҤ͹¿Ô¡ Oracle ʹѺʹع ¤Ø³µéͧµÃǨÊͺ¡ÒõԴµÑé§ Oracle ¤Ø³ÊÒÁÒöãªéà¤Ã×èͧÁ×͵èÒ§ æ µèÍ仹Õéà¾×è͵ÃǨÊͺ¡ÒáÓ˹´¤èÒ:

• à¤Ã×èͧÁ×ͻѭËÒ oracle
• â»Ãá¡ÃÁ¡Ò÷´Êͺ¢Í§ oracle

ãªé·Ñé§Êͧ Oracle OCI XA interfaces àËÁ×͹¡ÑºÅѡɳРCOM ·Õè +/ MTS ãªé â»Ãá¡ÃÁ Oracle ·´Êͺ¡Ó˹´ÇèÒ ¤Ø³ÊÒÁÒöãªéÊÔè§ÍӹǤÇÒÁÊдǡ Oracle XA ¡ÒÃàª×èÍÁµè͡Ѻ°Ò¹¢éÍÁÙÅ oracle â»Ãá¡ÃÁàËÅèÒ¹ÕéãªéÍÔ¹à·ÍÃìà¿« Oracle ÁҵðҹáÅÐÊÔè§ÍӹǤÇÒÁÊдǡ¢Í§¸ØáÃÃÁ ÍÂèÒãªé COM +/ MTS ËÃ×Í MSDTC ´Ñ§¹Ñé¹ ¤ÇÒÁÅéÁàËÅǢͧâ»Ãá¡ÃÁ¡Ò÷´ÊÍºã´ æ ºè§ªÕéÇèÒ Ãкº Oracle ÍÂÙèäÁè¶Ù¡µéͧµÔ´µÑé§ ËÃ×Í¡ÒáÓ˹´¤èÒ ¶éÒ¡Ò÷´Êͺâ»Ãá¡ÃÁÅéÁàËÅÇ ¤Ø³µéͧµÔ´µÑé§ áÅСÓ˹´¤èÒãËÁè Oracle ËÃ×͵ԴµèͽèÒºÃÔ¡ÒÃʹѺʹع Oracle ÊÓËÃѺ¢éÍÁÙÅà¾ÔèÁàµÔÁ

ËÅѧ¨Ò¡·Õè¤Ø³ä´éÊÁºÙó췴ÊͺàËÅèÒ¹Õé ¤Ø³ÊÒÁÒöãªéâ»Ãá¡ÃÁ»ÃÐÂØ¡µì¢Í§ ¸¹Ò¤ÒõÑÇÍÂèÒ§à¾×èÍ·´Êͺ¡ÒõÑ駤èÒ (ãËé´Ù·ÕèÊèǹ "ãªéá;ÅÔपѹ¢Í§¸¹Ò¤ÒõÑÇÍÂèÒ§à¾×è͵ÃǨÊͺ¡ÒõԴµÑé§ Oracle áÅСÒõÑ駤èҤ͹¿Ô¡") ä´é ¹Í¡¨Ò¡¹Õé¤Ø³ÊÒÁÒöà¢Õ¹â»Ãá¡ÃÁ»ÃÐÂØ¡µì¢Í§µ¹àͧµÑÇÍÂèÒ§à¾×èÍ·´Êͺ¡ÒõÑ駤èÒ

à¤Ã×èͧÁ×ͻѭËÒ oracle

¤Ø³ÊÒÁÒöãªéà¤Ã×èͧÁ×Í Oracle »Ñ­ËÒ¡Ò÷ӵèÍ仹Õé:

• µÃǨÊͺ Oracle ä¤ÅàÍç¹µìáÅÐà«ÔÃì¿àÇÍÃìâ¤Ã§áºº
• ·´Êͺ»Ñ­ËÒà«ÔÃì¿àÇÍÃì Oracle

¡ÒâÍÃѺà¤Ã×èͧÁ×ͻѭËÒ Oracle

á¿éÁµèÍ仹ÕéÊÒÁÒö´ÒǹìâËÅ´ä´é¨Ò¡ÈÙ¹Âì´ÒǹìâËÅ´¢Í§ Microsoft::
ËÒ¡µéͧ¡Ò÷ÃÒº¢éÍÁÙÅà¾ÔèÁàµÔÁà¡ÕèÂǡѺ¡ÒôÒǹìâËÅ´ä¿Åì¡ÒÃʹѺʹع¢Í§äÁâ¤Ã«Í¿·ì â»Ã´¤ÅÔ¡·ÕèËÁÒÂàÅ¢º·¤ÇÒÁµèÍ仹Õéà¾×èÍ´Ùº·¤ÇÒÁã¹ Microsoft Knowledge Base::Microsoft Ê᡹á¿éÁ¹Õéà¾×èÍËÒäÇÃÑÊ Microsoft ãªé«Í¿µìáÇÃìµÃǨÊͺäÇÃÑÊÅèÒÊØ´ ³ Çѹ·ÕèÁÕ¡ÒûÃСÒÈá¿éÁ¹Ñé¹æ á¿éÁ´Ñ§¡ÅèÒǨж١¨Ñ´à¡çºã¹à«ÔÃì¿àÇÍÃìà¾ÔèÁ¡ÒÃÃÑ¡ÉÒ¤ÇÒÁ»ÅÍ´ÀÑ «Ö觪èÇ»éͧ¡Ñ¹¡ÒÃà»ÅÕè¹á»Å§á¿éÁâ´ÂäÁèä´éÃѺ͹حҵ

¤Ø³ÊÒÁÒöãªé¤ÍÁä¾àÅÍÃì c ++¡ÒäÍÁä¾ÅìÃËÑÊáËÅ觷ÕèÁÒ ¶éҤس recompile Á×ͻѭËÒ Oracle àÃÒ¢Íá¹Ð¹ÓãËé ¤Ø³µÑ駪×èÍâ»Ãá¡ÃÁ·Õèà»ç¹¼ÅÅѾ¸ì OracleStress.exe

Ãѹà¤Ã×èͧÁ×ͻѭËÒ Oracle

àÁ×è͵éͧ¡ÒÃÃѹà¤Ã×èͧÁ×ͻѭËÒ Oracle ·ÓµÒÁ¢Ñ鹵͹àËÅèÒ¹Õé

ËÁÒÂà˵Ø:¢Ñ鹵͹µèÍ仹Õé͹ØÁÒ¹ÇèÒ â»Ãá¡ÃÁ¨ÐµÑ駪×èÍ OracleStress.exe

1. µÃǨÊͺãËéá¹èã¨ÇèÒ ¤Ø³ä´éµÔ´µÑ駫ͿµìáÇÃì·Õèá¹Ð¹Ó·Ñé§ËÁ´
2. à»Ô´Ë¹éҨ;ÃéÍÁÃѺ¤ÓÊÑè§
3. ÊÓËÃѺ¢éÍÁÙÅà¾ÔèÁàµÔÁà¡ÕèÂǡѺÇÔ¸Õ¡ÒÃãªéà¤Ã×èͧÁ×Í à»ÅÕè¹â¿Åà´ÍÃì¡Ò÷ӧҹ»Ñ¨¨ØºÑ¹ä»Âѧâ¿Åà´ÍÃì·Õèà»ç¹·ÕèµÑ駢ͧ OracleStress.exe ¾ÔÁ¾ìOracleStress.exe·Õè¾ÃéÍÁÃѺ¤ÓÊÑè§ áÅéÇ¡´ ENTER
   
   ¢éÍÁÙŵèÍ仹Õé»ÃÒ¡¯º¹Ë¹éÒ¨Í:
   
   äÇÂҡóì·Õèãªé¡Ñºà¤Ã×èͧÁ×Í OracleStress:

   OracleStress.exe -S<server> -Q<SQL> [-U<username>] [-P<password>]
   [-T<threads>] [-I<iterations>] -[V<version>] [-N] [-W] [-O]
   [-F<Log File Name>]
   
   -S - Name of oracle server to connect to.
   -Q - SQL statement that each thread will execute.
   -U - Optional. Username. Defaults to "scott".
   -P - Optional. Password. Defaults to "tiger".
   -T - Optional. Number of threads to apply stress with. Defaults to "1".
   -I - Optional. Number of iterations per thread. Defaults to "100".
   -V - Optional. Version. Specifies Oracle version number. Can be one of: 7, 8, 8i, or 9i. Defaults to 8.
   -N - Optional. If specified, disables the use of XA transactions.
   -W - Optional. If specified, disables the display of warning level XA error messages.
   -O - Optional. If specified, open and close connection at each iteration.
   -F - Optional. Log file name. Defaults to "Ostress.txt". 

   µÑÇÍÂèÒ§::

   C:>OracleStress -SMyOracleServer -Q"Insert into Order Values (1, 'My order')" -UMyUserName  
   -PMySpecialPassword -T10 -V8i

   ËÁÒÂà˵Ø:MyOracleServerª×èͧ͢à«ÔÃì¿àÇÍÃì·Õè¤Ø³¡ÓÅѧãªéÍÂÙèMyUserNameª×èͼÙéãªé áÅÐMySpecialPasswordÃËÑʼèÒ¹ÊÓËÃѺà«ÔÃì¿àÇÍÃìä´é
4. àÃÔèÁµé¹á¿éÁ¼ÅÅѾ¸ì·ÕèÊÃéÒ§¢Öé¹à¾×èÍ Ostress.txt ¤Ø³ÊÒÁÒöà»Ô´¡Ñº Microsoft Notepad áÅдٶéÒ¨ÐàÊÃç¨ÊÁºÙóìáÅéÇ´Óà¹Ô¹¡ÒÃ
5. If you receive any trace files that include Oracle errors, contact Oracle Support Services to resolve issues before using the COM+/MTS application.

Tips to use the Oracle Stress tool for stress-testing Oracle Server

Consider the following tips when you use the Oracle Stress tool:

• The SQL statement must be the same as or similar to the most complex queries in your application.
• The number of threads (-T) must be three times the estimated maximum number of concurrent connections that are open in your application. For example, if the maximum number of concurrent open connections in your application is 10, the number of threads must be 30.
• Specify a high number of iterations to keep the number of threads busy to test the reliability and performance of the server.

ËÁÒÂà˵Ø:If the Oracle Stress tool can connect to your Oracle database server without error, it is very likely that COM+/MTS will also work with Oracle. If the Oracle Stress tool reports any errors, you must follow these steps:

1. Document the exact error message that is displayed by the Oracle Stress tool.
2. Examine the Oracle trace file that was produced when you ran the Oracle Stress tool. The Oracle trace information is located in the *.trc file. The Oracle trace file contains extended error information that is extremely helpful in diagnosing problems.
3. Contact Oracle Support Services for more information.

Oracle Test program

After you install and configure Oracle support, you must use the Oracle Test program to validate your Oracle installation. The Oracle Test program is available in two versions, one for Windows NT named TestOracleXAConfig.exe, and another for Windows 2000 named Msdtcora.exe.

Obtain the Oracle Test program for COM+ on Windows 2000

You can obtain the source code and the object code from the Platform SDK or from the Microsoft Download Center.

á¿éÁµèÍ仹ÕéÊÒÁÒö´ÒǹìâËÅ´ä´é¨Ò¡ÈÙ¹Âì´ÒǹìâËÅ´¢Í§ Microsoft::
ËÒ¡µéͧ¡Ò÷ÃÒº¢éÍÁÙÅà¾ÔèÁàµÔÁà¡ÕèÂǡѺ¡ÒôÒǹìâËÅ´ä¿Åì¡ÒÃʹѺʹع¢Í§äÁâ¤Ã«Í¿·ì â»Ã´¤ÅÔ¡·ÕèËÁÒÂàÅ¢º·¤ÇÒÁµèÍ仹Õéà¾×èÍ´Ùº·¤ÇÒÁã¹ Microsoft Knowledge Base::Microsoft Ê᡹á¿éÁ¹Õéà¾×èÍËÒäÇÃÑÊ Microsoft ãªé«Í¿µìáÇÃìµÃǨÊͺäÇÃÑÊÅèÒÊØ´ ³ Çѹ·ÕèÁÕ¡ÒûÃСÒÈá¿éÁ¹Ñé¹æ á¿éÁ´Ñ§¡ÅèÒǨж١¨Ñ´à¡çºã¹à«ÔÃì¿àÇÍÃìà¾ÔèÁ¡ÒÃÃÑ¡ÉÒ¤ÇÒÁ»ÅÍ´ÀÑ «Ö觪èÇ»éͧ¡Ñ¹¡ÒÃà»ÅÕè¹á»Å§á¿éÁâ´ÂäÁèä´éÃѺ͹حҵ

ËÁÒÂà˵Ø:¤Ø³ÊÒÁÒöãªéà¤Ã×èͧÁ×Í TestOracleXAConfig.exe à¾×è͵ÃǨÊͺ¡ÒõÑ駤èҤ͹¿Ô¡¢Í§ Oracle áÅСÒÃá¡é䢻ѭËÒ·Õèà¡ÕèÂÇ¢éͧ¡Ñº Oracle ¶éҤس¡ÓÅѧàÃÕ¡ãªéÃкº»¯ÔºÑµÔ¡Ò÷ÕèÍÂÙè¡è͹˹éÒ Windows 2000 ¶éҤس¡ÓÅѧàÃÕ¡ãªé Windows 2000 ãªéà¤Ã×èͧÁ×Í Msdtcora.exe à¤Ã×èͧÁ×Í Msdtcora.exe ãªéÃÕ¨ÔʵÃÕ¤ÕÂì·ÕèÃкØäÇé㹡ÒûÃѺ»Ãاä¤ÅàÍç¹µì¢Í§ Oracle «Í¿µìáÇÃìÃÕ¨ÔÊ·ÃÕ¤ÕÂì¢Ñé¹ÊÓËÃѺ Windows 2000

¡ÒâÍÃѺâ»Ãá¡ÃÁ Oracle ·´ÊͺÊÓËÃѺ MTS º¹ Windows NT

¡ÒâÍÃѺÃËÑʵ鹷ҧáÅÐÃËÑÊÇѵ¶ØÊÓËÃѺâ»Ãá¡ÃÁ Oracle ·´ÊͺÊÓËÃѺ Oracle 8 áÅз´Êͺ Oracle â»Ãá¡ÃÁÊÓËÃѺ Oracle 7.3 áÇÐä»·Õè䫵ìàÇçºÈÙ¹Âì¡ÅÒ§¡ÒôÒǹìâËÅ´ Microsoft µèÍ仹Õé:ËÁÒÂà˵Ø:â»Ãá¡ÃÁ¨Ð·´Êͺ Oracle ÊÓËÃѺ Oracle 7 ¶Ù¡µÔ´µÑé§â´ÂÍѵâ¹ÁѵÔàÁ×èͤسµÔ´µÑé§ MTS. ¤Ø³ÊÒÁÒöãªé¤ÍÁä¾àÅÍÃì c ++¡ÒäÍÁä¾ÅìÃËÑÊáËÅ觷ÕèÁÒÊÓËÃѺ Oracle 8 ¶éҤس recompile â»Ãá¡ÃÁ Oracle ·´Êͺ àÃÒ¢Íá¹Ð¹ÓãËé ¤Ø³µÑ駪×èÍâ»Ãá¡ÃÁ·Õèà»ç¹¼ÅÅѾ¸ì TestOracleXaConfig.exe

àÃÕ¡ãªéâ»Ãá¡ÃÁ¡Ò÷´Êͺ Oracle

ËÁÒÂà˵Ø:¢Ñ鹵͹µèÍ仹Õé͹ØÁÒ¹ÇèÒ â»Ãá¡ÃÁ¨ÐµÑ駪×èÍ TestOracleXaConfig.exe

1. µÃǨÊͺãËéá¹èã¨ÇèÒ ¤Ø³ä´éµÔ´µÑ駫ͿµìáÇÃì·Õèá¹Ð¹Ó·Ñé§ËÁ´
2. ÊÃéÒ§¡Òà ODBC ª×èÍáËÅ觢éÍÁÙÅ (DSN) ·ÕèÍéÒ§ÍÔ§¶Ö§°Ò¹¢éÍÁÙÅ Oracle ¢Í§¤Ø³ µÃǨÊͺãËéá¹èã¨ÇèÒ DSN ¢Í§¤Ø³ãªéâ»Ãá¡ÃÁ¤Çº¤ØÁ Microsoft Oracle ODBC
3. µÃǨÊͺãËéá¹èã¨ÇèÒ ¤Ø³ä´éà»Ô´ãªé§Ò¹¡ÒÃʹѺʹع Oracle XA
4. ź·Ñé§ËÁ´·ÕèÁÕÍÂÙè Oracle Ê׺¤é¹¡ÅѺá¿éÁ¨Ò¡¤ÍÁ¾ÔÇàµÍÃì·Õè»ÃСͺ´éÇ COM +/ ¤ÍÁâ¾à¹¹µì MTS ·Õèà¢éÒ¶Ö§°Ò¹¢éÍÁÙÅ Oracle àÁ×è͵éͧ¡Ò÷Óàªè¹¹Õé ãªé Windows Explorer à¾×èͤé¹ËÒ áÅÐźá¿éÁ *.trc ·Ñé§ËÁ´ ¶éÒâ»Ãá¡ÃÁ¢Í§ Oracle ·´ÊͺÅéÁàËÅÇ ä¿Åì¡ÒÃÊ׺¤é¹¡ÅѺÊÒÁÒöªèǤس¡Ó˹´áËÅ觷ÕèÁҢͧ»Ñ­ËÒ ¶éҤسźá¿éÁ·Ñé§ËÁ´·ÕèÊ׺¤é¹¡ÅѺ·ÕèÅéÒÊÁÑ ¤Ø³·Óä´é§èÒ¢Öé¹ã¹¡Òäé¹ËÒá¿éÁã´ æ ·ÕèÊ׺¤é¹¡ÅѺ·ÕèÊÃéÒ§¢Öé¹ãËÁè
5. ˹éҨ;ÃéÍÁÃѺ¤ÓÊÑè§ àÃÕ¡ãªéâ»Ãá¡ÃÁ¡Ò÷´Êͺ Oracle (Msdtcora.exe ËÃ×Í TestOracleXaConfig.exe), áÅШҡ¹Ñé¹ ãÊè ID ¼Ùéãªéà«ÔÃì¿àÇÍÃì Oracle ÃËÑʼèÒ¹ áÅÐ service_name »é͹¢éÍÁÙŵèÍ仹ÕéµÑÇÍÂèÒ§àªè¹ ¶éҤسãªéá¿éÁ Msdtcora.exe:
   C:>msdtcora.exe - Uid ¢Í§¼Ùéãªé> -pÃËÑʼèÒ¹:> -sService_Name µÒÁ·ÕèÁÕÍÂÙèã¹á¿éÁ TNS>
   ¤Ø³ÊÒÁÒö»é͹ÃÒÂÅÐàÍÕ´µèÍ仹Õéä´é¶éҤسãªéá¿éÁ TestOracleXaConfig.exe:
   C:>TestOracleXaConfig.exe - Uid ¢Í§¼Ùéãªé> -pÃËÑʼèÒ¹:> -sService_Name µÒÁ·ÕèÁÕÍÂÙèã¹á¿éÁ TNS>

ËÒ¡¤Ø³Ãѹ¡Ò÷´Êͺâ»Ãá¡ÃÁ¡Ñº¾ÒÃÒÁÔàµÍÃì·ÕèäÁèÁÕ â»Ãá¡ÃÁáÊ´§¢éÍÁÙÅÇÔ¸Õãªé·Õè͸ԺÒ¾ÒÃÒÁÔàµÍÃì·Õè¨Óà»ç¹ ·´Êͺâ»Ãá¡ÃÁáÊ´§¢éÍÁÙÅà¡ÕèÂǡѺ¡ÒôÓà¹Ô¹§Ò¹áµèÅÐ Oracle ·Õè´Óà¹Ô¹¡Òà áÅк觪ÕéÇèÒ ¡ÒôÓà¹Ô¹¡ÒÃáµèÅлÃÐʺ¤ÇÒÁÊÓàÃç¨

ËÁÒÂà˵Ø:¶éÒâ»Ãá¡ÃÁ·´Êͺ Oracle ÊÒÁÒöàª×èÍÁµè͡Ѻà«ÔÃì¿àÇÍÃì°Ò¹¢éÍÁÙÅ Oracle ¢Í§¤Ø³â´ÂäÁèÁÕ¢éͼԴ¾ÅÒ´ ¨Ðà»ç¹ä»ä´éÁÒ¡ COM ·Õè +/ MTS ¨ÐÂѧÁÕ¡Ò÷ӧҹ¡Ñº Oracle ¶éÒâ»Ãá¡ÃÁ¢Í§ Oracle ·´ÊͺÃÒ§ҹ¢éͼԴ¾ÅÒ´µèÒ§ æ ·ÓµÒÁ¢Ñ鹵͹àËÅèÒ¹Õé:

1. àÍ¡ÊÒâéͤÇÒÁáÊ´§¢éͼԴ¾ÅÒ´·Õèá¹è¹Í¹·ÕèáÊ´§¢Öé¹ â´Ââ»Ãá¡ÃÁ·´Êͺ Oracle
2. µÃǨÊͺä¿Åì¡ÒÃÊ׺¤é¹¡ÅѺ Oracle ·Õè¶Ù¡ÊÃéÒ§¢Öé¹àÁ×èͤسÃѹâ»Ãá¡ÃÁ·´Êͺ Oracle ¢éÍÁÙÅ¡ÒÃÊ׺¤é¹¡ÅѺ Oracle ¨ÐÍÂÙèã¹á¿éÁ *.trc ä¿Åì¡ÒÃÊ׺¤é¹¡ÅѺ Oracle »ÃСͺ´éÇ¢éͼԴ¾ÅҴẺ¢ÂÒ¢éÍÁÙÅ·Õèà»ç¹»ÃÐ⪹ìÁҡ㹡ÒÃÇÔà¤ÃÒÐËì»Ñ­ËÒ
3. µÔ´µèͽèÒºÃÔ¡ÒÃʹѺʹع Oracle ÊÓËÃѺ¢éÍÁÙÅà¾ÔèÁàµÔÁ

ãªéâ»Ãá¡ÃÁ»ÃÐÂØ¡µì¢Í§ ¸¹Ò¤ÒõÑÇÍÂèÒ§à¾×è͵ÃǨÊͺ¡ÒõԴµÑé§ Oracle áÅСÒáÓ˹´¤èҢͧ¤Ø³

ËÅѧ¨Ò¡·Õè¤Ø³ãªéâ»Ãá¡ÃÁ Oracle ·´Êͺà¾×è͵ÃǨÊͺ¡ÒõԴµÑé§ Oracle áÅСÒáÓ˹´¤èҢͧ¤Ø³ ¤Ø³µéͧãªéâ»Ãá¡ÃÁ»ÃÐÂØ¡µì ¸¹Ò¤ÒõÑÇÍÂèÒ§·Õè¶Ù¡¡Ó˹´ãËé¡Ñº MTS à¾×èÍãËéá¹èã¨ÇèÒ MTS ÊÒÁÒöà¢éÒ¶Ö§°Ò¹¢éÍÁÙÅ Oracle ¢Í§¤Ø³

ãªéâ»Ãá¡ÃÁ»ÃÐÂØ¡µì¢Í§ ¸¹Ò¤ÒõÑÇÍÂèÒ§à¾×è͵ÃǨÊͺ¡ÒÃʹѺʹع¢Í§ Oracle

1. ãªéâ»Ãá¡ÃÁ¡Ò÷´Êͺ Oracle ·ÕèãËéÁÒ â´Â MTS à¾×è͵ÃǨÊͺÇèÒ Ãкº Oracle ¢Í§¤Ø³µÔ´µÑé§ áÅСÓ˹´¤èÒÍÂèÒ§¶Ù¡µéͧ ¶éÒâ»Ãá¡ÃÁ¢Í§ Oracle ·´ÊͺÃÒ§ҹ¢éͼԴ¾ÅÒ´µèÒ§ æ ¤Ø³µéͧá¡é䢻ѭËÒ¡è͹·Õè¤Ø³´Óà¹Ô¹¡ÒõèÍä»
2. º¹à«ÔÃì¿àÇÍÃì°Ò¹¢éÍÁÙÅ Oracle ÊÃéÒ§µÒÃÒ§ ª×è͵ÒÃÒ§ºÑ­ªÕ. µÑÇÍÂèÒ§µèÍ仹ÕéáÊ´§ÇÔ¸Õ¡ÒõÑ駤èÒµÒÃÒ§ºÑ­ªÕ:

   Owner			    scott
   
   Name of Table              Account
   Column 1 Name              AccountNo of type  NUMBER
   Column 2 Name              Balance of type NUMBER 
   

3. àµÔÁ¢éÍÁÙÅã¹µÒÃÒ§ºÑ­ªÕ ÁÕÍÂèÒ§¹éÍÂÊͧá¶Ç µÑÇÍÂèÒ§µèÍ仹ÕéáÊ´§ÇÔ¸Õ¡Ò÷ÕèàµÔÁ¢éÍÁÙÅã¹µÒÃÒ§:

   AccountNo                  Balance
   
        1                      1000
        2                      1000 

4. º¹à«ÔÃì¿àÇÍÃì°Ò¹¢éÍÁÙÅ Oracle ÊÃéÒ§µÒÃÒ§ ª×è͵ÒÃÒ§ãºÃѺ. µÑÇÍÂèÒ§µèÍ仹ÕéáÊ´§ÇÔ¸Õ¡ÒõÑ駤èÒµÒÃÒ§ÃѺ:

   Owner                       scott
   
   Name of Table               Receipt
   Column 1 Name               NextReceipt of type NUMBER 

5. àµÔÁ¢éÍÁÙŵÒÃÒ§¡ÒÃÃѺÊÔ¹¤éÒ·Õè ÁÕÍÂèÒ§¹éÍÂ˹Öè§á¶Ç µÑÇÍÂèÒ§µèÍ仹ÕéáÊ´§ÇÔ¸Õ¡Ò÷ÕèàµÔÁ¢éÍÁÙÅã¹µÒÃÒ§:

   NextReceipt
   1000 

6. ãªéÂÙ·ÔÅÔµÕé¡ÒõÑ駤èҤ͹¿Ô¡ ODBC ¨ÐÊÃéÒ§á¿éÁ DSN ª×èÍá¿éÁ DSNMTSSamplesáÅÐÍѾà´áÅéÇ ´éǵ¹àͧµÃÒá¿éÁ DSN àÁ×è͵éͧ¡ÒÃà¾ÔèÁÃËÑʼèÒ¹¢Í§¼Ùéãªé µÑÇÍÂèÒ§µèÍ仹ÕéáÊ´§ÇÔ¸Õ¡ÒÃà¾ÔèÁÃËÑʼèÒ¹¢Í§¼Ùéãªéä»Âѧá¿éÁ DSN:

   [ODBC]
   DRIVER=Microsoft ODBC for Oracle
   UID=scott
   PWD=mypassword
   ConnectString=myserver
   SERVER=myserver

7. ºÑ¹·Ö¡á¿éÁ DSN áÅÐÃѹä¤ÅàÍç¹µì¢Í§ ¸¹Ò¤ÒõÑÇÍÂèÒ§áÅéÇ

´ÙáÅ Oracle áÅÐ MSDTC

à»ÅÕè¹ ID ¼Ùéãªé MSDTC

Microsoft Distributed Transaction Coordinator (MSDTC) maintains information in the security-enhanced part of the Windows NT registry or the Windows 2000 registry. MSDTC uses this information when it performs recovery with XA-compliant databases, including Oracle. If you change the user ID under which MSDTC runs, you must make sure that MSDTC can still access the information that it previously stored in the security-enhanced part of the registry. If you change the MSDTC user ID, and MSDTC cannot access the information in the security-enhanced registry, you receive the following error message in the Windows NT event log:àÁ×è͵éͧ¡ÒÃá¡é䢻ѭËÒ¹Õé ´Óà¹Ô¹¡ÒôѧµèÍ仹Õé:

1. Stop MSDTC.
2. Change the MSDTC user ID back to its previous value. Alternatively, you can assign a user ID that is a member of the administrative group. To change the user ID and password, follow these steps:
   1. In Control Panel, start theºÃÔ¡ÒÃprogram.
   2. Double-click the entry forMSDTCáÅÐà»ÅÕè¹á»Å§áÅéÇ ¹Õélog on as¤èÒ
3. Restart MSDTC.

Configure Oracle to support many connections

If you want to create more than several dozen connections to an Oracle database, you must configure the Oracle server to support additional database connections. If you do not do this, one or more of the following problems may occur:

• Failures on SQLConnect calls.
• Failures to enlist on the calling object's transaction that may cause one or more of the following errors in the Oracle trace file:
  • Too many sessions.
  • TNS server failed to locate the server name.
  • Too many distributed transactions.
• Timeouts may occur while waiting for database locks. This problem is likely to occur if the configured number of locks is not sufficient for the number of active transactions.
• Record collision because of locks that are held by in-doubt transactions.

If you experience one or more of these problems, consider increasing the following Oracle server configuration parameters:

Set the session values

The value for sessions must typically be three times the total number of database connections that you expect your applications to make.

Configure the QUEUESIZE parameter

If the QUEUESIZE parameter for the Oracle Listener process is not sufficient, the Listener process sometimes falls behind and rejects database open requests. This problem occurs if the Listener process receives too many connection requests and its queue overflows. A client that encounters this error reports the following error message:The client log files or trace files display the following error message:àÁ×è͵éͧ¡ÒÃá¡é䢻ѭËÒ¹Õé ´Óà¹Ô¹¡ÒôѧµèÍ仹Õé:

1. Stop the Oracle Listener process on the system that contains the Oracle database server.
2. Increase the QUEUESIZE parameter in the Listener.ora file, the Tnsnet.ora file, or the Names.ora file on the Oracle database server system.
   
   ËÁÒÂà˵Ø:Set the value of QUEUESIZE parameter based on the number of simultaneous, or almost simultaneous, connections that you anticipate. We recommend that you select a generous value for the QUEUESIZE parameter because the Oracle 7.3 system typically opens three database sessions and Oracle 8 or Oracle 8i opens two database sessions for each transactional database connection that your application opens. Therefore, the Oracle Listener queue can become full and then overflow. For example, to handle 100 requests, change the Listener.ora file as follows:

   QUEUESIZE = 100 
   
   

3. Restart the Oracle Listener process.

Known limitations of COM+/MTS support for Oracle

COM+/MTS and Oracle Services for MTS

ºÃÔ¡Òâͧ oracle ÊÓËÃѺ MTS äÁè¨Óà»ç¹ÊÓËÃѺ COM +/ MTS áÍ»¾ÅÔपѹ¶éҤسãªéµÑÇãËéºÃÔ¡Òà Microsoft OLEDB/ODBC ÍÂèÒµÔ´µÑ駺ÃÔ¡Òà Oracle ÊÓËÃѺ MTS ã¹¢³Ð·Õè¤Ø³µÔ´µÑé§ä¤ÅàÍç¹µì 8i Oracle àÃÒäÁèʹѺʹع¡ÒáÓ˹´¤èÒ¹Õé áÅÐâ»Ãá¡ÃÁ»ÃÐÂØ¡µìÍÒ¨äÁè·Ó§Ò¹ÍÂèÒ§¶Ù¡µéͧËÒ¡¤Ø³µÔ´µÑ駺ÃÔ¡Òà Oracle ÊÓËÃѺ MTS ¡Ñº¼ÙéãËéºÃÔ¡Òà Microsoft ODBC/OLE DB µÔ´µèͽèÒÂʹѺʹع¢Í§ Oracle ÊÓËÃѺ»Ñ­ËÒµèÒ§ æ ·Õèà¡ÕèÂÇ¢éͧ¡Ñº¡ÒÃãªéºÃÔ¡Òà Oracle ÊÓËÃѺ MTS.

oracle 8i áÅиØáÃÃÁ¢Í§ OLE

oracle 8i ʹѺʹع¸ØáÃÃÁ¢Í§ OLE ¤Ø³ÅѡɳйÕéµéͧãªéâ»Ãá¡ÃÁ¤Çº¤ØÁ Oracle ODBC µÔ´µèÍ Oracle ÊÓËÃѺ¢éÍÁÙÅà¡ÕèÂǡѺ¡ÒáÓ˹´¤èÒ·Õèá¹Ð¹ÓãËéãªé¤Ø³ÅѡɳйÕé ¡ÒûÃѺ»Ãا·Õè¨Óà»ç¹ áÅлѭËÒµèÒ§ æ ·Õèà¡ÕèÂÇ¢éͧ

â»Ãá¡ÃÁ¤Çº¤ØÁ ODBC Microsoft Oracle áÅÐ Oracle 8

ã¹¢³Ð¹Õé â»Ãá¡ÃÁ¤Çº¤ØÁ Microsoft Oracle ODBC (Msorcl32.dll) äÁè·Ó§Ò¹¡Ñº«Í¿µìáÇÃì¢Í§ä¤ÅàÍç¹µì Compaq Alpha Oracle 8 ¢éͨӡѴ¹ÕéÍÒ¨ÁÕ¡ÒÃà»ÅÕè¹á»Å§ã¹ÃØè¹·Õèã¹Í¹Ò¤µ

Ociw32.dll oracle corrupts MSDTC ÃÐËÇèÒ§¡ÒÃàÃÔèÁµé¹

»Ñ­ËÒ¹Õéà¡Ô´¢Öé¹à¹×èͧ¨Ò¡ MTS áÅÐ MSDTC µéͧâËÅ´á¿éÁ Ociw32.dll Oracle à¸Ã´ËÅÑ¡¢Í§µ¹àͧ¡è͹·Õè¨Ð·Ó¡ÒôÓà¹Ô¹¡ÒÃã´ æ ·ÕèÍÒ¨à¢éÒ¶Ö§°Ò¹¢éÍÁÙÅ oracle MTS µéͧâËÅ´á¿éÁ Mtxoci.dll à¹×èͧ¨Ò¡â»Ãá¡ÃÁ»ÃÐÂØ¡µì¢Í§¤Ø³ÍÒ¨µéͧà»Ô´¡ÒÃàª×èÍÁµè͡Ѻ°Ò¹¢éÍÁÙÅ oracle msdtc µéͧâËÅ´á¿éÁ Mtxoci.dll à¹×èͧ¨Ò¡ÍÒ¨ÁÕ¡ÒôÓà¹Ô¹¡ÒáÙé¤×¹¢éÍÁÙŢͧ°Ò¹¢éÍÁÙÅ Oracle à¹×èͧ¨Ò¡ MTS äÁè predict ÇèÒ â»Ãá¡ÃÁ»ÃÐÂØ¡µì¢Í§¤Ø³ÍÒ¨µéͧ¡ÒÃãªé°Ò¹¢éÍÁÙÅ oracle ¹Ñé¹àÊÁÍâËÅ´á¿éÁ Ociw32.dll Ociw32.dll á¿éÁµéͧâËÅ´ unconditionally 㹡ÒÃàµÃÕÂÁãªé§Ò¹à¹×èͧ¨Ò¡¡ÒÃÇÔ¸Õ¡Ò÷ÕèÁÕ¡ÒÃãªé§Ò¹ Oracle º¹ Oracle Windows NT ¡ÒÃãªé§Ò¹º¹ Windows NT µÃǨÊͺ attaches à¸Ã´·Ñé§ËÁ´ oracle insists 㹡ÒÃÁͧàËç¹·Ñé§ËÁ´·ÕèÁÕàËç¹à¸Ã´·ÕèṺ áÅÐÂÍÁÃѺ¡ÒÃÃéͧ¢Íà»Ô´°Ò¹¢éÍÁÙŨҡà¸Ã´·Õèà¸Ã´·ÕèàÃÔèÁµé¹á¹º´Ñ§¡ÅèÒÇà·èÒ¹Ñé¹

àÁ×è͵éͧ¡ÒÃá¡é䢻ѭËÒ¹Õé ¤Ø³ÊÒÁÒöà»ÅÕ蹪×èÍ ËÃ×Íź Microsoft Oracle ʹѺʹع.dll á¿éÁ°Ò¹¢éÍÁÙÅ (Mtxoci.dll) ¶éҤسãªé Oracle MTS ËÃ×Í MSDTC äÁèà¤Â àÁ×èÍ MTS áÅÐ MSDTC äÁèàÃÔèÁ ãËé¤é¹ËÒ áÅÐâËÅ´á¿éÁ Mtxoci.dll áÅéÇ á¿éÁ Mtxoci.dll âËÅ´á¿éÁ Ociw32.dll Oracle áÅéÇ MTS áÅÐ MSDTC µèÍ¡Ò÷ӧҹÍÂèÒ§¶Ù¡µéͧ¶éҾǡà¢ÒäÁèÊÒÁÒöËÒµÓá˹觷ÕèµÑé§ áÅÐâËÅ´á¿éÁ Mtxoci.dll ÍÂèÒ§äáçµÒÁ àËÅèÒ¹Ñé¹äÁèÊÒÁÒöà¢éÒ¶Ö§ ËÃ×Í¡Ùé¤×¹°Ò¹¢éÍÁÙÅ oracle ¶éÒá¿éÁ.dll ¹ÕéäÁèÁÕÍÂÙè

ËÁÒÂà˵Ø:µÃǨÊͺãËéá¹èã¨ÇèÒ ¤Ø³äÁèÁÕËÅÒÂÊÓà¹Ò¢Í§á¿éÁ Ociw32.dll º¹ COM ¢Í§ +/ MTS Ãкº ¶éҤسÁÕËÅÒÂÊÓà¹Ò á¿éÁ.dll ÃØè¹·ÕèäÁè¶Ù¡µéͧÍÒ¨ÊÒÁÒöâËÅ´ áÅзÓãËéà¡Ô´ÅѡɳСÒ÷ӧҹ·ÕèäÁè¤Ò´¤Ô´

Microsoft ¨ÐãËé¢éÍÁÙŵԴµèͧ͢ºÃÔÉÑ·Í×è¹ à¾×èͪèÇÂãËé¤Ø³ÊÒÁÒö¢ÍÃѺ¡ÒÃʹѺʹع·Ò§à·¤¹Ô¤ä´é ¢éÍÁÙŵԴµè͹ÕéÍÒ¨à»ÅÕè¹á»Å§â´ÂäÁèµéͧá¨é§ãËé·ÃÒºÅèǧ˹éÒ Microsoft äÁèÃѺ»ÃСѹ¤ÇÒÁ¶Ù¡µéͧ¢Í§¢éÍÁÙÅ¡ÒõԴµè͡ѺºÃÔÉÑ·Í×è¹æ àËÅèÒ¹Õé

¼ÅÔµÀѳ±ì¢Í§ºØ¤¤Å·ÕèÊÒÁ·Õè¡ÅèÒǶ֧㹺·¤ÇÒÁ¹Õé ¼ÅÔµ¢Öé¹â´ÂºÃÔÉÑ··ÕèäÁè¢Öé¹ÍÂÙè¡Ñº Microsoft Microsoft äÁèÁÕ¡ÒÃÃѺ»ÃСѹã´æ äÁèÇèÒâ´Â¹ÑÂËÃ×ÍÃٻẺÍ×è¹ã´ à¡ÕèÂǡѺ»ÃÐÊÔ·¸ÔÀÒ¾ËÃ×ͤÇÒÁàª×èͶ×Íä´é¢Í§¼ÅÔµÀѳ±ìàËÅèÒ¹Õé