tux_ora_xa.txt

tuxede下面的编程

rm -f will cancel the prompt
ksh
csh: cannot build. can use ksh
CC=gcc

 
TUXEDO 与 ORACLE 8.0.5.0.0 的 XA 连接步骤

ORACLE 的准备:

1. connect internal(password :oracle(default))
   under sqlplus:
	connect internal/oracle
   执行 $ORACLE_HOME/rdbms/admin/xaview.sql
   in sqlplus:@$ORACLE_HOME/rdbms/admin/xaview.sql
   grant select on v$xatrans$ to public with grant option;
   grant select on v$pending_xatrans$ to public with grant option;

2. connect system(the default password is manager)
   grant select any table to public;


TUXEDO 的内容:
1. 查阅 $TUXDIR/udataobj/RM 是否有如下数据行：
   notice: NT use ;,while UNIX use :
   # ORACLE 8 for NT
   1.recommend the below line use #
   	<RM NAME>;xaosw;\ORANT\RDBMS80\XA\XA80.LIB \ORANT\PRO80\LIB\MSVC\SQLLIB80.LIB
   2.and the below line,depend on the oracle direcory you installed
   	Oracle_XA;xaosw;D:\Ora81\RDBMS\XA\ORAXA8.LIB d:\ora81\precomp\lib\msvc\orasql8.lib
   # ORACLE for UNIX
   <RM NAME>:xaosw:-L${ORACLE_HOME}/lib -lclntsh



2. 在TUXEDO用户下创建 TMS

   buildtms -o $TUXDIR/bin/<TMS NAME> -r <RM NAME>
   example:
	buildtms -o d:\tuxedo65\bin\TMS_ORA8i -r Oracle_XA


3. 配置 UBBCONFIG

   在 *GROUPS 节添加以下数据行：(NOTICE:  in NT is :,in UNIX is ;)
   OPENINFO="<RM NAME>:Oracle_XA+Acc=P/<user name>/<password>+SesTm=600+SqlNet=<service name>+MaxCur=5+LogDir=."
   TMSNAME="<TMS NAME>"

   若连本地数据库，需设置环境变量 ORACLE_SID, 则为
   OPENINFO="<RM NAME>:Oracle_XA+Acc=P/<user name>/<password>+SesTm=600+MaxCur=5+LogDir=."
   TMSNAME="<TMS_NAME>"

   example:

-tpini.o

*GROUPS
GROUP1
	LMID=simple	GRPNO=1
	OPENINFO="Oracle_XA:Oracle_XA+Acc=P/scott/tiger+SesTm=600+MaxCur=5+LogDir=."
	TMSNAME="TMS_ORA8i"	TMSCOUNT=2

4.modify the head file of tuxedo in order to compile the *.pc file
  1.modify the file's name under diretory TUXDIR/incude
    sqlca.h -> sqlca.h.bbb
    sqlcode.h -> sqlcode.h.bbb
    sqlda.h -> sqlda.h.bbb
  2.TUXDIR/lib/libsql.lib -> libsql.lib.bbb
note:donot remain those file.otherwise the *.c file generate by the proc cannot be use by buildserver to build the *.exe file

5. 编译并连接应用程序，追加 -r 选项
   1.use proc to compile the *.pc file into *.c file
   	proc *.pc include=%TUXDIR%/include
   2.build server and client	
   	buildclient -o <client> -f <client file> -r <RM NAME> < -w >
   	buildserver -o <server> -f <server file> -r <RM NAME> -s < service > ....
**
create the TLOG file
tmadmin <<!
trdl -b 500 -z /usr/apps/atmapp/logs/TLOGS -o 0
crlog -m site1
!
 
example:
	proc simpserver.pc include=%TUXDIR%/include
	buildserver -o simpserv -f simpserver.c -r Oracle_XA -s TOUPPER

6. 启动TUXEDO即可连接数据库
   tmboot -y





hzq