Configuring Ora9i for .NET Data Provider for Oracle

[Bob Adler]

How do v9.2.0.3 Oracle servers and clients need to be
configured to work with the v1.1 .NET Data Provider for
Oracle?

I've seen postings in this newsgroup saying the Oracle
server must be set up to run in Multi-Threaded Server
mode, rather than Dedicated Server mode, and that Oracle
Services for MTS (provided by Oracle) must be running,
rather than MTXOCI. Unfortunately, I've been unable to
find confirmation in any .NET documentation.

Also, in order for Ora8i XA and MS DTC to properly
interact the following HKLM>Sware>MS>MSDTC>MTXOCI Registry
parameters had to list the correct *.dll files:
OracleXaLib = oraclient8.dll
OracleSqlLib = orasql8.dll
OracleOciLib = oci.dll

Is there a similar set of Registry changes that need to be
made in order for Ora9i and MS DTC to properly interact?

Can someone answer these questions or point me to the
relevant documention?

TIA

 

[Niall Litchfield]

How do v9.2.0.3 Oracle servers and clients need to be
configured to work with the v1.1 .NET Data Provider for
Oracle?

I've seen postings in this newsgroup saying the Oracle
server must be set up to run in Multi-Threaded Server
mode, rather than Dedicated Server mode, and that Oracle
Services for MTS (provided by Oracle) must be running,
rather than MTXOCI. Unfortunately, I've been unable to
find confirmation in any .NET documentation.

Assuming that you wish to use MSDTC for transaction co-ordination then yes,
you will need Oracle Services for MTS running. To do this you need to
install oracle services for MTS on the server on which the transactions will
be registered. You also need Oracle Patch Set 2428356.

Oracle Multi-Threaded Server is a connection pooling mechanism supplied by
Oracle. In general I wouldn't expect to use it in conjunction with MSDTC,
which is also likely to pool connections, or when the number of user
processes on the oracle server exceeds somewhere between 250 and 500
simultaneous connections.

I think what I am saying is install ORAMTS, Install the patchset and see
what happens (I'd expect it to work).


--
Niall Litchfield
Oracle DBA
Audit Commission UK

Also, in order for Ora8i XA and MS DTC to properly
interact the following HKLM>Sware>MS>MSDTC>MTXOCI Registry
parameters had to list the correct *.dll files:
OracleXaLib = oraclient8.dll
OracleSqlLib = orasql8.dll
OracleOciLib = oci.dll

Is there a similar set of Registry changes that need to be
made in order for Ora9i and MS DTC to properly interact?

I don't believe so.