Datastage安装

1、InformationServer8.5InstallationBasedonOracle11gR21系统环境1.1硬件资源CPU16Memory48G1.2操作系统及软件版本操作系统版本HPUnixReleaseB.11.31数据库版本linux.x64_11gR2()InfoSphereInformationServer版本IIS8.51.3安装拓扑图工客户机/服务器拓扑计算机A客户机房1.4系统要求1.4.1操作系统操作系统处理器HP-UX11iv2IntelItaniumprocessors.HP-UX11iv3IntelItaniumprocessors.1.4.2内

2、存安装条目最低要求内存实际内存引擎层/服务层6G资源库层4G安装条目最低要求内存实际内存引擎层/服务层6G资源库层1.4.4内核参数参数条目引擎服务层资源库层DB2OracleMAXFILES8000*MSGMAP32768*MSGMAX65535*MSGMNB65535(singleprofile)131070(morethanoneprofile)*MSGMNI50*MSGSEG32767MSGTQL2046NFILE58145NFLOCKS3000*NPROC4116*SEMMNI2048*SEMMNS16384*SEMMNU1024*SEMMSL2048*SHMMAX307200000

3、*SHMMNI2000*SHMSEG1024*MAXUPRC1000orunlimited*NOFILES102401.4.5用户资源用户资源类型资源名称值1.4.6网络Vi/etc/hosts9T274NP00VM03HOSTNAME=T274NP00VM03IP=91.4.7依赖包IIS8.5Oracle11gR2x84_64x84_64compat-libstdc+-33.x86_64binutils.x86_64glibc.x86_64compat-libstdc+-33.x86_64libaio.x86_64elfutils-lib

4、elf.x86_64libgcc.x86_64elfutils-libelf-devel.x86_64libstdc+.x86_64gcc.x86_64libX11.x86_64gcc-c+.x86_64libXau.x86_64glibc.x86_64libxcb.x86_64glibc-common.x86_64libXext.x86_64glibc-devel.x86_64libXmu.x86_64glibc-headers.x86_64libXp.x86_64ksh.x86_64nss-softokn-freebl.x86_64libaio.x86_64pam.x86_64libaio

5、-devel.x86_64libXmu.x86_64libgcc.x86_64glibc.i686libstdc+.x86_64libXp.i686libstdc+-devel.x86_64libXau.i686make.x86_64libXext.i686sysstat.x8664libX11.i686unixODBC.x8664libxcb.i686unixODBC-devel.x86_64nss-softokn-freebl.i686compat-libstdc+-33.i686glibc.i686glibc-devel.i686libaio.i686libaio-devel.i686l

6、ibgcc.i686libstdc+.i6861.5环境配置1.5.1 、关闭防火墙和Selinuxserviceiptablesstop-W停防火墙服务serviceip6tablesstopchkconfigiptablesoff永久关闭防火墙chkconfigip6tablesoffvi/etc/selinux/config将selinuxdisable# ThisfilecontrolsthestateofSELinuxonthesyatem.tSELINUX-cantakeoneofthesethreevalues:# enforcing-SELmuxsecuritypolicyis

7、enforced*# permissive-SELinuxprintswarningsinsteadofenforcing.# di月/匕1户&=甘SELinuxpolicyisloaded4fcELINUX=disabledIJ3LL11MUA1tldAtakeoneofthesetwovalues:# targeted-Targetedprocessesareprotected,fmis-MultiLevelSecurityprotection.SELINUXTYPE=rargeted1.5.2 更改系统Release文件安装oracle时，需要修改此文件vi/etc/system

8、-release注释掉原有内容新增如下：#CentOSreleaseT.7Final)RedHatEnterpriseLinux1.5.3 修改内核参数vim/etc/sysctl.conf内核参数需要考虑至UInformationserverengine以及oracle对内核的最低要求。fs.aio-max-nr=1048576fs.file-max=6815744kernel.shmall=2097152kernel.shmmax=4294967295kernel.shmmni=4096kernel.sem=2502560001001024net.ipv4.ip_local_port_ra

9、nge=900065500net.core.rmem_default=262144net.core.rmem_max=4194304net.core.wmem_default=262144net.core.wmem_max=10485861.5.4 依赖包安装更新yuminstall-ybinutils.x86_64compat-libcap1.x86_64compat-libstdc+-33.i686compat-libstdc+-33.x86_64gcc.x86_64gcc-c+.x86_64glibc.i686glibc.x86_64glibc-devel.i686glibc-devel

10、.x86_64kshlibaio.i686libaio.x86_64libaio-devel.i686libaio-devel.x86_64libgcc.i686libgcc.x86_64libstdc+.i686libstdc+.x86_64libstdc+-devel.i686libstdc+-devel.x86_64makesysstat.x86_64libX11.x86_64libXau.x86_64libxcb.x86_64libXext.x86_64libXmu.x86_64libXp.x86_64nss-softokn-freebl.x86_64pam.x86_64unixODB

11、C.x86_64unixODBC.i686unixODBC-devel.x86_64unixODBC-devel.i686以上包安装完成后执行包更新操作：yum-yupdaterpm-ivhpam-1.1.1-17.el6,i686.rpm-nodepsrpm-qa|grepglibc-2.12-1.107.el6.x86_64libXau-1.0.5-1.el6.x86_64libxcb-1.5-1.el6.x86_64libX11-1.3-2.el6.x86_64libXext-1.1-3.el6.x86_64libXp-1.0.0-15.1.el6.x86_64cracklib-2.8.

12、16-4.el6.i686.rpmlibICE-1.0.6-1.el6.i686.rpmlibuuid-2.17.2-12.18.el6.i686.rpmlibXt-1.0.7-1.el6.i686.rpmlibXmu-1.0.5-1.el6.x86_64nss-softokn-freebl-3.14.3-9.el6.x86_64audit-libs-2.3.7-5.el6.i686.rpmdb4-4.7.25-19.el6_6.i686.rpmpam-1.1.1-4.el6_0.1.x86_64libaio-0.3.107-10.el6.x86_64libstdc+-4.4.7-3.el6.

13、x86_64compat-libstdc+-33-3.2.3-69.el6.x86_64libgcc-4.4.7-3.el6.x86_641.5.5 关联设置执行如下命令，修改关联文件/etc/pam.d/loginvi/etc/pam.d/login在文件尾部添加如下信息：sessionrequiredpam_limits.so1.5.6 创建用户和组创建oracle用户和组groupaddoinstallgroupadddbauseradd-goinstall-Gdbaoraclepasswdoracle在oracle用户目录下编辑.bash_profile设置如下环境变量ORACLE_B

14、ASE=/opt/oracle;exportORACLE_BASEORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1;exportORACLE_HOMEORACLE_SID=XMETA;exportORACLE_SIDPATH=$PATH:$HOME/bin:$ORACLE_HOME/bin;exportPATHLD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib;exportLD_LIBRARY_PATH创建DS用户和组groupadddstageuseradd-gdstagedsadmpasswddsadm1.5.7 创建

15、安装目录规划安装目录，并提前创建好安装目录，并做相应权限更改。创建ORACLEBAS同录mkdir-p/opt/oraclemkdir-p/opt/oracle/product/11.2.0/db_1mkdir-p/opt/oracle/oradatamkdir-p/opt/oraInventorychownoracle:oinstallchownoracle:oinstallchownoracle:oinstallchownoracle:oinstall- R/opt/oracle- R/opt/oracle/product/11.2.0/db_1- R/opt/oracle/oradata

16、- R/opt/oraInventory1.5.8 修改/etc/profileif$USER="oracle"thenif$SHELL="/bin/ksh"thenulimit-p16384ulimit-n65536elseulimit-u16384-n65536fifi1.5.9 修改资源限制vim/etc/security/limits.conf以oracle用户为例子，DS用户也需要做相同操作oraclesoftnproc2047oraclehardnproc16384oraclesoftnofile10240oraclehardnofile65

17、536oraclesoftstack102402安装Oracle11gR22.1 安装步骤2.1.1 ConfigureSecurityUpdates2.1.2 InstallationOption2.1.3SystemClass2.1.4TypicalInstallation字符集必须选择NLS_CHARACTERSET=AL32UTF8SYS,SYSTEM,SYSMAN,DBSNMPhasthesamepasswordPassword4me2.1.5CreateInventory2.1.6PrerequisiteChecks2.1.8InstallProduct2.2 Oracle启动与关

18、闭2.2.1 启动STARTUPNOMOUNT可以不装入数据库而启动事例，一般是在数据库才创建时才可以这样做：STARTUPMOUNT用户可以启动事例而并装入数据库但不打开数据库，允许用户执行特定的维护操作。例如：重命名数据文件；添加、撤消或重命名重做日志文件；启动和禁止重做日志归档；执行全部的数据库恢复。STARTUP正常情况是一个事例被启动，数据库装入并打开。这种模式允许任何有效用户连接到数据库并执行典型的数据库访问操作。STARTUPRESTRICT用户可以在严格的模式下启动事例并装入数据库，这样的模式只允许DBA做以下的工作：执行结构维护，如重建索引；执行数据库文件的导入导出；执行数据

19、装载；临时阻止典型用户使用数据STARTUPFORCE可以用下面命令来强行启动事例，如果一个事例正在启动，则STARTUPFORC重新启动。STARTUPOPENRECOVER如果用户要求介质恢复，可以启动一个事例，装入指向事例的数据库，并自动地启动恢复程序。2.2.2 关闭SHUTDOWNNORMAL不允许新的连接、等待会话结束、等待事务结束、做一个检查点并关闭数据文件。启动时不需要实例恢复。SHUTDOWNTRANSACTIONAL不允许新的连接、不等待会话结束、等待事务结束、做一个检查点并关闭数据文件。启动时不需要实例恢复。SHUTDOWNIMMEDIATE不允许新的连接、不等待会话结束

20、、不等待事务结束、做一个检查点并关闭数据文件。没有结束的事务是自动rollback的。启动时不需要实例恢复。SHUTDOWNABORT不允许新的连接、不等待会话结束、不等待事务结束、不做检查点且没有关闭数据文件。启动时自动进行实例恢复。2.3 监听服务lsnrctlstatus|start|stopstatus:查看监听状态start:启动监听服务stop:停止监听服务如果系统自动配置的监听，在启动服务后容易出现监听错误，需要在监听文件下增加如下内容：SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(GLOBAL_DBNAME=XMETA)(SID_NAME=XME

21、TA)(ORACLE_HOME/=opt/oracle/product/11.2.0/db_1)(PRESPAWN_MAX=20)(PRESPAWN_LIST=(PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1)2.4 OEM2.4.1 常规启动emctlstatus|start|stopdbconsole2.4.2 重建OEMemca寸eposrecreate此命令作用是先删除EM资料档案库，再创建EM资料档案库，这一步删除和创建分别要等10-15分钟，oracle.exe进程会占用50%多的CPU资源。emca-configdbcont

22、roldb此操作将移去现有配置和默认设置，并重新执行配置。根据提示，会一次提供sys,system,sysnmp等帐号及密码，另需要指定LISTENER勺位置。emctlstartdbconsole启动OEM2.4.3 解决Windows下无法打开OEM以管理员身份运行一下命令：certutil-setregchainminRSAPubKeyBitLength512允许的最小RSA密钥长度为512certutil-setregchainEnableWeakSignatureFlags2启用密钥长度少于1024位的RSA根证书2.5 Oracle常用命令su-oraclesqlplus/assy

23、sdbaSQL>startup#启动数据库实例SQL>shutdownimmediate#关闭数据库实例SQL>select*fromtab;#查看所有表SQL>selectnamefromv$datafile#查看数据库存放目录SQL>showparameterservice#查看服务名SQL>select*fromv$instance;#查看实例名SQL>selectnamefromv$database;#查看数据库名SQL>select*fromdba_users;#查看所有用户信息SQL>selectusername,passwor

24、dfromdba_users;#只查询用户和密码SQL>select*fromv$pwfileusers;#查看具有sysdba权限的用户SQL>select*fromdba_ustats;#查看当前用户信息SQL>select*fromuser_sys_privs#查看当前用户系统权限SQL>select*fromuser_role_privs#查看当前用户角色SQL>select*fromdba_sys_privs#查看指定用户所具有的系统权限SQL>select*fromv$version#查看oracle版本SQL>select*fromuse

25、r_views#查看视图信息rootoracledb#lsnrctlstart#开启远程监听端口3安装InformationServer9.13.1 创建XMETA数据库及相应用户3.1.1 创建表空间ExamLhhnaMaVwaIDC3.1.2 创建用户XMETA:CreaitBUserGefitralFtckt,FrlWggOhMci5向S口gtmCwisuftwGroupEr巳rwc,LJmws。七ngEl5gteEPnW&ci&aQbieE丘间七口口11口上£耳ConmunrwefGrou口RrMleues;尸ek¥Us<er+XMETASRC

26、reateUser* NiarnePronUiAuflnentK-BitiDn4 Efi3r Pa£cword匚I Expina PflfSiWD newZtefiault Tabl«spfic«Temprwry 丁，国*2。4StBtkra C! LocKZ 通 UEgketi二jat三bmwwI-man":型：WETa>>ModifySystemPrivilegesAvailable System PrivilegesSelected System PrivilegesSVSD6ASVSOFERUNDEW ANY TABLEUNDER A

27、NY TYFEUNDE1? ANY VIEWUPDATE AN- CUBEUPDATE ANY CUBE BUILD PROCESSUPDATE ANY CUBE DlMENSIOtl UPDATE ANY TABLE>MoveMg再期<一8EM*H.iCOMEhTT ANY TABLECREATE TABLECREATE VIE'/tfUNUMITED TABLESPACEDSODB需要赋予DSODB用户如下权限：CREATESESSION,CONNECT,RESOURCECREATETABLECREATEPROCEDUREFTqxy User与GeneralR口店与S冶

28、tELockedUnlockedGeneralSymtEEPrivilegesObiECtFh/i心口Quotss二口nEurmeiG%j口F1%ilmqFTqkyUebt与3.2安装步骤3.2.1GettingStartedIBMWoSphcreDntonnvlMHiSerw?iiHMatmpr？gr-wrrcagrapq3.2.2FirewallRequirement3.2.3EarlyRequirementCheck3.2.4InstallationDirectory3.2.5InstallationTypeSelection3.2.6TierSelection/阳i附Sts照d/Frw

29、.豌.鹏网/ Eir Y RetJjirprtMS m(leZlnftHH cr/ Irsli lit cr Type Sr kHwi/ Tict St Milan> ProcLid: Se ert cnHigh A&b BblRWnrrEqj"肚”RsqrefTETls; Cheds肥附 陋e FiW-Rft/e*鼠LL也呼Insla literInsli lat er CcrwplfWPxdud: rrcdu&t/昕已EnflF tierffiepcshnry !erSerik esterU JEM Dr Wp*w DKi Qui Hy OncM困事 1网丁

30、峪曲”二脖C：*dcr曲谢3r TEMTgSpWf 修单”al* 必 itSprwt Metadiu Wcrkwcral曲由口 1岛4 丁法phtrt lEnnrsth用油上广好第Ifl出由0 出京丁七*rtw懂口000PIrfESptHft lus -C55 G niMrv Anerc9O 2&ZrfeSphc«- Bus "tss G w”口事口 E ZribSphere Qud h-Sts-geHa甲*71>Sted ACid: a nxliKt medu e rwrie r Ife irt bo ew a dHcr pfi or.£IBMKD

31、5ptef带brhwnial»fiSenKrimtallirtiuitpragFiamL：etLIraawIBMlnloSphewInfomiflllaiiServerProduct轴拒cl»nSeedmoduesto飒sem1怫|甘加电0fe，即edson：的aft.Tflutw-彳nmri'jrinwldRvn*miKlW"awii第i*nmtma54ectUieIBMrnk>SptiereInTormartJwiServerPangudQe:Engtyi-The-wansnWktBb厄imlcsbei«ti仃sett楣reiterss

32、tferted叩earfpircuctrrociUE.Fer£iarrpluriftMIrriaSphenefcmitanAraflieI时事堆即pfipgrim筝制OmitrBljitrf.Bk*3.2.8ProductLicenseAgreement3.2.9 IBMInfoSphereDataStageInstallationOptions3.2.10 HighAvailabilityServerClusterConfiguration3.2.11ApplicationServerOptions3.2.12IBMWASInstallationDirectory3.2.13IBM

33、WASProfilePortsAssignmentAFMoSpheneimce曰5e<winsw电慢*中ogi炳:的1*«密区"IBMIrTfoSphereInformatiofiServer/GeflE；Sidled/Fnml帆remH-t/Ea传Rjkj/止koil6tdsn#毗加Diftcic年/阿1#*闻nRk54Ki,TirSf+Kt-cr/即0闻计81时b/ProductLceyAgnttfrer:/IBMir-feSphere-tsta%gHr由/HigtiAvsilabrtyChnfig-rtcn/AppkrtgtOptians/IBMrtWS浙近即。

34、三仙的Sfi?IBMWsoSflNrtW口旧S*AapiCitM融/皿飞心和工raws*口MmIBMDB2>dal川bLocalionIBM因物如MtOwnerIBM凶Fer对3IBM因AdmrirtralnrlJsCTMebKhLaAefHSInrr5廊附ArtsfifHjewDKaSiBfiejftdQjilyStioftC¥MbE附心口XTgX"M脑WrolcrPM;IBMYptW必由9MmIBMarlcSptm-DJta笈耶Ad,"Gctiaizatcr£up(xxtIBMliVKilphereMQP妁-ie*SASConigurertkn

35、IBMWebSfihmAppiiailiDnServerPruRiltPoruAitiQumHil:Thefaiowingafredle,port1M5Gnnwrfa-fcrWrtSphereAppir友cnShvmithrleprofeTahergeavalje,ed'"1twimuenItwPortcdjrr.Thepjc455蒙讨后rfijSHFtOfirfliflkclft1P国电,Tfl如制fuMiffleSKd卬稀曲,巾年EMifcKhgl通rj/iq*,DkctptanPertHTTPkSiB硼弋t»fl，比后/贝培工函tb如埠port(DeMu：90

36、K；哂nHTCtnrWflport(Df由utW3l忖%CfiTMlr的iWutW3!Bgaistrapport'gSdMccrredm,partDeliuNpart则才E3fi：1ASSSLSencrti什partiCtesjt纸力1|C£VxSerrtfA-rihris-e-portiDrtut弘§：LSlMu-!AJiiijflw-FpertiDeaj9*HjCflfi'MMi|XMT：Cwl4unlK'：豆肝巾,乂牙鼠j&ej同时fiwijfliu&fihperi;KS；(Drtj7M司5>3535tMs蚓bpartiJ

37、Mah7Z围72BiSffvarr«gf»l«0rskun阳4汽阉net5rvnrhtgnlbMQr«fiQpnbl»rtr&rtijt53沏5彻SfifvoerbegralcrMQrfiefopeblh-McunepartIDefaJt55,711州瑞Sport心Wau:岫野seampert通力土5M1|MT*IKCcrredmport：OehuH关疝MBV(r>3.2.14ApplicationServerAdministrator3.2.15 IBMInfoSphereInformationServerAdministrat

38、or3.2.16 DatabaseManagementSystemSelection3.2.17Databaseconnection3.2.18WASdatasourceforthestagingarea3.2.19 IBMIISAgentPortsConfigurationIBM/Gertie Slanted Ewa i烟/吩6*4d Rtqjnewts 5Kt D ntrteqi/ Tftl LU 时 T*| 544QM / fief $tKlfcgr/ Stodges 4e ecih / 加oduCt License 与reerrLflT W InfarSphert 口我上mje xst

39、j 7 ,rtflh Abb labi rty CcrH口dt / App tsb 5er«f OptCrs / RMa汕建Asp此册a S4 /型 /eb请，止 诏减2Se / 4的|工玳b 货而 岗什n中联 / SM 1府邪幌“ I他 2 m 54/ VMBdiH帮网用y 1社|泗4 / Carreduri do WeKirene App / Aprt Ports SrhgEi: cn > Jab MaritEf Aofl Garijguralicr纵I InbSphere DsSIbqe ,sSa 2W InfeSphene DsS'Ibse Ui Wm 回加Sa

40、gl铢 web 常 eMQPM.inse 35工前物用附iRi*5 Mt rdQcZM I睛卿帆幢口出5：4。PT0J 网 UiPffnECMaf pgnK Flhe 班v 时 Sunrrary< >3.2.20 JobMonitorPortsConfigurationAIBMCnlaEphereInTiwiwbanSenrerKititatxwiCMiflloSfhereMMntwMnSemr哂MMilbor即mConllQunatfQnTh!3MjMffiKsM*Data型时e|SMIBM工书CENfQuWlJM刖俄5忙占卸的“jMpt农情占FLYCu刖也t£S用电；

41、0b忖0ifimuahrfcSptsrEXi苗LayerdQmCiedDf.Spec与iheKR'TP附isWrmejcti61第gustTnejoo=51第usk口mTEMPpedw如esi.6iWmita/丽/«4swcrWP审pert»repert仲irrhimifli:ert珅此中附isW3躅0bybrer5cHic姓The由由JtpedWtt'rgsWt*mcilccnfnitignj,FKUCWpwt|1MXDMStcwdTCPdPinH1M13.2.21 ITAGConfigurationforMultipleEngineTiers3.2.22

42、 IBMInfoSphereDataStageAdministrator3.2.23 IBMDataStageandQualityStageGlobalization3.2.24IBMWebSphereMQPlug-inSelection3.2.25 SASConfiguration3.2.26 OperationsDatabaseConnection£IBMWoSpfcereIrrfwikiltofiiKlAbkHiprogr#n:Wip,nfwmation Server"fiett ng %一/ F newa Rbqj renwt/ Eiry 却 u-/山 &K

43、tZQrsla tr.ny Dreciof/m Mb Tjuexectia/如 XI H E W/Aflfi«frerrt1/33M lrrftiS£iie WUMtgur由/M gh Ara ab 卬 Cur附口6W Ap1l artkm Sere4, Dpt ers/姗 W4tiS3he« 即p icMcr Sei/ 珈 Mb 5SFe 即p 正 M Or Sei /金附 urt"Sr中 位方外场/国根I。监部ES】+F诩中1 Sfif/DSiJW* 阴:85/ hitwiu Rews wy 口瑜/ Hmtctia 15 WSpKnc ApjH/ A

44、jeri Rsrls CwrflgLnt 即/ Job Man 虹 M4 Srflgu口bon/ LBN Intnprcue 也U乳务匕 rsta/ 珈 InftiSprsra 口sU*务is Adm/Qawntitifi Supped/ 珈 WebSOftfift MQ PWE 5t/SJkSCBrfifiiJfMCC? CwiBSte g Qm tSyce OaInftSfine 口1情亲与电即OjlRtflUiflK-ffrtl Ch«tRHpqnwF*ftCiW *如 mnwy<: >CniE patswotd即emWinMid网匚白面配BaPter/de-tfe

45、cULsdim-sccesrfcratonta8,Ited!tsM«thetwIMerttteoMfitcrsdataiHM.31wlMees”为rcrtr«盘脂匕整忸加macmmM伸石期世Hwbe1押仃制对出说-日即4Hxsc加回afrLed如1提ifisLSbTOtbt&mM.匚SkipddfiatHEGcre-aijofiandmg原闻jeOdLibdMtype1%k如lip/Hm-InameTCPiIP1HMiI1621Um帆mnammiKiUEarflameOiMbPa&s#ordDatsba%*kKlion由刊bit时”闻阂/11£口她

46、_3Crmi3.2.27IBMInfoSphereDataStageProjects3.2.28SystemRequirementCheck3.2.29ResponseFileReview3.2.30PreinstallationSummaryfortheCurrentComputer3.2.31IBMInfoSphereInformationServerProgress4安装后配置4.1 配置ORACLE连接4.2 配置ODBC连接在dsenv中设置ORACLE_HOM或量，ORACLE_HOME=/opt/oracle/product/11.2.0/db_1;exportORACLE_HO

47、ME设置PATH变量，PATH必须包括ORACLEJHOMEH勺bin目录以及DSHOME/DSComponents/binPATH=$ORACLE_HOME/bin:$DSHOME/DSComponents/bin:PATH;exportPATH设置LD_LIBRARY_PATH、须包括ORACLE_HOME/libLD_LIBRARY_PATH=$ORACLE_HOME/lib:LD_LIBRARY_PATH;exportLD_LIBRARY_PATHdsadmetlDSEngine$catdsenv#!/bin/shORACLE_HOME=/opt/oracle/product/1120

48、/db_1;exportORACLE_HOMEPATH='dirname$DSHOME'/DSComponents/bin:$ORACLE_HOME/bin:$PATH;exportPATHLD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH;exportLD_LIBRARY_PATH#TNS_ADMIN=/home/dsadm/instantclient_11_2/network/admin;exportTNS_ADMIN4.2.1 测试ODBC连通性DSSH测试将目录切换到$DSHOME,并通过运行dsenv设置IBM?Info

49、Sphere?DataStage?环境：./dsenv启动引擎shell：./bin/dssh在引擎shell中，登录到项目：LOGTOproject_name通过输入以下命令获得可用DSN的列表：DS_CONNECT通过输入以下命令测试所需连接：DS_CONNECTDSN其中，DSN指定想要测试的连接。输入用户名和密码，以连接到所需的数据源。在连接到数据源后，输入.Q以关闭连接。EXAMPL酬试切换目录至/opt/IBM/InformationServer/Server/branded_odbc/samples/example4.3 配置OperationConsole4.3.1 检查ODB

50、是否安装默认安装时，已经将ODSD歌功安装，一般在XMETA数据中有一个ODSDB的SCHEMA4.3.2 生成Operations数据库模式的脚本如果在初始安装时没有安装ODSDR可以利用系统提供的工具生成建库的脚本。dsadmetlbin$./RepositoryAdmin.sh-saveSQLScripts-reposNamenamescriptLocationlocationName:数据库名字，一般为XMETALocation:保存脚本的路径4.3.3 检查ODB是否注册切换至安装目录/opt/IBM/InformationServer/ASBServer/bindsadmetlbi

51、n$./RepositoryAdmin.sh-listRepositoriesdsodbdsadmetlbin$表示DSODB已经注册成功4.3.4 手工完成注册如果未注册，将/opt/IBM/InformationServer/Server/DSODB目录下的DSODBrepos_perties文件复制到/opt/IBM/InformationServer/ASBServer/bin修改此文件，把数据库信息修改为之前创建的XMETA数据库。执行注册命令：dsadmetlbin$./RepositoryAdmin.sh-registerRepository-propertyFileDSODBrepos_perties4.3.5