Connection Problem to Oracle V7.15 when using XA
Date: Wed, 11 May 1994 19:03:30 GMT
Message-ID: <CpnJLv.ECs_at_undergrad.math.uwaterloo.ca>
I am using Oracle V7.15 on an RS/6000 running AIX3.2.5. I have an OCI application that uses the Oracle XA interface with an Encina transaction manager My XA open string is defined as follows:
"Oracle_XA+Acc=P/userid/passwd+SesTm=0+LogDir=/home/encina/log/Oracle"
I am sometimes successful at making a connection and executing application queries. However, during the course of a transaction, I get a spurious break in the connection resulting in a global rollback. My xa_*.trc file produces the following diagnostics:
>> 142547.50625.0:
>> ORACLE XA: Version 1.0.3.0.0 - Production. RM name = 'Oracle_XA'.
>>
>> 142547.50625.0:
>> xaoend: XA_RBROLLBACK; upisdt rtn ORA-3114.
>>
>> 142548.50625.0:
>> ORA-03114: not connected to ORACLE
>>
>>
>> 142548.50625.0:
>> xaoend: upisdl rtn ORA-3114.
>>
>> 142548.50625.0:
>> xaoswitch: XAER_RMERR; upixaxs rtn ORA-3114.
>>
>> 142548.50625.0:
>> ORA-03114: not connected to ORACLE
>>
>>
>> 142548.50625.0:
>> xaorollback: xaoswitch rtn -3.
Why am I losing connections to the listener? I did not configure this instance of Oracle myself and have no clue about what to do? Can anyone out there help me? I suspect that it is a configuration problem.
Regards,
Dex
--- \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ Dexter P. Bradshaw \ Internet: dpbradsh_at_bluebox.uwaterloo.ca Phone (Home): (519) 884-1855 \ Office: DC2306B, University of Waterloo (Off): (519) 885-4783 (x4783) \ Post: 200 University Av W., Fax : (519) 885-1208 \ Waterloo, Ont N2L 3G1 \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ ------------------------------------------------------------------------------Received on Wed May 11 1994 - 21:03:30 CEST