Tuesday, June 12, 2012

Informatica PC 9.1 Installation Steps

TABLE OF CONTENTS

1 Overview   
2 Download Software               
3 Setup of Database Parameters, Users & Tablespace               
3.1  Database Parameter     
3.2  Repository Account       
3.3  Repository Tablespace 
4 Operating System   
4.1  Processor           
4.2  Temporary Disk Space Requirements    
4.3  UNIX User Account        
4.4  Port Validation 
5 Environment Variables 
5.1  Obtain the locale values               
6 File Descriptor  
7 Installation directory and Permission     
8 Pre-Installation System Check   
9 Initial Server Software Installation           
10 Port Configuration          
10.1 Guidelines for Port Configuration            

1           Overview 

This document is for informatica administration team, providing the detailed steps on installation of Power Center 9.1 on Linux & Oracle Environment.

 2       Download Software

Download Software from informatica Corporation and make sure to get proper keys based on environment (Dev/ Prod).

3           Setup of Database Parameters, Users & Tablespace

3.1            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

3.2            Repository Account

At least two database user accounts (Domain and Repository) are required to host repository, Taking sample names as
USER_REP for the repository Database
USER_DOM for the domain Configuration Database
Both user need to create with the CONNECT, RESOURCE, and CREATE VIEW privileges.
For Oracle, you must perform the following instruction:
CREATE USER USER_REP IDENTIFIED BY USER_REP
DEFAULT tablespace users
TEMPORARY tablespace temp
quota unlimited ON users;

GRANT CONNECT, resource, CREATE VIEW TO USER_REP;

CREATE USER UASER_DOM IDENTIFIED BY USER_DOM
DEFAULT tablespace users
TEMPORARY tablespace temp
quota unlimited ON users;

GRANT CONNECT, resource, CREATE VIEW, SELECT ANY dictionary TO USER_DOM;

The grant “select dictionary privilege” to the user INFA_DOM is only needed to verify the parameter Open_Cursor during the prerequisite check.
  
3.3            Repository Table-space

Set the storage size for the table-space 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 PC_TABLESPACE.
ALTER TABLESPACE "PC_TABLESPACE" DEFAULT STORAGE ( INITIAL 10K NEXT 10K MAXEXTENTS UNLIMITED PCTINCREASE 50 );

4      Operating System

4.1            Processor

Verify that the process match the software (x86_64)
Display the Linux platform =  uname - p
List the basic system information, OS release, and OS version  = uname -orv
-bash-3.2$ uname -p
x86_64

-bash-3.2$ uname –arv

Linux ServerName 12.66.18-164.el5 #1 SMP Thu Sep 3 04:15:13 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux

4.2            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 UNIX
1 GB
Informatica Services UNIX
2 GB
Verification of the temporary space with the df
-bash-3.2$  df -h /tmp

4.3            UNIX User Account

On UNIX, create a user account infa91 specifically to run the Informatica daemon required for installation having group privileges’ on Oracle and java groups

4.4            Port Validation

Verify that the port numbers are available on the machines where you install Informatica Services.
-bash-3.2$  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.
-bash-3.2$  netstat -tulpn|grep 6001
(Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.)
tcp        0      0 :::6001                     :::*                        LISTEN      4935/java
-bash-3.2$  netstat -tulpn|grep 6002
(Not all processes could be identified, non-owned process info  will not be shown, you would have to be root to see it all.)
tcp        0      0 ::ffff:127.0.0.1:6002       :::*                        LISTEN      4935/java
-bash-3.2$  netstat -tulpn|grep 6003
(Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.)
-bash-3.2$  netstat -tulpn|grep 6004
(Not all processes could be identified, non-owned process info will not be shown, you would have to be root to see it all.)
  
5           Environment Variables

Most UNIX systems use the LANG variable to specify the desired locale but you can use also the set locale function.

5.1            Obtain the locale values

To obtain the locale names for your UNIX system, enter the following:
infa@chetltst201 $ locale -a | grep -i en
en_AU
en_AU.iso88591
en_AU.utf8
en_BW
en_BW.iso88591
en_BW.utf8
en_CA
en_CA.iso88591
en_CA.utf8
en_DK
en_DK.iso88591
en_DK.utf8
en_GB
en_GB.iso88591
en_GB.iso885915
en_GB.utf8
en_HK
en_HK.iso88591
en_HK.utf8
en_IE
en_IE.iso88591
en_IE.utf8
en_IE@euro
en_IN
en_IN.utf8
en_NZ
en_NZ.iso88591
en_NZ.utf8
en_PH
en_PH.iso88591
en_PH.utf8
en_SG
en_SG.iso88591
en_SG.utf8
en_US
en_US.iso88591
en_US.iso885915
en_US.utf8
en_ZA
en_ZA.iso88591
en_ZA.utf8
en_ZW
en_ZW.iso88591
en_ZW.utf8
french
slovene
slovenian
  
6     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
Infa91   hard   nofile    3001
Infa91   soft   nofile    2500
And verify with the ulimit function logged as the power center system user account:
-bash-3.2$  ulimit -Hn
3001
The limit is set to 3001 to prevent an error with the value 300 during the prerequisites check

7   Installation directory and Permission

As root, create the installation base directory:
Pwd
/infa
mkdir /informatica
chown  755 informatica
cd informatica
mkdir pc91
chown 755 pc91
cd  /infa
mkdir software
chmod 755 software
As the installer (powercenter), copy the file to software directory, unzip and untar it:
-bash-3.2$ tar -xf 910HF3_Server_Installer_linux-x64.tar

-rw-r--r-- 1 infa91 infadmin 3990835200 May  1 19:30 910HF3_Server_Installer_linux-x64.tar
-bash-3.2$ tar -xf 910HF3_Server_Installer_linux-x64.tar

-bash-3.2$ ls -ltr
total 3901232
-rw-r--r-- 1 infa91 infadmin       2307 Sep  9  2011 SilentInput_upgrade.properties
-rw-r--r-- 1 infa91 infadmin       5093 Sep  9  2011 SilentInput_upgrade_NewConfig.properties
-rw-r--r-- 1 infa91 infadmin       5650 Sep  9  2011 SilentInput.properties
-rwxr-xr-x 1 infa91 infadmin      10674 Sep 16  2011 silentinstallHotFix.sh
-rw-r--r-- 1 infa91 infadmin        976 Sep 16  2011 SilentInput_hotFix.properties
-rw-r--r-- 1 infa91 infadmin        866 Sep 16  2011 SilentInput_DT.properties
-rwxr-xr-x 1 infa91 infadmin       4848 Nov 17 12:23 unjar_esd.sh
-rwxr-xr-x 1 infa91 infadmin      10683 Nov 17 12:23 silentinstall.sh
-rwxr-xr-x 1 infa91 infadmin      10723 Nov 17 12:23 silentinstallDT.sh
-rwxr-xr-x 1 infa91 infadmin      13242 Nov 17 12:23 install.sh
drwxr-xr-x 5 infa91 infadmin       4096 Nov 29 06:21 i9Pi
drwxr-xr-x 4 infa91 infadmin       4096 Nov 29 06:28 Server
drwxr-xr-x 2 infa91 infadmin       4096 Nov 29 06:28 Messages
drwxr-xr-x 3 infa91 infadmin       4096 Nov 29 06:28 upgrade_utils
drwxr-xr-x 2 infa91 infadmin       4096 Nov 29 06:28 properties
drwxr-xr-x 4 infa91 infadmin       4096 Nov 29 06:28 sapsolutions
drwxr-xr-x 4 infa91 infadmin       4096 Nov 29 06:28 saptrans
drwxr-xr-x 3 infa91 infadmin       4096 Nov 29 06:39 source
-rw-r--r-- 1 infa91 infadmin 3990835200 May  1 19:30 910HF3_Server_Installer_linux-x64.tar
-bash-3.2$ pwd
/infa/informatica/pc91

Change the permission of the file install.sh to execute
chmod -R 755 /infa/informatica/pc91/install.sh

8  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
-bash-3.2$  ./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...

-bash-3.2$ ./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...
Graphical installers are not supported by the VM. The console mode will be used instead...
Preparing CONSOLE Mode Installation...
===============================================================================
Informatica 9.1 PreInstall                       (created with InstallAnywhere)
-------------------------------------------------------------------------------
===============================================================================
Pre-Installation System Check
-----------------------------
Use this tool to verify that this machine meets the minimum system and database Requirements for installation of Informatica 9 services.

Run this tool before you run the Informatica server installer.

Respond to each prompt to proceed to the next step in the installation.  If you
want to change something on a previous step, type 'back'.

You may cancel this installation at any time by typing 'quit'.

PRESS <ENTER> TO CONTINUE:
===============================================================================
System and Database Information
===============================================================================
System and Database Information
-------------------------------
Drive to check (DEFAULT: ): /infa
Informatica starting port number (DEFAULT: ): 6001
===============================================================================
Domain Configuration Repository Database
----------------------------------------
Database Type
    1- Oracle
    2- DB2
    3- SQL
    4- Sybase

ENTER THE NUMBER OF THE DESIRED CHOICE: 1
ENTER THE NUMBER OF THE DESIRED CHOICE: 1
===============================================================================
Domain Configuration Repository Database
----------------------------------------------------------------------------------------------------------------------------------
Database user ID (DEFAULT: ): USER_DOM
User password (DEFAULT: ): USER_DOM
===============================================================================
Database Connection Type
----------------------------------------------------------------------------------------------------------------------------------
Custom String
    1- Yes
    2- No
ENTER THE NUMBER OF THE DESIRED CHOICE: 1
===============================================================================
Connection Configuration Repository Database
----------------------------------------------------------------------------------------------------------------------------------
Custom String (DEFAULT: ): pcd91


Installing...
----------------------------------------------------------------------------------------------------------------------------------

 [==================|==================|==================|==================]
 [------------------|------------------|------------------|------------------]
===============================================================================
System Check Report
-------------------
i9Pi System Check Summary:

TestStatusMessageInformatica9 Installation Directory /infa Informatica starting
port number  6001
Database Type  Oracle
Operating System Version   
Operating system version: 2.6.18-164.el5.
Disk Space   Available diskspace: 87,436 MB. Sufficient for installation.
Processors    Available number of processors: 10. Sufficient for installation.
RAM    Memory module identified: MemTotal:
98867016 kB. Physical Memory    Available physical memory: 96,549 MB.
Sufficient for installation.
Temporary Space    Available temporary diskspace: 55,697 MB. Sufficient for installation.
Ports    Port range 6,001 - 6,006: All port numbers available. 
LANG Environment Variable    LANG set to en_US.UTF-8; LC_ALL set to null.
JRE_HOME Environment Variable   
JRE_HOME environment variable is empty.
File Descriptors File descriptors limit set to 1024 It should be at least set to 3K.
Sybase Procedure/rule  Verify that the database user has the following privileges: Create Procedure and Create rule.

 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

9  Initial Server Software Installation


-bash-3.2$ ./install.sh
OS detected is Linux

\***************************************************************************
\* Welcome to the Informatica 9.1.0 HotFix 3 Server Installer.  *
\***************************************************************************

Before you continue, read the following documents:
* Informatica 9.1.0 HotFix 3 Installation Guide and Release Notes.
* B2B Data Transformation 9.1.0 HotFix 3 Installation and Configuration Guide and Release Notes.

You can find the 9.1.0 HotFix 3 documentation in the Product Documentation section at http://mysupport.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.16 and later. Current operating system Linux version 2.6.18. Current operating system meets minimum requirements.

Select to install or upgrade:

  1.Install or upgrade Informatica.
   Select this option if the machine does not have Informatica services installed
   or if it has Informatica 9.0.x or an earlier version installed.
   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

  2.Install Data Transformation Engine Only.
   Select this option to install only Data Transformation Engine.

  3.Select this option if the machine has Informatica 9.1.0 or an Informatica 9.1.0 hotfix installed.

Enter the choice(1,2 or 3):1

-----------------------------------------------------------
Checking for existing 9.1.0 HotFix 3 product installation.
Select (G)UI mode (needs X Window support) or (C)onsole mode (G/C):C
DISPLAY is not set. Cannot run installer in console mode.
Installer will run in console mode.
Select 'Y' to run in console mode, select 'N' to exit.
Do you want to continue? (Y/N)Y
Launching installer in console 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.1.0 HotFix3 Services               (created with InstallAnywhere)
-------------------------------------------------------------------------------
 
***************************************************************
Installation Type
**************************************************************
[ Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time. ]

Select to install or upgrade:
    * 1->Install Informatica 9.1.0 with HotFix 3.
Select this option to perform a full installation of Informatica 9.1.0 HotFix 3.
      2->Upgrade to Informatica 9.1.0 with HotFix 3.
Select this option to upgrade previous versions of Informatica products to Informatica 9.1.0 HotFix 3.
1
***************************************************************
Installation Pre-Requisites
**************************************************************
[ Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time. ]
Verify the installation pre-requisites and complete the
pre-installation tasks before you continue.
Disk Space Requirement: 4 GB
Memory Requirement (RAM): 4 GB
Database Requirements
- Requires Oracle, IBM DB2, Microsoft SQL Server or Sybase ASE.
- Database user account must have permission to create and drop tables
and views and insert, update, and delete data.
Pre-installation Tasks
- Verify that you have a valid license key.
- Set up a database user account for the domain configuration.
- Determine the port numbers to use for the node and domain services.
 
***************************************************************
License Key
**************************************************************
[ Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time. ]
Enter the license key file (default :- /home/infa91/license.key) : 
/infa/informatica/pc91/Dev_Licence_Key_2102_01_01.KEY

***************************************************************
Installation Directory
**************************************************************
[ Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time. ]
Enter the installation directory (default :- /home/infa91/Informatica/9.1.0) : /infa/informatica/pc91
***************************************************************
Pre-Installation Summary
**************************************************************
[ Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time. ]
Product Name     :      Informatica 9.1.0 HotFix 3 Services
Installation Type        :      Fresh Installation
Installation Directory   :      /infa/informatica/pc91
Disk Space Requirements
Required Disk Space      :      5,292 MB
Available Disk Space     :      80,565 MB
Press <Enter> to continue ...
***************************************************************
Installing
**************************************************************
 [==================|==================|==================|==================]
 [==================|==================|==================|==================]
 [==================|==================|==================|==================]
 [==================|==================|==================|==================]
===============================================================================
Configuring Installation...
---------------------------
 [==================|==================|==================|==================]
 [------------------|------------------|------------------|------------------]

***************************************************************
Domain Selection
**************************************************************
[ Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time. ]

    * 1->Create a domain
      2->Join a domain
:1

Enable Transport Layer Security (TLS) for the domain
      1->No
    * 2->Yes
:2
    * 1->Enable HTTPS for Informatica Administrator
      2->Disable HTTPS
:1

Port: (default :- 8443) :8443
      1->Use a keystore file generated by the installer
    * 2->Use an existing keystore file
:1
Generating keystore...
--
***************************************************************
Domain Configuration Repository
**************************************************************
[ Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time. ]
Configure the database for the domain configuration repository:
Database type:
    * 1->Oracle
      2->SQLServer
      3->DB2
      4->Sybase
:1
Database user ID: (default :- admin) :USER_DOM
User password: :
Configure the database connection
    * 1->JDBC URL
      2->Custom JDBC Connection String
:2

Custom String (default :- jdbc:informatica:oracle://host_name:port_no;ServiceName=) :jdbc:informatica:Oracle://11.22.333.111:1521;SID=pc91

***************************************************************
Domain and Node Configuration
**************************************************************
[ Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time. ]

Enter the following information for the Informatica domain.
Domain name: (default :- Domain_servername) :domain_abc_dev
Node host name: (default :- servername) :servername
Node name: (default :- node01_servername) :node1_abc_dev
Node port number: (default :- 6001) :6001
Domain user name: (default :- Administrator) :Administrator
Domain password: (default :- ) :
Confirm password: (default :- ) :
Display advanced port configuration page
      1->No
    * 2->Yes
:1

Defining domain...
-----------
Starting service...
--
Pinging domain...
-----
Pinging domain...
--
Pinging domain...
--
Adding license...
--
Pinging Administrator...
--
Pinging Administrator...
--
***************************************************************
Post-Installation Summary
**************************************************************
Installation Status SUCCESS
The Informatica 9.1.0 HotFix 3 installation is complete.
For more information, see the debug log file:
/infa/informatica/pc91/Informatica_9.1.0_Services_HotFix3.log
Installation Type :Fresh Installation
Informatica Administrator Home Page::
http://servername:6004
Product Name:  Informatica 9.1.0 HotFix 3 Services
Press <Enter> to continue ...
Installation Complete

10  Port Configuration


Port Type
Default
Description
Domain port
6005
Port number used by the domain.
Service Manager port
6006
Port number used by the Service Manager on the node. The Service Manager listens for incoming connection requests on this port. Client applications use this port to communicate with the services in the domain. This is the port that the Informatica command line programs use to communicate to the domain. This is also the port for the SQL data service JDBC/ODBC driver.
Service Manager shutdown port
6008
Port number that controls server shutdown for the domain Service Manager. The Service Manager listens for shutdown commands on this port.
Informatica Administrator port
6007
Port number used by the Administrator tool.
Informatica Administrator shutdown port
6009
Port number that controls server shutdown for the Administrator tool. The Administrator tool listens for shutdown commands on this port.
Range of ports for application services
6013 to 6113
Range of port numbers that can be assigned to the application service processes that run on the node. When you create an application service in the domain, the Service Manager assigns the first available port in this range to the service process. At a minimum, the number of ports in the range must be equal to the number of application service processes that will run on the node.

  

10.1            Guidelines for Port Configuration

Use the following guidelines to determine the port numbers:
  • The port number you specify for the domain and for each component in the domain must be unique.
  • The port number for the domain and domain components cannot be within the range of the port numbers that you specify for the application service processes.
  • The highest number in the range of port numbers that you specify must be at least three numbers higher than the lowest port number. For example, if the minimum port number in the range is 6400, the maximum port number must be at least 6403.
  • The port numbers that you specify for the domain, domain and node components, and application service processes cannot be lower than 1025 or higher than 65535.
  • Login to the Administration console with the Administrator user (Administration/Administrator)