×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

MTS+Oracle: cannot connect to transaction manager or t.m. unavailable

MTS+Oracle: cannot connect to transaction manager or t.m. unavailable

MTS+Oracle: cannot connect to transaction manager or t.m. unavailable

(OP)
I get the following error message:
  Run time error -214768229 (8004d01b):
  Cannot connect to the transaction manager or the transaction manager is unavailable.

My set up is:
  Windows NT4 SP6a
  MTS 2.0
  Oracle client 8.1.7.1.5
  Oracle database 8.0.6.0.0
  MS ODBC driver 2.573.7326
  MDAC 2.6 SP1

My efforts until now were:
I've followed the Microsoft Q193893 completely, so XA support is installed in Oracle (v$xatrans$ + dba_pending_transactions views).

When I examine the cli.trc file that Oracle produces, I can see that a connection to the database is made by mtx.exe, but after that not much more seems to happen.

I've enabled the MtxOci tracing, and trace files are produced, but they remain empty.

I've adapted and compiled the TestOracleXAConfig utility for oracle 8i, and it completes successfully.

I would be grateful for any tip. Also if it is not a solution, but could help me find the cause of this problem.

Anne van der Bom

RE: MTS+Oracle: cannot connect to transaction manager or t.m. unavailable

(OP)
Replying to my own posting just to let anyone interested know that I have solved the problem. It was a question of permissions.

Each package registered in MTS has a 'Identity' (in MMC go to the package in question, right-click, select 'Properties', tab 'Identity'. The user that is listed there must have rights to the ORA_HOME directory to be able to load the dll's and must have full control to the registry keys:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Transaction Server\Local Computer\My Computer
    HKEY_CLASSES_ROOT\CID
This information is described in the MS kb article number Q286382.

This is also the exact reason that my (modified) TestOracleXAConfig program ran without a hitch: I tested it under user administrator, who of course has all permissions on the entire server!

RE: MTS+Oracle: cannot connect to transaction manager or t.m. unavailable

(OP)
Thanks for your posting, I've also similar problem
with the exact(almost)configuration.

But the MS KB article Q286382 doesn't give enough information about how/what keys I should include in the
registry

Can you please let me know, how to proceed from here.
what should I ensure in the following registry entry.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Transaction Server\Local Computer\My Computer

And also, is SQL*NET installation mandatory?

Are there any issues with <%@transaction=required%>
and ADOS & MTS.

Appreciate your help on this.
Mallik
mallik3105@yahoo.com

RE: MTS+Oracle: cannot connect to transaction manager or t.m. unavailable

Hi,
I am using MTS and Oracle.
My set up is,
Windows NT4 SP6a
  MTS 2.0
  Oracle 8.1.5.
When I try to test my oracle configuration..
when the follwing command executes...
'opening xa_open_entry....

I get 'memory could not be read... read of address 0x00000
error'.

can any one tell me how to configure oracle for MTS?

Regards,
Kanmani.

RE: MTS+Oracle: cannot connect to transaction manager or t.m. unavailable

(OP)
Are you running this testoraclexaconfig.exe ?
Try compile this program on your box and execute it again.
It may help ! because it may have some dependencies with Oracle client (depeding upon how you got this program.. !) Anyway, I guess you need not worry even though that doesn't work fine.

Did you try with Oraclestress.exe program,
(think, it comes with mts2.0)

And what does your registry key values look like for this entry ??
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Transaction Server\Local Computer\My Computer
This is very critical for MTS-Oracle to work. Make sure, it points to the right dlls. It varies with the Oracle client version. For 8.1.7 the above registry entry should read like this..
oraclexalib = oraclient8.dll
oraclesqllib = orasql8.dll
oacleocilib = oci.dll

If you are not able to find the proper entries for oracle client 8.1.5 then upgrade it to 8.1.6 or 8.1.7. I implemented with 8.1.6 very recently.


HTH lil bit
mallik3105@yahoo.com


RE: MTS+Oracle: cannot connect to transaction manager or t.m. unavailable

Greetings everyone,

Just to make it sure, can anyone confirm that if your Oracle DB is on a Unix system, you can only use client ver 7.3.3 and NOT 8 ?

Am getting a bit confuse about that...

RE: MTS+Oracle: cannot connect to transaction manager or t.m. unavailable

I have a similar problem and getting this error.
Technicla details:
Windows2000 when the DLL has the transaction mode required or requires new and if that DLL access database i am getting this error.
if i set the transaction mode to not an MTS object or only Supports it works fine

Cannot connect to the transaction manager or the transaction manager is unavailable.-2147168229

Hope someone have solved this problem

Avinash

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close