Tuxedo 11gR1PS1 (11.1.1.2.0): In MRM (Multiple Resources Manager) Group, The Oracle DB TMS Server (TMS_ORA) Fails To Re-establish Connection If Oracle DB RM Is Not The First Group (Doc ID 1608695.1)

Last updated on NOVEMBER 04, 2016

Applies to:

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

Goal

When Tuxedo MRM GROUP (several RM in the same group, feature introduce in Tuxedo 11gR1PS1), if the Oracle database is not the first RM in group then xa_start() is failing for any call after Oracle restart.

 

Here after sample of ubbconfig with two MRM groups (one group with Oracle DB as first RM and another not):

 


...

*GROUP
ORA_FIRSTRM_GRP                    GRPNO=10
                                   LMID=myLmid
                                   MRM=Y
                                   TMSCOUNT=3
                                   TMS_NAME=TMS_ORA
                                   OPENINFO="yourOraDBEntryInRMFile:Oracle_XA+ACC=P/dbAccountName/dbAccountPassword+SesTM=3600+LogDir=.+DbgFl=0x7+NoLocal=T+SQLNet=dbToConnect+DB=ORA_FIRST_RM_"
                       
ORA_NOT_FIRSTRM_GRP                GRPNO=50
                                   LMID=myLmid
                                   MRM=Y
                                   TMSCOUNT=3
                                   TMS_NAME=TMS_QM
                                   OPENINFO="TUXEDO/QM:/your/QSpace/Full/Path:yourQSpace_1"
...

*RMS
SECOND_RM_ORA_FIRSTRM_GRP          RMID=1
                                   SRVGRP=ORA_FIRSTRM_GRP
                                   TMSCOUNT=3
                                   TMS_NAME=TMS_QM
                                   OPENINFO="TUXEDO/QM:/your/QSpace/Full/Path:yourQSpace_2"

SECOND_RM_ORA_NOT_FIRSTRM_GRP      RMID=2
                                   SRVGRP=ORA_NOT_FIRSTRM_GRP
                                   TMSCOUNT=3
                                   TMS_NAME=TMS_ORA
                                   OPENINFO="yourOraDBEntryInRMFile:Oracle_XA+ACC=P/dbAccountName/dbAccountPassword+SesTM=3600+LogDir=.+DbgFl=0x7+NoLocal=T+SQLNet=dbToConnect+DB=ORA_NOT_FIRST_RM_"

...

 

 With this configuration, the Oracle DB XA trace file will be call:

 

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