This document is for informatica administration team, providing the detailed steps on installation of Power Center 9.1 on Linux & Oracle Environment.
Download Software from informatica Corporation and make sure to get proper keys based on environment (Dev/ Prod).
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>
SQL> SHOW parameter open_cursors;
NAME TYPE VALUE
————————————
———– ——————————
open_cursors integer 1000
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.
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 );
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
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
On UNIX, create a user account infa91
specifically to run the Informatica daemon required for installation having
group privileges’ on Oracle and java groups
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.)
Most UNIX
systems use the LANG variable to specify the desired locale
but you can use also the set locale function.
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
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
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
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:
-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
| 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. |
Use the
following guidelines to determine the port numbers: