PowerCenter - Installation and Configuration (8.1.1 for Windows 32Bit)

1 - About

This article talk about the installation of the data integration tool PowerCenter from Informatica.

3 - Prerequisites

3.1 - Download the files

  • The files for the software Informatica PowerCenter and PowerConnect Adapters 8.1.1 SP5 are available on Edelivery.com

Choose Oracle Business Intelligence / Oracle Business Intelligence (10.1.3) Media Pack for Microsoft Windows (32-bit) :

Then this two files :

  • File1 contain the initial software (server and client)
  • File2 contain the documentation and the patch / hot fix

The Oracle key (File2>Oracle_All_OS_Prod.key) is not valid for the installation of :

3.2 - Repository Account

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;

4 - Services / Server

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.

  • Frist, run File1\pc811_windows32\install.exe
  • Select an option to install : Server. Install Anywhere launch.
  • License key : select the license key text file in File2>Oracle_All_OS_Prod.key
  • Option Install for the first time
  • I leave the default directory C:\Informatica\PowerCenter8.1.1 (no space)
  • Review and install
  • As it's the first time, I choose “Create a new domain” option
  • PowerCenter Domain Configuration Metadata :

For Oracle : Oracle Database - How to retrieve the connect descriptor parameters? (host, port, service name and SID)

  • Unblock java
  • Powercenter service configuration : set the password (admin for instance)

Then it create domain and node, analyze the system

  • Next screen, I uncheck “Install Informatica Services with a different account user” because I will use it only on my laptop.

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.

  • Repository Configuration

  • Create integration service

  • Then you must get this message :
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  

5 - Client

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.
..............

6 - Patch

6.1 - Service Pack 15

  • next and when finish, you must have this message :
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.

6.2 - EBF - Fixe

The file2 contain two fix : EBF189068 and EBF189069.

  • unzip them
  • and copy the files :
    • in the PowerCenter_Home directory for the server file (EBF189068.Win32)
    • in the PowerCenter_Home\client\bin for the client file (EBF189068.Win32_Client)

7 - Reference

dit/powercenter/installation_811.txt · Last modified: 2018/02/16 09:04 by gerardnico