Oracle的官网上有它OEM版的Informatica PowerCenter 8.6,支持以SQL Server数据库作为service master db:
http://www.oracle.com/technology/global/cn/software/products/ias/htdocs/101320bi.html
以上网页中的 <Informatica PowerCenter and PowerConnect Adapters 8.6> 段中file1为8.6的安装文件(包括server 和client),file2为hotfix4。在file2的Informatica PowerCenter 8.6.0 for Windows 32Bit目录下有个Oracle_All_OS_Prod.key文件,用于eva版本安装的licensing. 安装server端组件安装步骤:
1. 找到file1的PowerCenter_8.6.0_SE_for_Windows_32bitpc86_win32_x86目录下的install.bat,它将调用子目录下的安装程序(.ServerWindowsDisk1InstDa
The installer able to create Domain but could not create the node.
Error:
Error Message:
cannot start Informatica Services. Use the error below and catalina.out and node.log in the server/tomcat/logs directory on the current machine to get more information. Select Retry to continue the installation.
EXIT CODE: S
但这时候部分Binary和registry已经被改动了,即使结束安装程序,之后也必须从Add/Remove Programs手动删除PowerCenter,删除完需要reboot。清理现场之后,可以将install.exe改为以WinXP SP2或者Win2000的兼容模式运行,再重新安装,就可以正常地Create Domain了。
2. 继续安装,在配置Informatica Service之后,还需要连接到这个domain。但是你会发现Informatica Service在启动5秒之后会自动停止,所以安装程序的ping domain无法完成。在C:InformaticaPowerCenter8.6.1servertomcatlog日志中可以看到如下错误:
2010-05-19 17:54:03,258 FATAL [main] [PCSF_10420] Failed to initialize the repository utility with native code because: [no pmjrepn in java.library.path].
java.lang.UnsatisfiedLinkError: no pmjrepn in java.library.path
解决方案是在System Variable的path中加上server的bin目录(默认为C:\Informatica\PowerCenter8.6.0\server\bin), 不需要重启,这个时候要到服务列表中
找到informatica service服务然后手动启动。直接Retry即可。
[2011-02-26更新]
配置好之后再安装Informatica Service输入服务账号时,先选择用当前账号进行安装(因为上一步改变installer.exe的属性默认只是当前用户设置)。如果没有正确设置,则可能在安装Informatica服务时遇到如下错误:
Informatica Services Startup
===========================
Current time: 2011-Feb-26 21:49:32
Command Executed
----------------
"C:InformaticaPowerCenter8.6.0servertomcatbininfaserv
Output of execution
-------------------
Output: Installing the service '"Informatica Services 8.6.0"' on node ******
Using CURRENT_DIR:
Using INFA_HOME:
The service '"Informatica Services 8.6.0"' has been installed.
Error: The filename, directory name, or volume label syntax is incorrect.
The service name is invalid.
More help is available by typing NET HELPMSG 2185.
ExitCode: 2
Removing Informatica Services
==========================
Current time: 2011-Feb-26 21:49:32
Command Executed
----------------
"C:InformaticaPowerCenter8.6.0servertomcatbininfaserv
Output of execution
-------------------
Output: Removing the service 'Informatica Services' on node ********
The service 'Informatica Services' has been removed
Error: The service name is invalid.
More help is available by typing NET HELPMSG 2185.
The filename, directory name, or volume label syntax is incorrect.
ExitCode: 0