Saturday, December 29, 2012

PowerCenter - Installation and Configuration (9.0.1 for OEL Linux 64Bit)


  • Oracle Entreprise Linux 64 bit version 5 Update 5
  • Oracle Database 11gR2
After you complete the installation and configuration process, you have to log in to the Administrator tool to create and configure the following services:
  • PowerCenter Repository Service
  • PowerCenter Integration Service

Articles Related

Prerequisites

The platform

  • Linux: Linux - Installation
  • The oracle database must be already installed: Oracle Database 11gR2 - Installation on Linux OEL 5 Update 5 (x86_64)

Download the files

The files for the software Informatica PowerCenter and PowerConnect Adapters 9.0.1 are available on Edelivery.com
Choose:
  • Oracle Business Intelligence on Linux x86_64 and click Go
  • You must download this files:
The file “Informatica PowerCenter and PowerConnect Adapters Client 9.0.1” contains:
  • the Windows Client
  • the documentation
  • the license key

    The part 1 and 2 are multipart archive (.z01, .zip), you can use WinZip or Winrar to decompress it
The file “Informatica PowerCenter and PowerConnect Adapters 9.0.1 for Linux x86 (64-bit)” contains:
  • the server
  • the patch
The Oracle key (File2>Oracle_All_OS_Prod.key) is not valid for the installation of :
  • PowerCenter - Data Analyzer
  • and PowerCenter - Metadata Manager

Oracle Database

parameter

Set the open_cursors parameter to 1000
SQL> SHOW parameter open_cursor;
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
open_cursors                         integer     300
SQL> ALTER system SET open_cursors=1000;
 
System altered.
 
SQL>  ALTER system SET open_cursors=1000 SCOPE=BOTH;
 
System altered.
 
SQL> SHOW parameter open_cursors;
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
open_cursors                         integer     1000

Repository Account

At least two database user accounts are required to host this repository :
  • POW_REP for the repository Database
  • POW_DOM fro the domain Configuration Database
with the CONNECT, RESOURCE, and CREATE VIEW privileges.
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, SELECT ANY dictionary TO POW_DOM;
The grant “select dictionary privilege” to the user POW_DOM is only needed to verify the parameter Open_Cursor during the prerequisite check.

Repository Tablespace

Set the storage size for the tablespace to a small number to prevent the repository from using an excessive amount of space.
Also verify that the default tablespace for the user that owns the repository tables is set to a small size. The following example shows how to set the recommended storage parameter for a tablespace named POWERCENTER_DAC.
ALTER TABLESPACE "POWERCENTER_DAC" DEFAULT STORAGE ( INITIAL 10K NEXT 10K MAXEXTENTS UNLIMITED
PCTINCREASE 50 );

Operating System

Login as root

Processor

Verify that the process match the software (x86_64)
[root@di-obia-01 ~]# uname -p
x86_64
[root@di-obia-01 ~]# uname -orv
2.6.18-194.el5 #1 SMP Mon Mar 29 22:10:29 EDT 2010 GNU/Linux

Temporary Disk Space Requirements

The installer writes temporary files to the hard disk. When the installation completes, the installer deletes the temporary files and releases the disk space.
Installer UNIXGB
Informatica Services UNIXGB
Verification of the temporary space with the df commando: Linux - disk free command (df)
[root@di-obia-01 ~]# df -h /tmp
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
                       77G   16G   58G  22% /

User Account

On UNIX, create a user account specifically to run the Informatica daemon.
[root@di-obia-01 ~]# /usr/sbin/useradd powercenter
[root@di-obia-01 ~]# id powercenter
uid=502(powercenter) gid=506(powercenter) groups=506(powercenter)
[root@di-obia-01 ~]# passwd powercenter
Changing password for user powercenter.
New UNIX password:
BAD PASSWORD: it is WAY too short
Retype new UNIX password:
passwd: all authentication tokens updated successfully.

Port

Verify that the port numbers are available on the machines where you install Informatica Services.
[root@di-obia-01 ~]# netstat -tulpn|grep 6005
The installer validates the port numbers that you specify to ensure that there will be no port conflicts in the domain.

Environment Variables

Use LANG and LC_ALL to set the UNIX code page for the installer.

File Descriptor

Informatica service processes can use a large number of files. Set the Linux - File Descriptor limit per process to 3000 or higher.
In the file /etc/security/limits.conf, add this line:
# PowerCenter 
powercenter    hard   nofile    3001
powercenter    soft   nofile    2500
And verify with the ulimit function logged as the powercenter system user account:
[powercenter@di-obia-01 ~]$ ulimit -Hn
3001
The limit is set to 3001 to prevent an error with the value 300 during the prerequisites check 

Installation directory and Permission

As root, create the installation base directory:
mkdir -p /powercenter/9.0.1
chown -R powercenter:powercenter /powercenter
chown -R powercenter:powercenter /powercenter/9.0.1
chmod -R 775 /powercenter
chmod -R 775 /powercenter/9.0.1
As the installer (powercenter), copy the file to a tmp directory, unzip and untar it:
[powercenter@di-obia-01 powercenter901]$ unzip V26109-01.zip
Archive:  V26109-01.zip
  inflating: 901HF2_Server_Installer_linux-x64.tar
[powercenter@di-obia-01 powercenter901]$ tar -xf 901HF2_Server_Installer_linux-x64.tar
Change the permission of the file install.sh to execute
chmod -R 744 /tmp/powercenter901/install.sh

Server

Pre-Installation System Check

To verify whether a machine meets the system requirements for an Informatica installation, run the Pre-Installation System Check Tool (i9Pi) before you start the installation process.
You can find the i9Pi tool in the following directory: <InstallerExtractDirectory>/i9Pi
[powercenter@di-obia-01 i9Pi]$ ./i9Pi.bin
Preparing to install...
Extracting the JRE from the installer archive...
Unpacking the JRE...
Extracting the installation resources from the installer archive...
Configuring the installer for this system's environment...

Launching installer...


Enter the port 6004 to prevent a problem during the ckeck on the port 2010. The tool normally must verify until the port 6009 but check also the port 6010 which is the standard port for X Forwarding

A pdf is available in the tool directory if you want more information.
The report files are stored in the directory where you extract the Pre-Installation System Check tool files:
  • HTML format: <i9Pi Directory>/i9Pi/i9Pi_summary.html
  • Text format: <i9Pi Directory>/i9Pi_summary.log
i9Pi_summary.log
Output - Informatica9 Installation Location:/
Informatica starting port number:6004
Database Type:ORACLE
Database Hostname:di-rep-db
Database Port number:1521
Database Service name:direp.hotitem.local
Database User ID:POW_DOM
PASSED: OS Version Check: RHL  Version Identified is 2.6.18-194.el5
PASSED: Diskspace: Available DiskSpace is 55105 MB
PASSED: Processors: Available Processors is 2
PASSED: Physical Memory: Available RAM Size is 4242 MB
PASSED: Temporary Space: Available temporary diskspace: 55105 MB. Sufficient for installation
PASSED: Socket Port: Socket port Range 6004-6009
PASSED: LANG Environment Variable: LANG Set to en_US.UTF-8 and LC_ALL Set to null
PASSED: JRE_HOME Environment Variable: JRE_HOME is not set
PASSED: File Descriptors : File descriptors limit is 3001
PASSED: Oracle Open Cursors: Open cursors in Oracle database is set to 1000Sufficient for install
PASSED : Resource privilege : The user account has the RESOURCE privilege.
PASSED: Create Table check : Successfully created a database table.
PASSED: Create View : Successfully created a database view.

Initial Server Software Installation

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.
[powercenter@di-obia-01 /]$ unset JRE_HOME
[powercenter@di-obia-01 /]$ /tmp/powercenter901/install.sh
OS detected is Linux
unjar task is in progress.............
You can wait a long time on this step ….
unjar of ESD completed.....
Do you want to continue installation (y/n) ?
y
Starting installation ...
 
 
\***************************************************************************
\* Welcome to the Informatica 9.0.1 HotFix 2 Server Installer.  *
\***************************************************************************
 
 
To verify whether a machine meets the system requirements for an Informatica installation, run the
 Pre-Installation System Check Tool (i9Pi) before you start the installation process. You can find the i9Pi 
tool in the following directory: <InstallerExtractDirectory>/i9Pi
 
 
Before you continue, read the 9.0.1 HotFix 2 Installation Guide and Release Notes.
You can find the 9.0.1 HotFix 2 documentation in the Documentation Center at http://my.informatica.com
Configure the LANG and LC_ALL variables to generate appropriate code pages and
create and connect to repositories and Repository Services.
Do you want to continue? (Y/N)Y
Installer requires operating system Linux version 2.6 and later.
Current operating system Linux version 2.6.
Current operating system meets minimum requirements.
 
 Select a choice :
1.   Install Informatica 9.0.1 with Hot Fix 2 or Upgrade from a previous version of Informatica to
 Informatica 9.0.1 with Hot Fix 2
2.   Apply Informatica 9.0.1 Hot Fix 2 to existing 9.0.1 install.
Enter the choice(1 or 2):1
 
-----------------------------------------------------------
Checking for existing 9.0.1 HotFix 2 product installation.
Select (G)UI mode (needs X Window support) or (C)onsole mode (G/C):G
Launching installer in GUI mode ...
Preparing to install...
Extracting the JRE from the installer archive...
Unpacking the JRE...
Extracting the installation resources from the installer archive...
Configuring the installer for this system's environment...
 
Launching installer...
 
Preparing SILENT Mode Installation...
 
===============================================================================
Informatica 9.0.1 Services HotFix2               (created with InstallAnywhere)
-------------------------------------------------------------------------------
Informatica 9.0.1 HotFix 2 Steps:
  • Installation Type: Install (and not upgrade)
  • Pre-requisites: Next
  • License and Directory. (Transfer the license file from the client zip file)
















  • Pre-Installation Summary: Install (Required Disk Space 2815 MB)
    Domain Creation: Create a domain
  • Configuration Database
 
with as JDBC parameters:
MaxPooledStatements=20;CatalogOptions=0;BatchPerformanceWorkaround=true
  • Domain Configuration
  • Post-Installation Summary
Installation Status:: SUCCESS 
The Informatica 9.0.1 HotFix 2 installation is complete.  

For more information, see the debug log file: 
/powercenter/Informatica/9.0.1/Informatica_9.0.1_Services_HotFix2.log  

Informatica Administrator Home Page http://di-obia-01.hotitem.local:6007  
Product Name : Informatica 9.0.1 HotFix 2  

Installation Type : Fresh Installation  
Installation Directory : /powercenter/Informatica/9.0.1   
  • Login to the Administration console with the Administrator user (Administration/Administrator)

Repository Configuration

  • Start Informatica services. Start > All Programs > Informatica PowerCenter 8.6.1 > Services > Start Informatica Services.
  • Launch the Administration console. Start > All Programs > Informatica PowerCenter 8.6.1 > Services > PowerCenter Administration Console
  • Login with the account given in the configuration (admin/admin for this article).
  • Select configuration assistant (if you don't see it, you can also configure a repository with the configuration tool on the left side)
  • Welcome > Next
  • Enter a name for the repository, click on the configure button and fill in the fields. 

    You must enter a connect identifier and not a connect string. The connect string for Oracle contains the credentials.

























1


If the creation of the repository hang, try to give the DBA privileges to the oracle database account POW_REP
  • Integration service: fill a name in : INT_OBIA7961 and click next.
  • Character Data for Integration service: (Note: Character Encoding give the choice between ASCII and Unicode)
  • Finish !

    A global administrator (for the domain and the repository) is automatically created during the installation with the credentials Administrator/Administrator. You may change the password for security purpose

Client

Installation Steps:
  • Double click on the file install.bat located in this directory : File1\pc861_client_win32_x86\
  • Choose Language. Next
  • Choose Install Option. Next
  • Prerequisites. Next
  • Installation directory For the path, you can leave the default value because it doesn't contain space C:\Informatica\PowerCenter8.6.1
  • Pre-installation summary. Next
  • Post-installation summary. Next
  • Installation Complete. Done
Hot Fix 10 installation:
  • file2>pc861_HotFix10_Client\install.bat
  • Select Language. Ok
  • Welcome. Next. Stop PowerCenter. Ok
  • Installation Prerequisites. Next
  • Installation Type: Apply. Next
  • Installation Directory. Next
  • Pre-installation summary. Next
  • Post-installation summary. Next
  • Installation Complete. Done
It will install :
  • PowerCenter - Client
    • PowerCenter - Designer
    • PowerCenter - Repository Manager
    • PowerCenter - Workflow Manager
    • PowerCenter - Workflow Monitor
    • PowerCenter Mapping Architect for Visio (Data Stencil?)
  • Custom Metadata Configurator
The metadata manager console is not installed as in the installation of the version 8.1.1.

Support

The creation of the repository hangs

The creation of the repository can take maximum 2 minutes.
If you don't see the creation of tables in the POW_REP schema:
  • close the browser,
  • connect again to the administation console and go through the configuration button in the left upper side
If it doesn't work
  • give the DBA privileges to the oracle database account POW_REP
  • and try to create it again