基于centos 6.5 的informatica power center 9的详细安装教程 ，基本配置
5.解压安装介质并给安装日录赋权限 a)解压 tar-xVf 961HF2 Server Installer linux- x64. tar-c infalnstall/ 赋归属权限 hown infa. oinstall -R infalnstall/ 6.关闭 Linux防火墙 service iptables stop rootGinfa home]# service iptables stop iptables: Setting chains to policy ACCEPt: filter OK iptables: Flushing firewall rules OK iptables: Unloading modules: OK 7.准备数据库用户并查看数据库字符集 a)创建用广(切换到 oracle用户) create user domain user identified by domain user create user rs user identified by rs user grant create view, connect, resource, select any table, select any dictionary to domain user rs user roct ninfa home] 5u- oracle Loraclcgirfa -]s sqlplus /nolog sQI*Plus: Release 11.2.0.I0 Production or. Fri Aug 14 19: 08: 03 2015 SQL> conn as sysdba Conrected sQI> create user rs user identified by rs user. SQI> grant create view, connect, resource, select any table, select any dictionary to domain user, rs user b)查看数据库字符集 SQI> select userenv('language)from dual; USERENV('LANGUAGE) AMERICAN AMERICA. AL 32UTF8 这里查看字符集是为了安装ina完成后配冒代码页的编码格式,让他们统一,不然会出 现乱码 安装 页 wstwinner@163.com 切换到infa用户,并cd到安装文件日录 [rooteinta homet su inta [infa@infa home]s cd infaInstall/ [infadinfa infaInstallls ll tota⊥156 drwxrwxr-x 2 infa oinstall 4096 Jan 16 2015 essaces drwxrwxr-x 6 infa oinstall 4096 Jan 16 2015 rw-rw-r--I infa oinstall 18500 Jan 16 2015 SilentInput properties rw-rw-r--1 infa oinstall 1789 Jan 16 2015 SilentInput propertles -rW-rW-r--1 infa oinstall 1178 Jan 16 2015 silent Input_hotFix. properties rw-rw-r--1 infa oinstall 4094 Jan 16 2015 silentInput upgrade properties infa oinstall 11941 Jan 16 2015 SilentInput upgrade New Config. properties rwxr-xr-x 1 infa oinstall 22975 Jan 16 2015 install. sh drwgrwxr-x 2 infa oinstall 4096 Jan 16 2015 p drwxrwxr-x4 infa oinstall 4096 Jan 16 2015 sapsolutions drwxrwxr-x 4 infa oinstall 4096 Jan 16 2015 saptrans rwxr-xr-x 1 infa oinstall 16890 Jan 16 2015 silentinstall, sh rwxr-xr-x1 infa oinstall 15836 Jan 16 2015 silentinstallDT sh rwxr-xr-x 1 infa oinstall 15168 Jan 16 2015 silentinstallhotfix sh drwxrwxr-x3 infa oinstall 4096 Jan 21 2015 rwxr-xr-X 1 infa oinstall 5299 Jan 16 2015 ungar esd. sh drwxrwxr-x 3 infa oinstall 4096 Jan 16 2015 upgrade utal 执行 installs,会时间长点,跟机器配置有关,耐心等待 infadinfa infaInstall]s ./install. sh os detected is linux unjar task is in progress∴…∴■ 出来后会让确认是否继续,前两次都是Y 洗择安装或升级 Select to install or upgrade 1. Install or upgrade Informatica Select this option if the machine does not have Infor 2. Install or upgrade Data Transformation Engine Only Select this option to install or upgrade only Data Tr 3. Apply Hotfix 2 to Informatica 9.6.1 Select this option if the machine has Informatica 9 Enter the choice (l, 2 or 3):1 选择安装 页4 wstwinner@163.com Select one of the following options: 1. Run the pre-Installation (19P1) System Check Tool 2. Run the informatica kerberos spn Format generator 3. Run the informatica services installation Select the option to proceed:(Default 3) 下面开始进入安装,必须在有 Xmanager的环境或直接在 Linux桌面 选择安装 Select to install or upgrade: 1->Install Informatica 9.6.1 HotFix Select this option to perform a full installation of inf ormatica 9.6.1 HotFix 2 2->Upgrade to Informatica 9.6.1 HotFix 2 Select this option to upgrade previous versions of Infor matica products to Informatica 9.6.1 HotFix 2 Enable Kerberos network authentication 2->Yes WHEN YOU SELECT AGREE AND INSTALL INFORMATICA PLATFORM, YOU AGREE TO BE BOUND BY THE PRODUCT USAGE TOOLKIT END USER LICENSE AGREEMENT, WHICH IS AVAILABLE AT: ht //www.informAticA.com/us/eula/en-support-eula.aspxasFurtHerDescRibedInThe EULA, YOUR USE OF THE INFORMATICA PLATEORM WILL ENABLE THE PRODUCT USAGE TOOLKI TO COLLECT CERTAIN PRODUCT USAGE AND FAILURE INFORMATION. YOU MAY DISABLE THIS FE ATURE AT ANY TIME. FOR MORE INFORMATION ON HOW TO DISABLE THIS FEATURE REFER THE INFORMATICA ADMINISTRATOR GUIDE I agree to terms and conditions 2->Ye5 安装前总结,按回车继续 Pre-installation tasks Obtain the Informatica license key Verify the minimum system requirements Set the environment variables Verify the port availability set up the keystore flle on UNIX, set the file descriptor limit On UNIX, configure POSIX asynchronous I/o Download and extract the informatica installer files Run the Informatica pre-Installation (i9pi) System Check Tool If you are enabling Kerberos network authentication, run the Informatica kerbe OS seN Format Generator Press <enter> to continue 关于Key 页5 wstwinner@163.com License Key step 3 of 7 大太大大大太大大k太大大k太太大太太大古大太大大太太太太大大大太太大太太太大大大太大太大太大太大太大大大大大大太大大大太太大大大大大大大太大大大大太大大大大 大含★太大大太大大大★大大士太太大大大★ Type 'back' to go to the previous panel or 'quit to cancel the installation at any time.] Enter the license key file (default :-/home/infa/license key) 大言★大大大大大大大大大大大大大大大大大大大★太大言大大大大大古大大太太大大大大大大大大大大大大太大大大古大大太大大大太大大大大太大大大古大大大大大大大大 大大★大大实大大女大大大大大大大大大大大大 Installation Directory - step 3 of 7 Type 'back' to go to the previous panel or 'quit to cancel the installation at any time ] Enter the installation directory (default :-/home/infaInformatica/9.6.1) 安装需求,回车继续… 士太大太太士太太士食★太太大 Pre-Installation Summary- step 4 of 7 Type back to go to the previous panel or quit to cancel the installation at any time. J Product name Informatica 9.6.1 hotfix 2 services Installation Type New Installation Installation Directory home/infa/Informatica/9.6.1 Disk Space Requirements Required Disk Space 7,378MB Available Disk Space 9,916MB press <enter> to continue 主程序安装,这步时间较长,跟机器配置有关,耐心等待 ★★实大★大大大★大★大大★★大士文★大 Installing- step 5 of 大大言次大大太大大大大大大太大大大 新建数据域 页6 wstwinner@163.com Type ' back' to go to the previous panel or 'quit to cancel the installation a any time.] 2->Join a domain 数据域配置 Enable secure communication for the domain 大1->No *1-enablehttpsforInformaticaadministrator 2->disablehttps 大女大大大女大大大大大大大大≮★大大大大大大女★大大大大大大大大大大大大大大大女大大大大★大大女大大大大大★大大大大太大大★大太大大大太女大大大大★大大大大大大 k言大大太太太大大太大大大大太大大大太大大 Domain Configuration Repositor Step 5B of 7 大太大大大太太大大大大大大大太大大大大大大太大大大太太大大大大大大太大大大大言大大大太大大大言大太大太大大大大大大太大大大大大太大大大言大大大太大大大大大大大 大大大大大大太大大太大大大大太大大大古大大 Type 'back to go to the previous panel or iquit' to cancel the installation at any time. Configure the database for the domain configuration repository: Database type: ★1-> oracle 2->SQLServer 3->DB2 4->Sybase 连接数据域的用户名和密码 atabase user id :(default admin): domain user User password Configure the database connection 大1-> UDBC URI 2->Custom JDBC Connection string 数据库仨息 页7 wstwinner@163.com Database address: (defau ost name: port no) :infa: Database service name: (default : -ServiceName):orcl Configure JDBC parameters 大1->Ye5 2->No 密钥文件生成 密码 Admin123456 路径默认 Information ! The encryption key will be generated in /home/infa/Informatica/9. 6.1/isp/config/keys with the file name sitekey. You must keep the name of the domain, the keyword forl the encryption key, and the encryption key file in a secure location. The domain name, keyword, and ncryption key are required when you change the encryption key for the domain or move a repository to another domain Select a choice 1->OK 数据域信息 Enter the following information for the Informatica domain Domain name: (default Domain infa) Node host name: (default : infa): Node name: (default : node01 infa) Node port number: (default -6005) Domain user name: (default : -Administrator Domain password: (default Confirm password: (default :-) Display advanced port configuration page 大1->NO >Yes 开始创建数据域了,跟本机配置有关,耐心等待…. Executing command Defining domain 页8 wstwinner@163.com 安装完成总结,回车继续. 大文大大文大大x大大大大大贪大大文大 Post-Installation Summary - step 7 of 7 ★文★★★士★★女文★★★大大★文文大丈太大大★太★文文★★太★★★女大★女大★★文丈★大太文丈文太大大★大★大★大★大大★文★文★太女太★★太大★ 大太大大太太大大太太大太k大大大大大太大 Installation status SUCCESS The Informatica 9.6.1 HotFix 2 installation is complete For more information, see the debug log file: yhomeinfa/Informatica/9. 6.1/Informatica_.6.1_Services_HotEix2log Installation Type: New Installation Informatica Administrator Home Page:: http://infa:6008 Product Name: Informatica 9.6.1 HotFix 2 Services Press <Enter> to continue 安装完成后 溱加infa的环境变量 [infadinfa -]s vi bash _profile export INFA_ HOME=/home/infa/ Informatica/9.6.1 export INFA_ CODEPAGENAME="utf8"#这里看数据库的字符集,要统一,不然乱码 export LD LIBRARY PATH=SINFA HOME/ java/bin: SINFA HOME/server/bin: SLD LIBRARY PATH export Path=SINFA HOME/server /bin: SINFA HOME: $PATH 然后让环境变量生效 source. bash_ profile 启动 infaservice服务 页 wstwinner@163.com [infadinfa infaInstalljs cd [infaginfa -]s vi . bash profile [infaginfa ]s vi bash profile [infadinfa ]s source bash profile infa@infa ]s cd/home/infa/Informatica/9.6.1/tomcat/bin/ [infa@infa bin]s 1l total 776 rwxr-xr-x1 infa infa 7624 Aug 14 19: 47 TestoDBCConnection sh rwxr-xr-x 1 infainfa 27861 Aug 14 19:47 bootstrap jar rwxr-xr-x 1 infa infa 2121 Aug 14 19:47 catalina-tasks xml -rwxr-xr-x 1 infainfa 20779 Aug 14 19: 47 catalina. sh rwxr-xr-x 1 infainfa 204944 Aug 14 19: 47 commmons-daemon-native. tar. gz rwxr-xr-x 1 infa infa 24283 Aug 14 19: 47 commons-daemon 3 rwxr-xr-x 1 infainfa 1922 Aug 14 19: 47 configtest sh -rwxr-xr-x 1 infa infa 1965 Aug 14 19:47 digest. sh rwxr-xr-x 1 infa infa 9197 Aug 14 19:47 infaservice sh rw-rw-r--1 infainfa 5552 Aug 14 20: 20 ispLogs log rw-rw-r--l infa infa 0 Aug 14 20: 17 ispLogslog Ick -rwxr-xr-x 1 infa infa 2540 Aug 14 19: 47 isplogging properties rwxr-xI-x 1 infainfa 3689 Aug 14 19:47 1og43xml rwxr-xr-x l infainfa 3459 Aug 14 19: 47 setclasspath sh rwxr-xr-x 1 infainfa 1902 Aug 14 19: 47 shutdown. sh rwxr-r-x 1 infa infa 1904 Aug 14 19: 47 startup. sh rwxr-xr-x 1 infa infa 38195 Aug 14 19: 47 tomcat-juli jar rwxr-xr-x1 infa infa 5024 Aug 14 19: 47 tool-wrapper, sh Eg2 rwxr-xr-x 1 infainfa 387417 Aug 14 19:47 tomcat-native ta rwxr-xr-x 1 infa infa 1908 Aug 14 19: 47 version. sh drwxrwxr-x 3 infa infa 4096 Aug 14 20: 17 workspace [infadinfa bin]$ ./infaservice sh startup 查看服务启动状态 netstat -antp grep 600 配置木地host文件 在本地 hosts文件中追加infa服务器的P和上机名 Hosts文件路径C: Windows System32 drivers\etc 登录控制中心 也可以直接敲P例如http://192.168.244.133:6008 6192.168.244. 133: 6008/administrator/ informatic铁路试点数据国铁路信息化数 6 CentOS6 VN B Informatica 6 CentOS65 Install Infor B Informatica 用户名 administrator 峦码 「登录 新建存储库服务 页 10 wstwinner@163.com