TUX - Error ORA-00604 and ORA-01756 While Oracle TMS Startup On Red Hat 3.0 (Doc ID 776213.1)

Last updated on DECEMBER 05, 2016

Applies to:

Oracle Tuxedo - Version 8.1 and later
Information in this document applies to any platform.
Information in this document applies to any platform
***Checked for relevance on 02-07-2013***



Goal

ENVIRONMENT:
Red Hat 3.0
Tuxedo 8.1 (but should occurs on all TUXEDO release supported on Red Hat 3.0)
Oracle 9.2.0.X

ISSUE:
In a XA context, the Oracle TMs startup fails with error (in ULOG) :

100109.winompdev!TMS_ORA.11776.3076470336.0: LIBTUX_CAT:262: INFO: Standard main starting
100109.winompdev!TMS_ORA.11776.3076470336.0: LIBTUX_CAT:466: ERROR: tpopen TPERMERR xa_open returned XAER_RMERR
100109.winompdev!TMS_ORA.11776.3076470336.0: LIBTUX_CAT:250: ERROR: tpsvrinit() failed
100109.winompdev!TMS_ORA.11776.3076470336.0: LIBTUX_CAT:300: ERROR: _tlog_open: _gp_tblopen: UNIX sys call error -
2
100109.winompdev!tmboot.11774.3076427904.-2: 01-13-2005: Tuxedo Version 8.1, 32-bit
100109.winompdev!tmboot.11774.3076427904.-2: CMDTUX_CAT:825: ERROR: Process TMS_ORA at WINOMP failed with /T
tperrno (TPERMERR - resource manage



Then in xa_NULL.trc log (generated by specifying DbgFl=0x7 in the OPENINFO string) you can see Oracle errors 00604 and 01754 :


ORACLE XA: Version 9.2.0.1.0. RM name = 'Oracle_XA'.


100109.11776.0:
xaoopen: xa_info=Oracle_XA+Acc=P/winomp/winomp+SesTm=36+LogDir=/home/winomp/appli/log+DbgFl=0x7,rmid=0,flags=0x0


100109.11776.0:
xaolgn_help: version#: 153093376 banner: Oracle9i Enterprise Edition Release 9.2.0.5.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production



100109.11776.0:
ORA-00604: error occurred at recursive SQL level 1
ORA-01756: quoted string not properly terminated



100109.11776.0:
xaolgn: XAER_RMERR; logon failed. ORA-604.


100109.11776.0:
xaoopen: return -3

ORACLE XA: Version 9.2.0.1.0. RM name = 'Oracle_XA'.

 

 

Solution

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