Ingredients:

Program	Version	Filename
Oracle Express 11G	11.2.0	oracle-xe-11.2.0-0.5.x86_64.rpm
SQL Developer	3.0	sqldeveloper-3.0.04.34-1.noarch.rpm
Informatica Powercenter	9.1	901HF2_Server_Installer_linux-x64.tar
Oracle Enterprise Linux	5.6	Enterprise-R5-U6-Server-x86_64-dvd.iso

For this demonstration Oracle Enterprise Linux (a.k.a. “Unbreakable Linux”) was used. Installed in a virtual environment with 1,5GB RAM and a 25GB harddisk.

In order to get Informatica Powercenter up and running on a server, you would typically need a database first. Otherwise it would be hard for the application to store it’s meta-data anywhere. Since this is an example, a not so large database was used; Oracle Express 11G.

Installation Oracle Express 11G
It’s important to check the free space in our memory first. Oracle XE needs around 4GB of swap memory for its installation. So let’s open a command line and check the memory using the command free

[root@fusionapps install]# free
total used free shared buffers cached
Mem: 1531688 1441668 90020 0 16128 1175480
-/+ buffers/cache: 250060 1281628
Swap: 2064376 0 2064376

Installation of the Operating System was with almost all default settings. This also means the amount of swap memory wasn’t changed. This needs to be raised before starting the installer package.

[root@fusionapps install]# dd if=/dev/zero of=/swapfile bs=1024 count=2048000
2048000+0 records in
2048000+0 records out
2097152000 bytes (2.1 GB) copied, 28.0329 seconds, 74.8 MB/s

[root@fusionapps install]# /sbin/mkswap /swapfile
Setting up swapspace version 1, size = 2097147 kB
[root@fusionapps install]# /sbin/swapon /swapfile
[root@fusionapps install]# free
total used free shared buffers cached
Mem: 1531688 1441404 90284 0 16416 1174944
-/+ buffers/cache: 250044 1281644
Swap: 4112368 0 4112368

This should do it, now onto the installation of the database itself. Locate the package and run it withrpm -i oracle-xe-11.2.0-0.5.x86_64.rpm. This should result into the following:

[root@fusionapps install]# rpm -i oracle-xe-11.2.0-0.5.x86_64.rpm
Executing post-install steps…

You must run ‘/etc/init.d/oracle-xe configure’ as the root user to configure the database.

Fine, looks alright even though you can’t see what it has done. Basically your database software is ready to be used, yet no database yet. So let’s do what the package told us to do, execute the command /etc/init.d/oracle-xe configure.

[root@fusionapps admin]# /etc/init.d/oracle-xe configure

Oracle Database 11g Express Edition Configuration
————————————————-
This will configure on-boot properties of Oracle Database 11g Express Edition. The following questions will determine whether the database should be starting upon system boot, the ports it will use, and the passwords that will be used for database accounts. Press to accept the defaults.
Ctrl-C will abort.

Specify the HTTP port that will be used for Oracle Application Express [8080]:

Specify a port that will be used for the database listener [1521]:

Specify a password to be used for database accounts. Note that the same
password will be used for SYS and SYSTEM. Oracle recommends the use of
different passwords for each database account. This can be done after
initial configuration:
Confirm the password:

Do you want Oracle Database 11g Express Edition to be started on boot (y/n) [y]:

Starting Oracle Net Listener…Done
Configuring database…Done
Starting Oracle Database 11g Express Edition instance…Done
Installation completed successfully.

At each question the answer is to hit the enter button so that the default values stay as they are. Only exception to this is where you need to enter a password for your database.
Now to test if a connection can be made to the database. Look at the top left menu and selectApplications > Oracle Database 11g Express Edition > Run SQL Command Line and review the following:

SQL> connect system/xe@xe
Connected.

SQL> select name from v$database;
NAME
—-
XE

SQL>

This looks right, the database is up and running. The installation of SQLDeveloper can begin. Note that this is not really needed, but some people prefer a more graphical way of doing their queries and other database tasks.

Installation SQLDeveloper
This installation is pretty straight forward. Look up the package and run the following from the command line: rpm –i sqldeveloper-3.0.04.34-1.noarch.rpm
This should give you:

[root@fusionapps install]# rpm -i sqldeveloper-3.0.04.34-1.noarch.rpm
[root@fusionapps install]#

Now when you look in the Applications menu, there should be a menu item called SQL Developer under the Programming submenu.

Installation Powercenter 9.1
In order to begin the installation of Powercenter there are some prerequisites that need to be met first:

Going through these ingredients one by one;

4GB disk space, check
We have an Oracle database, check
Database user account is not there yet, to do
Valid license key, Oracle provides one with the download from eDelivery. This isn’t meant for production purposes, but it’s very useful when trying installations like these, check
Database user for domain configuration can be the same as point 4, to do
Port numbers is useful to align for yourself, but since this is a totally new system we’ll use the default ports Powercenter issues (i.e. 6005-6007 and some others4GB RAM, not needed at all. For this installation a virtual machine was used with 1,5GB of RAM and it had no problem installing Powercenter at all, so check

Conclusion of the ingredients list is one more task that isn’t done yet, create a database user that Powercenter can use to do its work.

SQL> create user informatica identified by password;
User created.

SQL> grant all privileges to informatica;
Grant succeeded.

SQL>

With above statements this final task is complete as well. So with all the boxes checked the installation of Powercenter can begin.
Lookup your downloaded Powercenter installation file (901HF2_Server_Installer_linux-x64.tar) and untar it at a destination of your choice. Then it’s just a case of starting the install.sh file.

[admin@fusionappsIPC9.1]$ . install.sh
OS detected is Linux
unjar task is in progress………….
unjar of ESD completed…..
Do you want to continue installation (y/n) ?

Unjarring the files will take a while, obviously depending on your system specifications. When the installer asks to continue, the answer is y for yes.

Starting installation …

\***************************************************************************
\* Welcome to the Informatica 9.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: /i9Pi

Before you continue, read the 9.1 HotFix 2 Installation Guide and Release Notes.
You can find the 9.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)

A lot of information, so it’s wise to read them before continuing. At the end it says not to forget to set some variables. This is wise to check with the export command. When all is well, we can move on by typing y for yes again.

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.1 with Hot Fix 2 or Upgrade from a previous version of Informatica to Informatica 9.1 with Hot Fix 2
2. Apply Informatica 9.1 Hot Fix 2 to existing 9.0.1 install.
Enter the choice(1 or 2):

Now we need to choose the installation that we want. In this case option 1 is the way to go, nothing is installed yet so no need to apply just a hotfix.

———————————————————–
Checking for existing 9.1 HotFix 2 product installation.
Select (G)UI mode (needs X Window support) or (C)onsole mode (G/C):

Next question is the type of installer that we want to use. Let’s be lazy and use a graphical interface (ideal for cheering up this bunch of text with some screenshots).
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.1 Services HotFix2 (created with InstallAnywhere)
—————————————————————————

After choosing G for GUI mode the installer will start it up with the above information. After this is done, a window opens and the graphical installer is launched.

First window let’s you choose the type of installation. Funny enough we already gave an answer to this question, but there’s no harm in answering again.

The list of prerequisites is next. You’ve seen this list before (scroll up if you missed it) and all should be good at this point. So onto the next one.

This is where we actually need to do something; showing the installer where our license key is located and where Powercenter should be installed.

The installer then gives you a small summary of what was chosen. If this looks good then the actual installation can begin by pressing the Install button.

Configuration is the next task the installer wants to do. For this fresh installation we’ll be making a brand new domain. If for any reason there is a need to join an already existing domain then the second option is the way to go.

As per default the HTTPS option is enabled. No reason to untick it if you don’t have or don’t want to add a legitimate certificate. The installer can make a dummy one for you. Not only in this case, but also with a production machine this would be harmless. Simple reason is that Powercenter is installed based on the hostname. So if you’re not on that hostname, you can’t login to the administration console. This basically means that by default you can’t use the administration console outside of the server. This can be configured however, so when you decide to do that, it would be wise to install legitimate certificates.

Next the installer wants to know where to install all its information. This is where the database user informatica comes in. And since the database is on the same machine as Powercenter will be, it’s no problem using localhost as the address for the database.

By using the button Test connection the installer enables you to check if you didn’t make any typo’s:

Final window before the Powercenter installation is properly configured is where information is requested on the domain that needs to be created.

And if all goes well, the last screen you’ll see is the one below stating this installation was a success.

And there you go, a freshly installed Informatica Powercenter 9.0.1. Ready to be decorated with repositories and to be used with (for example) Oracle Fusion Applications feeding Oracle BI components.

Informatica PC 9.1 Installation Steps using command mode

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

===============================================================================

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.

***************************************************************

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

Enable Transport Layer Security (TLS) for the domain

1->No

* 2->Yes

* 1->Enable HTTPS for Informatica Administrator

2->Disable HTTPS

Port: (default :- 8443) :8443

1->Use a keystore file generated by the installer

* 2->Use an existing keystore file

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

Database user ID: (default :- admin) :USER_DOM

User password: :

Configure the database connection

* 1->JDBC URL

2->Custom JDBC Connection String

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

Defining domain...

-----------

Starting service...

Pinging domain...

-----

Pinging domain...

Adding license...

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)

Kishore Analytics Solutions

Saturday, February 16, 2013

Installation Informatica Powercenter 9.1 on Oracle Enterprise Linux 5.6

Ingredients:

Informatica PC 9.1 Installation Steps using command mode

1 Overview

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

3.1 DATABASE PARAMETER

3.2 REPOSITORY ACCOUNT

4 Operating System

4.1 Processor

4.2 TEMPORARY DISK SPACE REQUIREMENTS

4.3 UNIX USER ACCOUNT

4.4 PORT VALIDATION

5.1 OBTAIN THE LOCALE VALUES

7 Installation directory and Permission

8 Pre - Installation System Check

9 Initial Server Software Installation

10 Port Configuration

10.1 Guidelines for Port Configuration