tuxedo连接oracle XA连接实例.docx

tuxedo连接oracle XA连接安装tuxedo安装oracleOracle的一些配置sqlplus /nologconn /as sysdba@$ORACLE_HOME/rdbms/admin/xaview.sqlgrant select on v$xatrans$ to public with grant option; grant select on v$pending_xatrans$ to public with grant option; grant select on scott.emp to scott;GRANT SELECT ON DBA_PENDING_TRANSACTIONS TO Scott;注：scott默认为lock，需要用alter user scott account unlock，解锁。设置tuxedo用户的.bash_profilePATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.TH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.TUXDIR=/home/oracle/tuxedoAPPDIR=/home/oracle/oraTUXCONFIG=$APPDIR/tuxconfigCCOMP=/usr/vac/binPATH=$PATH:$TUXDIR/bin:$CCOMP:$ORACLE_HOME/binexport ORACLE_BASE=/home/oracle/ora10gexport ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1export ORACLE_SID=ORCLexport ORACLE_TERM=vt100export NLS_LANG=AMERICAN_America.ZHS16GBKexport ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/dataexport LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/network/lib:/usr/lib:$ORACLE_HOME/lib:$TUXDIR/libexport PATH APPDIR TUXDIR TUXCONFIG CCOMP修改$TUXDIR\udataobj目录下的RM文件把以Oracle_XA:xaosw:开头的一行用#注释掉，并加入一行：Oracle_XA:xaosw:-L${ORACLE_HOME}/lib ${ORACLE_HOME}/precomp/lib/cobsqlintf.o -lclntsh 注意空格在TUXEDO用户下创建TMS文件:TMS_ORA10g，TUXEDO通过TMS_ORA10g与ORACLE数据库采用XA协议进行通讯buildtms -o $TUXAPP/TMS_ORA10g -r Oracle_XA配置 UBBCONFIG#ghts Reserved.#ident??@(#) samples/atmi/simpapp/ubbsimple? ? $Revision: 1.5 $#Skeleton UBBCONFIG file for the TUXEDO Simple Application.#Replace the??items with the appropriate values.*RESOURCESIPCKEY? ?? ?? ? 32770#DOMAINID? ?? ? simpappMASTER? ?? ?? ? simpleMAXACCESSERS? ? 100MAXSERVERS? ?? ?50MAXSERVICES? ???100MODEL? ?? ?? ???SHMLDBAL? ?? ?? ???N*MACHINESServer LMID=simpleAPPDIR=/home/oracle/oraTUXCONFIG=/home/oracle/ora/tuxconfigTUXDIR=/home/oracle/tuxedoTLOGDEVICE=/home/oracle/ora/TLOGTLOGNAME=TLOGTLOGSIZE=100*GROUPSGROUP1 LMID=simple GRPNO=1 OPENINFO=ORACLE_XA:Oracle_XA+Acc=P/scott/tiger+sqlNet=ORCL+SesTm=100+LogDir=.+MaxCur=5TMSNAME=TMS_ORA10G TMSCOUNT=2*SERVERSDEFAULT:?