Installing and Setting Up Informatica PowerCenter
Oracle Business Intelligence Applications Installation Guide for Informatica PowerCenter Users
In this guide, INFA_HOME refers to the user-specified Informatica installation
directory on the machine that hosts Informatica PowerCenter Services. For
example, if you have installed Informatica PowerCenter Services into a directory
named \informatica\9.0.1\, then INFA_HOME is \informatica\9.0.1\. For more
information about Home locations, see
Section 4.1.1, "Summary of Oracle Home
Locations Used in this Guide."
You need to determine the machines that will host Informatica PowerCenter Client
Tools and Informatica PowerCenter Services. The PowerCenter Services can be
installed on UNIX or on Windows. The PowerCenter Client Tools must be
installed on Windows.
You must co-locate the DAC Client with the Informatica PowerCenter Client Tools.
You must co-locate the DAC Server with Informatica PowerCenter Services.
DAC produces parameter files that are used by Informatica. If an execution plan
fails in DAC and you want to debug the workflow by running it directly from
Informatica, then the parameter file produced by DAC should be visible to
Informatica. This is one reason for the requirement to co-locate the DAC and
Informatica components as stated above.
You must meet all requirements and complete preinstallation tasks as described in
Section 4.3, "Mandatory Requirements"
and in the chapter 'Before You Install' of
the PowerCenter Installation and Configuration Guide.
When you install PowerCenter Services and Client Tools version 9.0.1 and Hotfix
2, use the Informatica PowerCenter installation documentation in conjunction with
the steps provided in the following sections. This guide summarizes the steps and
assumes a single-machine installation for the PowerCenter Services components.
If you are using a Windows Vista operating system, note the following:
The DAC Client uses the Informatica pmrep and pmcmd command line programs
when communicating with Informatica PowerCenter. The installation of
PowerCenter Client Tools provides the pmrep executable file. The installation of
PowerCenter Services provides the pmcmd executable file. The DAC installer
performs post-install configuration tasks related to the pmrep and pmcmd
executable files. Therefore, you must run the run the PowerCenter Services
installer on the Windows Vista machine where you will install the DAC Client.
This installation of Informatica PowerCenter Services will be a non-functional
installation because Informatica does not support PowerCenter Services on
When installing PowerCenter Services on Windows Vista, you might receive an
error message similar to the following. You can ignore any such error messages.
Use the error below and catalina.out and node.log in the
server/tomcat/logs directory on the current machine to get
more information. EXITCODE: S" Select Retry to continue the
If you have licensed Informatica PowerCenter separately from
Oracle BI Applications, skip this section and go to section
Section 4.6.5, "Restoring the Pre-built Informatica Repository."
Make sure that you have installed the required version of Informatica
PowerCenter (for more information, see
Section 4.3.2, "Informatica