hi,
When I tested tuxedo global transaction I met a problem, as following steps.
1. Creating service that do something like updating db simply, which connected oracle using XA.
2. Call the service by client.c. The returning value is correct.
3. Shutdown and start up Oracle. (I want to test whether db connection is established successfully.)
4. Recall the service. The result is OK (new data is updated in DB),
But there is some warning in ULOG.
CMDTUX_CAT:423: WARN: One-phase commit - xa_commit returned -7
Meanwhile i got error log xa_NULL.trc*. some message as below.
ORACLE XA: Version 11.2.0.3.0. RM name = 'Oracle_XA'.
093302.32114.0:
ORA-03113: end-of-file on communication channel
Process ID: 32648
Session ID: 13 Serial number: 29
ORACLE XA: Version 11.2.0.3.0. RM name = 'Oracle_XA'.
093302.32114.0:
xaosterr: OCITransStart rtn 3113
ORACLE XA: Version 11.2.0.3.0. RM name = 'Oracle_XA'.
093302.32100.0:
OCITransCommit return code: -1
093302.32100.0:
ORA-03113: end-of-file on communication channel
Process ID: 32652
Session ID: 18 Serial number: 195
ORACLE XA: Version 11.2.0.3.0. RM name = 'Oracle_XA'.
093302.32100.0:
xaocommit: rtn -7
5. Finally, Then I called the service again, The warning is disappear and everything started working fine.
Attach a part of content in ubbconfig
...
*GROUPS
GROUP1
LMID=simple
GRPNO=1
OPENINFO="Oracle_XA:Oracle_XA+Acc=P/scott/tiger+SqlNet=ORCL+SesTm=600+MaxCur=5+LogDir=."
TMSNAME="TMS_ORA"
TMSCOUNT=2
...
*SERVERS
xa_test_sel
SRVGRP=GROUP1
SRVID=5
CLOPT="-A"
xa_test_upd
SRVGRP=GROUP1
SRVID=6
CLOPT="-A"
...
I am a new user, I don't know why the error log is appeared.
Could you help me to explain the case of above and fix it?
Thanks a lot.
Edited by: 934297 on May 15, 2012 7:59 AM
--友情转载