Informatica Installation

This post describes the process of install and configure Informatica 9.1.0 HotFix 2.
Database used to store Informatica metadata is Oracle DB and is placed on the same machine.
Content:

1. Intallation of Oracle Database

2. Informatica Services installation

3. Startup, Shutdown and additional settings
4. Create PowerCenter Repository Service
5. Create PowerCenter Integration Service
6. Connect to repository from the client

Prerequisites

• OS:   SUSE Linux Enterprise Server 11 (x86_64)
• hostname:   etl-dev01
• domain:   domain
• Informatica installation files location:   /data/informatica/distr
• Oracle database installation files:   /data/oracle/distr
• SID:   etldev01
• Global database name:   etldev01.domain
• Character Set:   AL32UTF8
• ETL Domain Schema:   etl_dev01_domain
• ETL Repository Schema:   etl_dev01_rep01

1. Oracle Database Installation

1.01 Start Installation

runInstaller

1.02 Skip updates

Oracle Database 11g Release 2 Installer - Installing database - Step 1 of 9

Press Yes in alert window:

Email Address Not Specified

1.03 Select Create and configure a database

Oracle Database 11g Release 2 Installer - Installing database - Step 2 of 9

1.04 Choose System Class

Oracle Database 11g Release 2 Installer - Installing database - Step 3 of 9

1.05 Select Single instance type of database installation

Oracle Database 11g Release 2 Installer - Installing database - Step 4 of 10

1.06 Choose Advanced Install Type

Oracle Database 11g Release 2 Installer - Installing database - Step 5 of 10

1.07 Select English, Russian languages

Oracle Database 11g Release 2 Installer - Installing database - Step 6 of 13

1.08 Select Enterprise Database Edition

Oracle Database 11g Release 2 Installer - Installing database - Step 7 of 13

1.09 Specify Installation Location
Oracle Base: /data/oracle
Oracle Home: /data/oracle/product/11gR1/db

Oracle Database 11g Release 2 Installer - Installing database - Step 8 of 13

1.10 Specify Inventory Directory

Oracle Database 11g Release 2 Installer - Installing database - Step 9 of 13

1.11 Specify Database Identifiers

Oracle Database 11g Release 2 Installer - Installing database - Step 11 of 13

1.12 Specify Character Sets: AL32UTF8

Oracle Database 11g Release 2 Installer - Installing database - Step 12 of 13

1.13 Specify Management Options

Oracle Database 11g Release 2 Installer - Installing database - Step 13 of 21

1.14 Specify Database Storage Options:
Database File Liocation: /data/oracle/oradata

Oracle Database 11g Release 2 Installer - Installing database - Step 14 of 21

1.15 Specify Recovery Options

Oracle Database 11g Release 2 Installer - Installing database - Step 15 of 21

1.16 Specify Schema Passwords

Oracle Database 11g Release 2 Installer - Installing database - Step 16 of 21

1.17 Specify Privileged Operating System Groups

Oracle Database 11g Release 2 Installer - Installing database - Step 17 of 21

1.18 Summary

Oracle Database 11g Release 2 Installer - Installing database - Step 19 of 21

1.19 Installation

Oracle Database 11g Release 2 Installer - Installing database - Step 20 of 21

Execute Configuration scripts according information window instructions:

Execute Configuration scripts

Configuration Scripts

1.20 Installation successful

Oracle Database 11g Release 2 Installer - Installing database - Step 21 of 21

1.21 Create startup and shutdown scripts:

######################### startup.sh #########################
#!/bin/bash

export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_HOSTNAME=ETL-DEV01
export ORACLE_UNQNAME=etldev01
export ORACLE_BASE=/data/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11gR1/db
export PATH=/usr/sbin:$ORACLE_HOME/bin:$PATH
export ORACLE_SID=etldev01
ORAENV_ASK=NO

# Start Listener
/data/oracle/product/11gR1/db/bin/lsnrctl start

# Start Database
/data/oracle/product/11gR1/db/bin/sqlplus / as sysdba << EOF
STARTUP;
EXIT;

EOF

######################### shutdown.sh #########################
#!/bin/bash

export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_HOSTNAME=ETL-DEV01
export ORACLE_UNQNAME=etldev01
export ORACLE_BASE=/data/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11gR1/db
export PATH=/usr/sbin:$ORACLE_HOME/bin:$PATH
export ORACLE_SID=etldev01

ORAENV_ASK=NO

# Stop Database
/data/oracle/product/11gR1/db/bin/sqlplus / as sysdba << EOF
SHUTDOWN IMMEDIATE;
EXIT;
EOF

# Stop Listener

/data/oracle/product/11gR1/db/bin/lsnrctl stop

############################ dbora ############################
ORA_OWNER=oracle

case "$1" in
'start')
su $ORA_OWNER -c "/data/oracle/scripts/startup.sh 2>&1"
touch /var/lock/subsys/dbora
;;
'stop')
su $ORA_OWNER -c "/data/oracle/scripts/shutdown.sh 2>&1"
rm -f /var/lock/subsys/dbora
;;
esac

1.22 Test startup and shutdown

######################### dbora stop #########################
ETL-DEV01:/opt/oracle # /data/oracle/scripts/dbora stop

SQL*Plus: Release 11.2.0.1.0 Production on Sat Nov 30 18:45:38 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning option

SQL> Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning option

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 30-NOV-2013 18:45:46

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

The command completed successfully

######################### dbora start ########################
ETL-DEV01:/opt/oracle # /data/oracle/scripts/dbora start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 30-NOV-2013 18:45:55

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Starting /data/oracle/product/11gR1/db/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Log messages written to /data/oracle/diag/tnslsnr/ETL-DEV01/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ETL-DEV01.domain)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                30-NOV-2013 18:45:55
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Log File         /data/oracle/diag/tnslsnr/ETL-DEV01/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ETL-DEV01.domain)(PORT=1521)))
The listener supports no services
The command completed successfully

SQL*Plus: Release 11.2.0.1.0 Production on Sat Nov 30 18:45:55 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> ORACLE instance started.

Total System Global Area 6680915968 bytes
Fixed Size    2213936 bytes
Variable Size 3556771792 bytes
Database Buffers 3087007744 bytes
Redo Buffers   34922496 bytes
Database mounted.
Database opened.
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning option

2. Informatica 9.1.0 Installation

2.01 Start installation of Informatica in graphical mode
oracle@ETL-DEV01:~> /data/informatica/distr/install.sh 
OS detected is Linux
\****************************************************************
\* Welcome to the Informatica 9.1.0 HotFix 2 Server Installer.  *
\****************************************************************
Before you continue, read the following documents:
* Informatica 9.1.0 HotFix 2 Installation Guide and Release Notes.
* B2B Data Transformation 9.1.0 HotFix 2 Installation and Configuration Guide and Release Notes.

You can find the 9.1.0 HotFix 2 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 and later.
Current operating system Linux version 3.0.
Current operating system meets minimum requirements.
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 9.1.0 HotFix 1 installed.

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

-----------------------------------------------------------
Checking for existing 9.1.0 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.1.0 HotFix2 Services               (created with InstallAnywhere)

-----------------------------------------------------------------

2.02 Select Installation Type

Informatica 9.1.0 HotFix 2 - Installation Type

2.03 Read Pre-Requisites Info

Informatica 9.1.0 HotFix 2 - Installation Pre-Requisites

2.04 Select License file and Installation Directory

Informatica 9.1.0 HotFix 2 - License and Installation Directory

2.05 Read Pre-Installation Summary

Informatica 9.1.0 HotFix 2 - Pre-Installation Summary

2.06 Installation Progress

Informatica 9.1.0 HotFix 2 - Installing

2.07 Configuring Installation

Informatica 9.1.0 HotFix 2 - Installing

2.08 Domain Selection

• Create a domain
• Enable Transport Layer Security (TLS) for the domain
• Enable HTTPS for Informatica Administrator; Port: 8443
• Use a key store file generated by the installer

Informatica 9.1.0 HotFix 2 - Domain Selection

2.09 Domain Configuration Repository

• Database Type - Oracle
• Database user ID  - etl_dev01_domain
• Database address - ETL-DEV01:1521
• Database service name - etldev01.domain

Informatica 9.1.0 HotFix 2 - Domain Configuration Repository

2.10 Domain and Node Configuration

Informatica 9.1.0 HotFix 2 - Domain and Node Configuration

2.11 Post-Installation Summary

Informatica 9.1.0 HotFix 2 - Post-Installation Summary

3. Startup, Shutdown and additional settings

3.1 Informatica services management script infaservice.sh is located in /data/informatica/tomcat/bin/.
Call it with shutdown keyword for test services stop:
/data/informatica/tomcat/bin/infaservice.sh shutdown

3.2 Before start services we should set environment variables.
To facilitate the start process of informatica services I've midified /etc/profile adding several rows:
export INFA_JAVA_OPTS=-Xmx4096m
export INFA_DOMAINS_FILE=/data/informatica/domains.infa
export INFA_HOME=/data/informatica
export LD_LIBRARY_PATH=/data/oracle/product/11gR1/db/lib
export ORACLE_HOME=/data/oracle/product/11gR1/db
export PATH=$PATH:/data/oracle/product/11gR1/db/bin
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export ORA_CRS_HOME=/data/oracle/product/11gR1/db/crs
export ORACLE_SID=etldev01

3.3 To enable Informatica Services connect to Oracle Database we should set connection properties in tnsnames.ora and sqlnet.ora (/data/oracle/product/network/admin/):

######################### tnsnames.ora #########################

ETLDEV01 =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = ETL-DEV01)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = etldev01.domain)

    )

  )

######################### sqlnet.ora #########################

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

3.4 Restart machine.

Start Oracle Database:

/data/oracle/scripts/dbora start

Start Informatica Services:

/data/informatica/tomcat/bin/infaservice.sh shutdown

4. Create PowerCenter Repository Service

4.1 Login to Informatica Administrator console

Informatica Administration Console - Login

4.2 Select Actions - New - PowerCenter Repository Service in Domain Navigator

Informatica Administration Console - New PowerCenter Repository Service

4.3 Enter the name of new repository, select license and node

Informatica Administration Console - New PowerCenter Repository Service - Step 1 of 2

4.4 Specify database properties for repository service:
Database type: Oracle
Username: etl_dev01_rep01 (is created before)
Password: **********
Connection String: etldev01 (specified in tnsnames.ora)
Code Page: UTF-8 encoding of Unicode

Informatica Administration Console - New PowerCenter Repository Service - Step 2 of 2

4.5 Change Repository Operating Mode from Exclusive to Normal

Repository Properties - Edit

Edit Repository Properties

Edit Repository Properties - Operating Mode: Nornal

OK to restart the PowerCenter Repository Service

Restart Service

5. Create PowerCenter Integration Service

5.1 Actions - New - PowerCenter Integration Service

Informatica Administration Console - New PowerCenter Integration Service - Step 1 of 2

5.2 Enter the name of Integration Service

Informatica Administration Console - New PowerCenter Integration Service - Step 1 of 2

5.3 Specify the PowerCenter Repository Service and its login credentials:

Informatica Administration Console - New PowerCenter Integration Service - Step 2 of 2

5.4 Specify Code Pages

Specify Code Pages

5.5 Enable the Service

Enable PowerCenter Integration Service

Now, Informatica PowerCenter is ready for use.

6. Connect to repository from the client

6.1 Open Informatice PowerCenter Repository Manager on your client machine and choose Configure Domains from Repository menu.

Informatica PowerCenter Repository Manager

6.2 In the new window press Add a new domain button. In the dialog window enter connection parameters:
Domain Name: Domain_ETL_DEV01
Gateway Host: ETL-DEV01
Gateway Port: 6005

Add Domain

Click OK.

6.3 In the Configure Domains window select repository created before.

Configure Domains

6.4 Now we can connect to new repository from the client and manage it.

Connect to repository

-----
Hope this post help you to do first steps with Informatica PowerCenter. In any case it will help me next time.