Tuxedo Application Server Connection To Oracle Database Unstable Following Upgrade From Oracle Database 11.2.0.4 To Oracle Database 12.1.0.2.0 (Doc ID 2109561.1)

Last updated on MAY 26, 2017

Applies to:

Oracle Tuxedo - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

Upgrade From Oracle Database 11.2.0.4 To Oracle Database 12.1.0.2.0. Customer application servers for executing SQL statements, compiled with database client and Tuxedo libraries, regularly lose their connections to the Oracle database.

 

Oracle Tuxedo side ULOG contains:

062607.tuxmach1!mysqlsvr.24215.976627168.0: LIBTUX_CAT:262: INFO: Standard main starting
090029.tuxmach1!mysqlsvr.24215.976627168.0: gtrid x0 x56b87afb x13814: LIBTUX_CAT:1387: ERROR: xa_commit returned XAER_RMFAIL
090029.tuxmach1!mysqlsvr.24215.976627168.0: LIBTUX_CAT:1393: WARN: tpreturn called with TPEXIT
....
090057.tuxmach1!mysqlsvr.27346.2876245472.0: 02-08-2016: Tuxedo Version 12.1.1.0, 64-bit
090057.tuxmach1!mysqlsvr.27346.2876245472.0: LIBTUX_CAT:262: INFO: Standard main starting
093825.tuxmach1!mysqlsvr.27346.2876245472.0: gtrid x0 x56b87afb x2a1a1: LIBTUX_CAT:1387: ERROR: xa_commit returned XAER_RMFAIL
093826.tuxmach1!mysqlsvr.27346.2876245472.0: LIBTUX_CAT:1393: WARN: tpreturn called with TPEXIT
...
093830.tuxmach1!mysqlsvr.18278.2880488928.0: 02-08-2016: Tuxedo Version 12.1.1.0, 64-bit
093830.tuxmach1!mysqlsvr.18278.2880488928.0: LIBTUX_CAT:262: INFO: Standard main starting
133723.tuxmach1!mysqlsvr.18278.2880488928.0: gtrid x0 x56b87afb x1bb3e0: LIBTUX_CAT:1387: ERROR: xa_commit returned XAER_RMFAI

 

Oracle Database side XA trace log contains:

090029.24215.0:
xaocommit: rtn -7
...
093825.27346.0:
xaocommit: rtn -7
...
133723.18278.0:
xaocommit: rtn -7

  

Changes

 Upgrade From Oracle Database 11.2.0.4 To Oracle Database 12.1.0.2.0

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms