This article talk about the installation of the data integration tool PowerCenter from Informatica.
Choose Oracle Business Intelligence / Oracle Business Intelligence (10.1.3) Media Pack for Microsoft Windows (32-bit) :
Then this two files :
The Oracle key (File2>Oracle_All_OS_Prod.key) is not valid for the installation of :
At least two database user accounts are required to host this repository :
For Oracle, you must perform the following instruction :
CREATE user POW_REP IDENTIFIED BY POW_REP
DEFAULT tablespace users
TEMPORARY tablespace temp
quota unlimited ON users;
GRANT connect, resource, create view TO POW_REP;
CREATE user POW_DOM IDENTIFIED BY POW_DOM
DEFAULT tablespace users
TEMPORARY tablespace temp
quota unlimited ON users;
GRANT connect, resource, create view TO POW_DOM;
You can find valuable information on the page 155 of the installation and configuration guide (PC_811_InstallationGuide.pdf)
This sequence of installation don't say that you have to hit the next button and does not take care of review and informative windows.
For Oracle : Oracle Database - How to retrieve the connect descriptor parameters? (host, port, service name and SID)
This information allow you to connect in the PowerCenter - Administration Console (http://HostPowerCenter:6001/adminconsole)
Then it create domain and node, analyze the system
Informatica Services is the Windows service that runs PowerCenter Services on a node in a PowerCenter domain. Configure the user account if PowerCenter Services needs to access a network location not available to the current Windows user account.
Installation Status : SUCCESS
The PowerCenter 8.1.1 installation completed successfully. The information below summarizes the location and
configuration of the installed products and components and status of the services.
Use the debug log file C:/Informatica/PowerCenter8.1.1/Informatica_Installation_Server_Debug.log for more information.
Installation Date : Fri Aug 07 12:42:44 CEST 2009
Product Name : PowerCenter 8.1.1
Chosen Install Set : Complete
Chosen Components : PowerCenter Services
Installation Directory : C:/Informatica/PowerCenter8.1.1
Shortcut Folder : Start > Programs > Informatica PowerCenter 8.1.1> Services
Configuration Properties
----------------------------
PowerCenter Services
--------------------------------
Administration Console URL: http://NGERARD:6001/adminconsole
Domain Name : Domain_NGERARD
Gateway Host Name : NGERARD
Administrator User Name : admin
Node Name : node01_NGERARD
Node Port Number : 6001 Repository
Name : PowerCenter
Repository Type : Oracle
Connection String : orcl
DB Username : POW_REP
Configuration Status
----------------------------
PowerCenter Domain Creation : Success
PowerCenter Ping Domain : Success
Repository Service Creation : Success
Repository Service Startup : Success
PowerCenter Repository Creation : Success
DI Service Creation : Success
DI Service Startup : Success
The installation debug log file can be found at : C:/Informatica/PowerCenter8.1.1/Informatica_Installation_Server_Debug.log
Double click on the file install.bat located in this directory : File1\pc811_windows32\Client\Disk1
It will install :
For the path, I leave the default because it doesn't contain space C:\Informatica\PowerCenter8.1.1
During the installation, you can see that it install a JRE.
When the installation has succeed, you will be able to read this message :
Installation Status : SUCCESS The PowerCenter Client 8.1.1 installation completed successfully.
The information below summarizes the location and configuration of the installed products and components
and status of the services.
Use the debug log file C:/Informatica/PowerCenter8.1.1/Informatica_Installation_Client_Debug.log for more information.
..............
Installation Status : SUCCESS
The PowerCenter 8.1.1 SP5 installation completed successfully.
The information below summarizes the location of the installed products .
For more information, see the debug log file at
C:\Informatica\PowerCenter8.1.1/Informatica_Installation_Server_SP5_Debug.log
Installed Components:
--------------------------
PowerCenter Services 8.1.1 SP5
You must restart Informatica Services to complete the installation.
Backed up server directory :
------------------------
C:\Informatica\PowerCenter8.1.1\server_Bak_from_SP5
Don't forget to perform the update process also for the clients. Relaunch the file file2>pc811sp5_win32_x86>install.exe and choose clients as option.
The file2 contain two fix : EBF189068 and EBF189069.