Tuxedo 9.0 for AIX與Oracle 10 XA連接 系統(tǒng)說明 TUXEDO版本:9.0 安裝目錄 /opt/bea/tuxedo9.0 ORACLE版本: 安裝目錄 /u01/app/oracle一、Tuxedo 9 for AIX的安裝 1、創(chuàng)建一個用戶為Tuxedo，用戶組為bea 2、創(chuàng)建/opt/bea為tuxedo的安裝目錄， $mkdir /opt/bea $chown tuxedo.bea /opt/bea $chmod 770 /opt/bea #bootinfo -k 64$ sh tuxedo9_aix53_64.bin -i consolePreparing to install.WARNING: /tmp does not have enough disk space! Attempting to use /home/tuxedo for install base and tmp dir.Extracting the JRE from the installer archive.Unpacking the JRE.Extracting the installation resources from the installer archive.Configuring the installer for this systems environment.Launching installer.Preparing CONSOLE Mode Installation.=Choose Locale.- -1- EnglishCHOOSE LOCALE BY NUMBER: 1= (created with InstallAnywhere by Zero G)- =Introduction-BEA End User Clickwrap 001205Copyright (c) BEA Systems, Inc.All Rights Reserved. DO YOU ACCEPT THE TERMS OF THIS LICENSE AGREEMENT? (Y/N): y =Choose Install Set-Please choose the Install Set to be installed by this installer. -1- Full Install 2- Server Install 3- Full Client Install 4- Jolt Client Install 5- ATMI Client Install 6- CORBA Client Install 7- Customize.ENTER THE NUMBER FOR THE INSTALL SET, OR PRESS TO ACCEPT THE DEFAULT : 1 =Choose BEA Home- 1- Create new BEA Home 2- Use existing BEA HomeEnter a number: 2 1- /opt/beaExisting BEA Home directory: 1 =Choose Product Directory- 1- Modify Current Selection (/opt/bea/tuxedo9.0) 2- Use Current Selection (/opt/bea/tuxedo9.0)Enter a number: 2 =Pre-Installation Summary-Please Review the Following Before Continuing:Product Name: Tuxedo 9.0Install Folder: /opt/bea/tuxedo9.0Link Folder: /home/tuxedoDisk Space Information (for Installation Target): Required: 386,803,702 bytes Available: 2,625,392,640 bytesPRESS TO CONTINUE: =Ready To Install-InstallAnywhere is now ready to install Tuxedo 9.0 onto your system at the following location: /opt/bea/tuxedo9.0PRESS TO INSTALL: =Installing.- =|=|=|= -|-|-|- =Configure tlisten Service-Password: tuxedoVerify Password: tuxedoPassword Accepted! Press Enter to continue. =SSL Installation Choice.-Would you like to install SSL Support? -1- Yes 2- NoENTER THE NUMBER FOR YOUR CHOICE, OR PRESS TO ACCEPT THE DEFAULT: : 2 =License Installation Choice-Would you like to install your license now? -1- Yes 2- NoENTER THE NUMBER FOR YOUR CHOICE, OR PRESS TO ACCEPT THE DEFAULT: : 2 =Installation Complete-Congratulations. Tuxedo 9.0 has been successfully installed to: /opt/bea/tuxedo9.0PRESS TO EXIT THE INSTALLER: 安裝完畢，需要把license文件重命名為lic.txt copy到$TUXDIR/udataobj/二、TUxedo 9 連接 Oracle 10g配置 前提是在Tuxedo 9 上安裝Oracle 10g client還有安裝C編譯器（不一定要用Visual Age C/C+ 7,這里我用的是pro c），設置Tuxedo用戶能夠通過sqlplus連接oracle數據庫 1、ORACLE的的配置 sqlplus systemtestcrm SQL $ORACLE_HOMErdbmsadminxaview.sql SQLgrant select on v$xatrans$ to public with grant option; SQLgrant select on v$pending_xatrans$ to public with grant option; SQLgrant select EMP to Scott SQLGRANT SELECT ON DBA_PENDING_TRANSACTIONS TO Scott; 注：scott默認為lock，需要用alter user scott account unlock，解鎖。 2、設置Tuxedo用戶的.profile文件 PATH=/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=/opt/bea/tuxedo9.0 APPDIR=/opt/bea/tuxedo9.0/test TUXCONFIG=$APPDIR/tuxconfig CCOMP=/usr/vac/bin PATH=$PATH:$TUXDIR/bin:$CCOMP:$ORACLE_HOME/bin export ORACLE_BASE=/home/oracle export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/client_1 export ORACLE_SID=ORCL export ORACLE_TERM=vt100 export NLS_LANG=AMERICAN_America.ZHS16GBK export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/network/lib:/usr/lib:$ORACLE_HOME/lib:$TUXDIR/lib export PATH APPDIR TUXDIR TUXCONFIG CCOMP if -s $MAIL # This is at Shell startup. In normal then echo $MAILMSG # operation, the Shell checks fi 3、修改$TUXDIRudataobj目錄下的RM文件 把以Oracle_XA:xaosw:開頭的一行用#注釋掉，并加入一行： Oracle_XA:xaosw:-L$ORACLE_HOME/lib $ORACLE_HOME/precomp/lib/cobsqlintf.o -lclntsh 注意空格 3、在TUXEDO用戶下創(chuàng)建TMS文件:TMS_ORA10g，TUXEDO通過TMS_ORA10g與ORACLE數據庫采用XA協(xié)議進行通訊 buildtms -o $TUXAPP/TMS_ORA10g -r Oracle_XA 4、配置 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. *RESOURCES IPCKEY 32770 #DOMAINID simpapp MASTER simple MAXACCESSERS 100 MAXSERVERS 50 MAXSERVICES 100 MODEL SHM LDBAL N *MACHINES Server LMID=simple APPDIR=/opt/bea/tuxedo9.0/test TUXCONFIG=/opt/bea/tuxedo9.0/test/tuxconfig TUXDIR=/opt/bea/tuxedo9.0 TLOGDEVICE = /opt/bea/tuxedo9.0/test/TLOG TLOGNAME=TLOG TLOGSIZE=100 *GROUPS GROUP1 LMID=simple GRPNO=1 OPENINFO=ORACLE_XA:Oracle_XA+Acc=P/scott/scott+sqlNet=ORCL+SesTm=100+LogDir=.+MaxCur=5 TMSNAME=TMS_ORA10g TMSCOUNT=2 *SERVERS DEFAULT: CLOPT=-A test SRVGRP=GROUP1 SRVID=1 *SERVICES 注意OPENINFO中P/scott/scott+sqlNet=ORCL需要根據實際情況自定義,還有機器名“server”，必須與uname -n顯示的機器名一致 使用 $tmloadcf -y ubbsimple 生產TUXCONFIG文件 5、用TMADMIN創(chuàng)建TLOG文件，TUXEDO用一個文件TLOG記錄對數據庫操作的日志。用于協(xié)調分布式數據庫的提交與回滾。 $tmadmin crdl -b 500 -z $TUXAPP/TLOG crlog -m simple q 6、重命名下列文件，因為下列文件名與ORACLE帶的文件名有沖突 TUXEDO安裝路徑$TUXDIR/include目錄下的下面文件 把sqlca.h 改名為 sqlca.h.bak 把sqlcode.h 改名為 sqlcode.h.bak 把sqlda.h 改名為 sqlda.h.bak 7、服務端的程序：test.pc，功能:根據客戶端傳的EMPNO到表EMP中取ENAME的值，并把它返回給客戶端 編寫客戶端程序: testcli.c 功能:調用TUXEDO服務端的服務TEST，取EMPNO=7900所對應的ENAME的值，并顯示出來 這里為沒有寫代碼，因為我發(fā)現(xiàn)我到網搜索的測試代碼都沒法通過。 五、編譯服務端程序 1.用ORACLE的PROC把test.pc 文件預編譯成test.c文件 $ proc test.pc include=$TUXDIRinclude 2.用buildserver把test.c編譯成可執(zhí)行文件，注意-r 后帶的Oracle_XA 與RM文件中的一致。 $ buildserver -o test -f test.c -r Oracle_XA -s TEST 編譯客戶端程序 $ buildclient -o testcli -f testcli.c 8、用 tmboot y 啟動TUXEDO 應能看到所有的SERVER都啟動成功。這時，我們的服務端程序test 會自動與ORACLE數據庫建立連接，并一直保持這個連接， 直到TUXEDO系統(tǒng)或ORACLE數據庫關閉。所以在我們的程序test.pc中看不到與數據庫連接的語句，因為現(xiàn)在與數據庫的連接由TUXEDO自動管理。 如果TMS_ORA10g啟動失敗會在當前目錄