Tuxedo与Oracle连接

Tuxedo9.0forAIX与Oracle10XA连接系统说明TUXEDO版本:9.0安装目录/opt/bea/tuxedo9.0ORACLE版本:10.2.0.1安装目录/u01/app/oracle一、Tuxedo9forAIX的安装1、创建一个用户为Tuxedo，用户组为bea2、创建/opt/bea为tuxedo的安装目录，$mkdir/opt/bea$chowntuxedo.bea/opt/bea$chmod770/opt/bea#bootinfo-k64$shtuxedo9_aix53_64.bin-iconsolePreparingtoinstall...WARNING:/tmpdoesnothaveenoughdiskspace!Attemptingtouse/home/tuxedoforinstallbaseandtmpdir.ExtractingtheJREfromtheinstallerarchive...UnpackingtheJRE...Extractingtheinstallationresourcesfromtheinstallerarchive...Configuringtheinstallerforthissystem'senvironment...Launchinginstaller...PreparingCONSOLEModeInstallation...===============================================================================ChooseLocale...-----------------1-EnglishCHOOSELOCALEBYNUMBER:1===============================================================================(createdwithInstallAnywherebyZeroG)-------------------------------------------------------------------------------===============================================================================Introduction------------BEAEndUserClickwrap001205Copyright(c)BEASystems,Inc.AllRightsReserved.DOYOUACCEPTTHETERMSOFTHISLICENSEAGREEMENT?(Y/N):y===============================================================================ChooseInstallSet------------------PleasechoosetheInstallSettobeinstalledbythisinstaller.-1-FullInstall2-ServerInstall3-FullClientInstall4-JoltClientInstall5-ATMIClientInstall6-CORBAClientInstall7-Customize...ENTERTHENUMBERFORTHEINSTALLSET,ORPRESSENTERTOACCEPTTHEDEFAULT:1===============================================================================ChooseBEAHome---------------1-CreatenewBEAHome2-UseexistingBEAHomeEnteranumber:21-/opt/beaExistingBEAHomedirectory:1===============================================================================ChooseProductDirectory------------------------1-ModifyCurrentSelection(/opt/bea/tuxedo9.0)2-UseCurrentSelection(/opt/bea/tuxedo9.0)Enteranumber:2===============================================================================Pre-InstallationSummary------------------------PleaseReviewtheFollowingBeforeContinuing:ProductName:Tuxedo9.0InstallFolder:/opt/bea/tuxedo9.0LinkFolder:/home/tuxedoDiskSpaceInformation(forInstallationTarget):Required:386,803,702bytesAvailable:2,625,392,640bytesPRESSENTERTOCONTINUE:===============================================================================ReadyToInstall----------------InstallAnywhereisnowreadytoinstallTuxedo9.0ontoyoursystematthefollowinglocation:/opt/bea/tuxedo9.0PRESSENTERTOINSTALL:===============================================================================Installing...-------------[==================|==================|==================|==================][------------------|------------------|------------------|------------------]===============================================================================ConfiguretlistenService-------------------------Password:tuxedoVerifyPassword:tuxedoPasswordAccepted!PressEntertocontinue.===============================================================================SSLInstallationChoice.------------------------WouldyouliketoinstallSSLSupport?-1-Yes2-NoENTERTHENUMBERFORYOURCHOICE,ORPRESSENTERTOACCEPTTHEDEFAULT::2===============================================================================LicenseInstallationChoice---------------------------Wouldyouliketoinstallyourlicensenow?-1-Yes2-NoENTERTHENUMBERFORYOURCHOICE,ORPRESSENTERTOACCEPTTHEDEFAULT::2===============================================================================InstallationComplete---------------------Congratulations.Tuxedo9.0hasbeensuccessfullyinstalledto:/opt/bea/tuxedo9.0PRESSENTERTOEXITTHEINSTALLER:安装完毕，需要把license文件重命名为lic.txtcopy到$TUXDIR/udataobj/二、TUxedo9连接Oracle10g配置前提是在Tuxedo9上安装Oracle10gclient还有安装C编译器（不一定要用VisualAgeC/C++7,这里我用的是proc），设置Tuxedo用户能够通过sqlplus连接oracle数据库1、ORACLE的的配置sqlplussystem@testcrmSQL@$ORACLE_HOME\rdbms\admin\xaview.sqlSQLgrantselectonv$xatrans$topublicwithgrantoption;SQLgrantselectonv$pending_xatrans$topublicwithgrantoption;SQLgrantselectEMPtoScottSQLGRANTSELECTONDBA_PENDING_TRANSACTIONSTOScott;注：scott默认为lock，需要用alteruserscottaccountunlock，解锁。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.0APPDIR=/opt/bea/tuxedo9.0/testTUXCONFIG=$APPDIR/tuxconfigCCOMP=/usr/vac/binPATH=$PATH:$TUXDIR/bin:$CCOMP:$ORACLE_HOME/binexportORACLE_BASE=/home/oracleexportORACLE_HOME=$ORACLE_BASE/product/10.2.0/client_1exportORACLE_SID=ORCLexportORACLE_TERM=vt100exportNLS_LANG=AMERICAN_America.ZHS16GBKexportORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/dataexportLD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/network/lib:/usr/lib:$ORACLE_HOME/lib:$TUXDIR/libexportPATHAPPDIRTUXDIRTUXCONFIGCCOMPif[-s$MAIL]#ThisisatShellstartup.Innormalthenecho$MAILMSG#operation,theShellchecksfi3、修改$TUXDIR\udataobj目录下的RM文件把以Oracle_XA:xaosw:开头的一行用#注释掉，并加入一行：Oracle_XA:xaosw:-L${ORACLE_