Integration

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