TUXEDO XA ÷
1޸$TUXDIR/udataobj/RM
$ cat RM
TUXEDO/D:tuxd_switch:-lrms -lfs
TUXEDO/SQL:tuxsql_switch:-lsql -lusort -lrms -lfs
NONE:tmnull_switch: 
TUXEDO/QM:tuxq_switch:-lqm -ltmib
# INFORMIX-Online 5
INFORMIX-OnLine:infx_xa_switch:${INFORMIXDIR}/lib/esql/libinfxxa.a -lx
# INFORMIX-Online 6
#INFORMIX-OnLine:infx_xa_switch:${INFORMIXDIR}/lib/esql/libinfxxa.a ${INFORMIXDIR}/lib/esql/libsql.a ${INFORMIXDIR}/lib/libasf.a ${INFORMIXDIR}/lib/netlib.a ${INFORMIXDIR}/lib/esql/libgen.a ${INFORMIXDIR}/lib/esql/libos.a -lsocket -lm
#ident	"@(#) tuxedo/cmdtux/RM	$Revision: 1.1 $"
# ORACLE 7.3.2
#Oracle_XA:xaosw:-L$ORACLE_HOME/lib  -lxa -lsql -lsqlnet -lncr -lsqlnet -lclient -lcommon -lgeneric $ORACLE_HOME/rdbms/lib/libstublm.a  -lsqlnet -lncr -lsqlnet -lclient -lcommon -lgeneric $ORACLE_HOME/rdbms/lib/libstublm.a    -lepc -lnlsrtl3 -lc3v6 -lcore3 -lnlsrtl3 -lcore3 -lnlsrtl3     `cat $ORACLE_HOME/rdbms/lib/sysliblist`    -lm
Oracle_XA:xaosw:-L$ORACLE_HOME/lib -lxa -lsql -lsqlnet -lncr -lsqlnet -lclient -lcommon -lgeneric -lsqlnet -lncr -lsqlnet -lclient -lcommon -lgeneric   -lepc -lepc -lepcpt -lnlsrtl3 -lc3v6 -lcore3 -lnlsrtl3 -lcore3 -lnlsrtl3     `cat /usr/app/oracle/product/7.3.4/rdbms/lib/sysliblist`    -lm `cat /usr/app/oracle/product/7.3.4/rdbms/lib/sysliblist` -lm
# ORACLE 8
#Oracle_XA:xaosw:-L${ORACLE_HOME}/lib -lclient -lclntsh -lsql -lncr -lcommon -lgeneric -lepc -lnlsrtl3 -lcore4 -lnlsrtl3 -lc -lm -lpthread -loish scorept.o sscoreed.o -L${ORACLE_HOME}/rdbms/lib kpudfo.o 
#ORACLE 8.0.5
Oracle_XA:xaosw:-L${ORACLE_HOME}/lib -lclntsh

2TMS FOR ORACLE
$ buildtms -r Oracle_XA -o /${TUXDIR}/bin/TMS_ORA
⣺TMS_ORAʱһѷδ
RMòȷȷҵӿ

3TLOG豸
ubbcfgļ*MACHINSм:
TLOGDEVICE="/usr/tuxedo/TLOG"
TLOGNAME=TLOG
TLOGSIZE=300
TLOG
$tmadmin -c 
> crdl -b400 -z/usr/tuxedo/TLOG

4ubbcfg ļ*GROUPSм
DEFAULT:
	TMSNAME=TMS_ORA
	TMSCOUNT=2
	OPENINFO="Oracle_XA:Oracle_XA+Acc=P/db_username/db_passwd+Sestm=60+SQLNET=aaa+LogDir=."
ڶOracle_XARMж
acc=P/ݿû/ݿ
SQLNET=db clientӴ

5ubbcfg
tmloadcf ubbcfg

6ڱserverʱ-r Oracle_XAѡ
buildserver -s SERVICENAME -f a.o -f b.o -o SERVER_EXE_FILENAME -r Oracle_XA

7$TUXDIR/lib/libsql* $/TUXDIR/include/sqlca.h sqlda.h sqlcode.h

8tmboot -y
ʱTMS_ORAǷɹ
⣺ORACLE 7.3.4´
ULOGļм¼
xaofetch:XAER_RMERR ... sql_stmt=SELECT .. FROM sys.v$xatrans table or view does not exist


ORACLEĿ¼²Xaview.sqlļ
sqlplusִxaview.sqlļv$xatrans$v$pending_xatrans$ͼ
ΪǰݿûselectȨ
grant select on v$xatrans$ to bill
grant select on v$pending_xatrans to bill


