Informatica安装AIX Ver52 ver12.docx
- 文档编号:24545878
- 上传时间:2023-05-28
- 格式:DOCX
- 页数:33
- 大小:756.23KB
Informatica安装AIX Ver52 ver12.docx
《Informatica安装AIX Ver52 ver12.docx》由会员分享,可在线阅读,更多相关《Informatica安装AIX Ver52 ver12.docx(33页珍藏版)》请在冰豆网上搜索。
Informatica安装AIXVer52ver12
Informatica安装(InformaticaInstallation)
方案(Plan)
PowerCenter7Architecture
环境配置
PowerCenterClient
RepositoryServer
PowerCenterRepositoryDatabase
PowerCenterServer
操作系统
Windows
(98,2000,
2003,XP)
AIXUNIXver5.2(IBMpatchAPARIY60642)
Windows(2000,2003)
AIXUNIXver5.2
AIXUNIXver5.2(IBMpatchAPARIY60642)
机器名称
测试机器名SHODS_TST_SEV
与RepositoryServer所在机器相同
Ip:
10.5.228.67
Sid:
odsts
与RepositoryServer所在机器相同
开发机机器名SHODS_DEV_DEV
与RepositoryServer所在机器相同
Ip:
10.5.228.66
Sid:
odsdv
生产机机器名SHODS_PROD_ETL
与RepositoryServer所在机器相同
Ip:
10.5.239.4,10.5.239.5
Sid:
odspd
要求磁盘空间
200MB
80MB
150MB
70MB
内存
256MB
256MB
128MB
256MB
数据库连接
ODBC驱动
Native驱动
Native驱动
Native,ODBC驱动
实施流程(OperationProcess)
前期准备
1.创建和配置UNIX客户
在Unix上创建用户infa(其权限设置详见“操作系统用户分配”一节),修改配置.profile文件,指定使用的shell,参数配置等(参考oracle用户的.profile)。
.Profile文件内容:
PATH=/usr/bin:
/etc:
/usr/sbin:
/usr/ucb:
$HOME/bin:
/usr/bin/X11:
/sbin:
.
PATH=/user/infa/informatica/server:
/user/infa/informatica/repositoryserver:
$ORACLE_HOME/bin:
/usr/local/bin:
$PATH
ORACLE_BASE=/user/oracle/app/oracle
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
exportORACLE_HOME=/user/oracle/app/oracle/product/9.2.0#oracle安装路径
exportNLS_LANG="AMERICAN_AMERICA.UTF8"
exportTNS_ADMIN=$ORACLE_HOME/network/admin
exportORACLE_SID=odsts#存放Infa的InstanceID,测试机为odsts,生产机odspd,开发机odsdv
exportLIBPATH=/user/infa/informatica/server:
/user/infa/informatica/repositoryserver:
$ORACLE_HOME/lib:
/usr/lib:
.
exportPATHORACLE_BASEORA_NLS33
exportLANG="C"
exportPM_CODEPAGENAME="MS936"
2.数据库准备
1.在安装Informatica服务的主机上,提供连接到关系型数据库的NativeDriver。
2.创建用于存放InformaticaRepository表空间。
脚本:
测试机:
CREATETABLESPACEtst_infDATAFILE'/dev/rlv_tst_inf_01'SIZE4000M;
ALTERTABLESPACEtst_infADDDATAFILE'/dev/rlv_tst_inf_02'SIZE4000M;
开发机:
CREATETABLESPACEtst_infDATAFILE'/dev/rlv_dev_inf_01'SIZE4000M;
ALTERTABLESPACEtst_infADDDATAFILE'/dev/rlv_dev_inf_02'SIZE4000M;
生产机:
CREATETABLESPACEtst_infDATAFILE'/dev/rlv_prd_inf_01'SIZE4000M;
ALTERTABLESPACEtst_infADDDATAFILE'/dev/rlv_prd_inf_02'SIZE4000M;
3.在对应数据库中,创建一个数据库用户infa用来保存InformaticaRepository。
分配给该用户Connect,Resource权限。
创建INFA用户
测试机:
--DROPUSERINFACASCADE;
CREATEUSER"INFA"IDENTIFIEDBY"INFA"
DEFAULTTABLESPACETST_INF
TEMPORARYTABLESPACETEMP
QUOTAUNLIMITEDONTST_INF;
开发机:
CREATEUSER"INFA"IDENTIFIEDBY"INFA"
DEFAULTTABLESPACEDEV_INF
TEMPORARYTABLESPACETEMP
QUOTAUNLIMITEDONDEV_INF;
生产机:
CREATEUSER"INFA"IDENTIFIEDBY"INFA"
DEFAULTTABLESPACEPRD_INF
TEMPORARYTABLESPACETEMP
QUOTAUNLIMITEDONPRD_INF;
分配权限
GRANTCONNECTTOINFA;
GRANTRESOURCETOINFA;
安装步骤
1.使用infa用户telnet登陆到安装Informatica服务的主机上
telnet10.5.228.67注:
开发机、生产机ip分别10.5.228.66、10.5.239.4。
2.进入到infamatica安装目录
$cd/user/infa/aix/aix64bit
3.执行安装命令
$./install
4.配置参数如下:
注:
以下斜体带下划线部分为输入。
$sh./install
Pleasechoosethelanguagetoruninstallinfromthechoicesbelow:
1.English
2.Japanese
0.Exit
>1
===================================================
WelcometoInformaticaInstallationWizard.
AllInformaticaProductsCopyright1996-2005.
===================================================
PleaseenteryourProductKeyforInformaticaPowerCenter:
KTMJ-XUGA-YVYP-QTCC-JYRU
===================================================
WelcometoInformaticaInstallationWizard.
AllInformaticaProductsCopyright1996-2005.
===================================================
1.InformaticaRepositoryServer7.1.2
2.InformaticaPowerCenterServer7.1.2
0.Exit
Pleaseselectaproducttoinstall:
1
InstallingInformaticaRepositoryServer7.1.2
Pleasespecifyadirectorytoinstallto[/user/infa/informatica/repositoryserver]:
回车
/user/infa/informatica/repositoryserverdoesnotexist.create(y/n):
y
Installingmodulerepoexes
Modulerepoexesextractedsuccessfully.
Installingmodulerepolibs
Modulerepolibsextractedsuccessfully.
Installingmodulerepomisc
Modulerepomiscextractedsuccessfully.
Installingmodulepmlocale
Modulepmlocaleextractedsuccessfully.
Installingmodulerw
Modulerwextractedsuccessfully.
Installingmodulereposql
Modulereposqlextractedsuccessfully.
Installingmodulereposhr
Modulereposhrextractedsuccessfully.
Installingmodulepmdoc
Modulepmdocextractedsuccessfully.
Productspecificinstallationisstarting...
========================
IMPORTANT:
Ifyouhaveconnectivityoroptionlicenses,youmustupdatethePowerCenterServerandRepositorylicensefilesafterinstallation.Formoreinformationonupdatinglicensefiles,seetheonlinehelp.
========================
Informatica(tm)PMREPCONFIG,version[7.1.2],build[0127],64-bit
Copyright(c)2001-2005InformaticaCorporation.AllRightsReserved.
Configurationfilename[pmrepserver.cfg]:
回车
ServerPort[5001]:
回车
AdminPasswd[]:
Administrator
RaMinPort[5002]:
回车
RaMaxPort[65535]:
回车
ConfigDir[Config]:
回车
BackupDir[Backup]:
回车
PluginDir[Plugin]:
回车
ErrorSeverityLevel(E[rror]|W[arning]|I[nfo]|T[race]|D[ebug])[info]:
回车
LogFileName[pmrepserver.log]:
回车
InstallationofInformaticaRepositoryServer7.1.2hascompletedsuccessfully.
Wouldyouliketoviewthereadmefilenow(y/n):
n
Pressentertocontinue...
===================================================
WelcometoInformaticaInstallationWizard.
AllInformaticaProductsCopyright1996-2005.
===================================================
1.InformaticaRepositoryServer7.1.2
2.InformaticaPowerCenterServer7.1.2
0.Exit
Pleaseselectaproducttoinstall:
2
nstallingInformaticaPowerCenterServer7.1.2
Pleasespecifyadirectorytoinstallto[/user/infa/informatica/server]:
回车
/user/infa/informatica/serverdoesnotexist.create(y/n):
y
Installingmodulepmserver
Modulepmserverextractedsuccessfully.
Installingmodulepmmisc
Modulepmmiscextractedsuccessfully.
Installingmodulepmexes
Modulepmexesextractedsuccessfully.
Installingmodulepmlibs
Modulepmlibsextractedsuccessfully.
Installingmodulepmlocale
Modulepmlocaleextractedsuccessfully.
Installingmodulerw
Modulerwextractedsuccessfully.
Installingmoduleextproc
Moduleextprocextractedsuccessfully.
Installingmodulepmdpserv
Modulepmdpservextractedsuccessfully.
Installingmodulereposhr
Modulereposhrextractedsuccessfully.
Installingmodulepmdoc
Modulepmdocextractedsuccessfully.
Productspecificinstallationisstarting...
Key[KTMJ-XUGA-YVYP-QTCC-JYRU]addedtolicensefile.
========================
IMPORTANT:
Ifyouhaveconnectivityoroptionlicenses,youmustupdatethePowerCenterServerandRepositorylicensefilesafterinstallation.Formoreinformationonupdatinglicensefiles,seetheonlinehelp.
========================
+----------------------------------------------------+
InformaticaServerConfigurationUtility,version[7.1.2],build[0127],64-bit.
Copyright(c)InformaticaCorporation1996-2005.
AllRightsReserved.
+----------------------------------------------------+
Configurationfilename[pmserver.cfg]:
回车
ServerName[None]:
SHODS_TST_SEV
RepositoryName[RepositoryName]:
etl_tst
PMUser[Administrator]:
回车
PMPassword[*************]:
Administrator
RepServerHostName[RepositoryHostName]:
SHODS_TST_SEV
RepServerPortNumber[5001]:
回车
RepServerTimeout[60]:
回车
LogFileName[pmserver.log]:
回车
DataMovementMode[ASCII]:
Unicode
ValidateDataCodePages[Yes]:
回车
SessionLogInUTF8[No]:
回车
MaxSessions[10]:
回车
LMSharedMem[2000000]:
回车
PMCacheDir[.]:
回车
TimestampWorkflowLogMessages[No]:
回车
FailSessionIfMaxSessionsReached[No]:
回车
ExportSessionLogLibName[]:
回车
ErrorSeverityLevel(E[rror]|W[arning]|I[nfo]|T[race]|D[ebug])[info]:
回车
DateHandling40Compatibility[No]:
回车
Pmserver3XCompatability[0]:
回车
AggregateTreatNullAsZero[0]:
回车
AggregateTreatRowAsInsert[0]:
回车
JoinerSourceOrder6xCompatibility[No]:
回车
DateDisplayFormat[DYMONDDHH24:
MI:
SSYYYY]:
回车
TreatNullInComparisonOperatorsAs[Null]:
回车
LoadManagerAllowDebugging[Yes]:
回车
CreateIndicatorFiles[No]:
回车
XMLWarnDupRows[Yes]:
回车
OutputMetaDataForFF[No]:
回车
MaxLookupSPDBConnections[0]:
回车
MaxSybaseConnections[100]:
回车
MaxMSSQLConnections[100]:
回车
NumOfDeadlockRetries[10]:
回车
DeadlockSleep[0]:
回车
JVMDllPath[]:
回车
JVMClassPath[]:
回车
JVMMinMemory[32M]:
回车
JVMMaxMemory[64M]:
回车
TreatDBPartitionAsPassThrough[No]:
回车
WriterWaitTimeOut[60]:
回车
LicenseFileName[pm.lic]:
回车
Wouldyouliketoviewthereadmefilenow(y/n):
n
Pressentertocontinue...
……
===================================================
WelcometoInformaticaInstallationWizard.
AllInformaticaProductsCopyright1996-2005.
===================================================
1.InformaticaRepositoryServer7.1.2
2.InformaticaPowerCenterServer7.1.2
0.Exit
Pleaseselectaproducttoinstall:
0
选择0退出安装
5.更新LicenseFile
在/user/infa/informatica/server的安装目录下,执行pmlic命令,从而更新选项和连通性的KEY,使用语法如下:
pmlicupdate-keykeystring_to_add-licensefilelicense_file_name
$cd/user/infa/informatica/server
$pmlicupdate-keyKTMJ-XUGA-YVYP-QTCC-JYRU-licensefilepm.lic
$pmlicupdate-keyRCWB-MPHB-DVPP-IXTH-JYDE-licensefilepm.lic
$pmlicupdate-keyBCCL-APBZ-NOVA-PSSM-JYYY-licensefilepm.lic
也可以直接修改pm.lic文件(/user/infa/informatica/server/),在最后加上三行:
@CONNECTIVITYKEY=KBOC-BWEQ-ICEN-YMZK-GJQN
@OPTIONSKEY=HHBH-VSGS-NOZT-GHTK-GJZH
@PRODUCTKEY=KHPD-RFSP-QENN-IIEN-GJAJ
注:
此处license用于测试的,正式安装时候以Infoamtica公司提供的license为准。
6.启动RepositoryServer
1)启动pmrepserver
$cd/user/infa/informatica/repositoryserver/
$pmrepserver
Serverstartingup.
Usingconfigurationfromfile[/user/infa/informatica/repositoryserver/pmrepserver.cfg].
Loggingtofile[/user/infa/informatica/repositoryserver/pmrepserver.log].
Pleasecheckthelogtomakesuretheserverinitializedsuccessful
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Informatica安装AIX Ver52 ver12 Informatica 安装 AIX