Install Informatica PowerCenter 8.6 on Windows 7

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，它將調用子目錄下的安裝程式(.ServerWindowsDisk1InstDataVMinstall.exe)。PowerCenter 沒有為Win 7/Win 2008特別定製的版本，所以在Win7上裝server端組件-> Create Domain的時候可能會遇到如下錯誤：

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更新]
  如果Windows 7上UAC開啟的情況下安裝PowerCenter Server, 還需要將installer.exe的admin privilege啟用，如下圖所示：

配置好之後再安裝Informatica Service輸入服務帳號時，先選擇用當前帳號進行安裝(因為上一步改變installer.exe的屬性預設只是目前使用者設定）。如果沒有正確設定，則可能在安裝Informatica服務時遇到如下錯誤：

Informatica Services Startup
===========================
Current time: 2011-Feb-26 21:49:32

Command Executed
----------------
"C:InformaticaPowerCenter8.6.0servertomcatbininfaservice.bat" install "InformaticaServices8.6.0" "Informatica Services 8.6.0" "InformaticaUser" "********"

Output of execution
-------------------
Output: Installing the service '"Informatica Services 8.6.0"' on node ******
Using CURRENT_DIR:      C:InformaticaPowerCenter8.6.0servertomcatbin
Using INFA_HOME:        C:InformaticaPowerCenter8.6.0
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.0servertomcatbininfaservice.bat" remove "InformaticaServices8.6.0"

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