您好,欢迎访问三七文档
当前位置:首页 > IT计算机/网络 > 数据库 > 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_
本文标题:Tuxedo与Oracle连接
链接地址:https://www.777doc.com/doc-13385 .html