- Oracle Entreprise Linux 64 bit version 5 Update 5
- Oracle Database 11gR2
After you complete the installation and configuration process, you have to log in to the Administrator tool to create and configure the following services:
- PowerCenter Repository Service
- PowerCenter Integration Service
Articles Related
- PowerCenter - Installation
Prerequisites
The platform
- Linux: Linux - Installation
- The oracle database must be already installed: Oracle Database 11gR2 - Installation on Linux OEL 5 Update 5 (x86_64)
Download the files
The files for the software Informatica PowerCenter and PowerConnect Adapters 9.0.1 are available on Edelivery.com
Choose:
- Oracle Business Intelligence on Linux x86_64 and click Go
- You must download this files:
The file “Informatica PowerCenter and PowerConnect Adapters Client 9.0.1” contains:
- the Windows Client
- the documentation
- the license key
The part 1 and 2 are multipart archive (.z01, .zip), you can use WinZip or Winrar to decompress it
The file “Informatica PowerCenter and PowerConnect Adapters 9.0.1 for Linux x86 (64-bit)” contains:
- the server
- the patch
The Oracle key (File2>Oracle_All_OS_Prod.key) is not valid for the installation of :
- PowerCenter - Data Analyzer
- and PowerCenter - Metadata Manager
Oracle Database
parameter
Set the open_cursors parameter to 1000
SQL> SHOW parameter open_cursor;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
open_cursors integer 300
SQL> ALTER system SET open_cursors=1000;
System altered.
SQL> ALTER system SET open_cursors=1000 SCOPE=BOTH;
System altered.
SQL> SHOW parameter open_cursors;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
open_cursors integer 1000
Repository Account
At least two database user accounts are required to host this repository :
- POW_REP for the repository Database
- POW_DOM fro the domain Configuration Database
with the CONNECT, RESOURCE, and CREATE VIEW privileges.
For Oracle, you must perform the following instruction :
CREATE USER POW_REP IDENTIFIED BY POW_REP
DEFAULT tablespace users
TEMPORARY tablespace temp
quota unlimited ON users;
GRANT CONNECT, resource, CREATE VIEW TO POW_REP;
CREATE USER POW_DOM IDENTIFIED BY POW_DOM
DEFAULT tablespace users
TEMPORARY tablespace temp
quota unlimited ON users;
GRANT CONNECT, resource, CREATE VIEW, SELECT ANY dictionary TO POW_DOM;
The grant “select dictionary privilege” to the user POW_DOM is only needed to verify the parameter Open_Cursor during the prerequisite check.
Repository Tablespace
Set the storage size for the tablespace to a small number to prevent the repository from using an excessive amount of space.
Also verify that the default tablespace for the user that owns the repository tables is set to a small size. The following example shows how to set the recommended storage parameter for a tablespace named POWERCENTER_DAC.
ALTER TABLESPACE "POWERCENTER_DAC" DEFAULT STORAGE ( INITIAL 10K NEXT 10K MAXEXTENTS UNLIMITED
PCTINCREASE 50 );
Operating System
Login as root
Processor
Verify that the process match the software (x86_64)
[root@di-obia-01 ~]# uname -p
x86_64
[root@di-obia-01 ~]# uname -orv
2.6.18-194.el5 #1 SMP Mon Mar 29 22:10:29 EDT 2010 GNU/Linux
Temporary Disk Space Requirements
The installer writes temporary files to the hard disk. When the installation completes, the installer deletes the temporary files and releases the disk space.
| Installer UNIX | 1 GB |
| Informatica Services UNIX | 2 GB |
Verification of the temporary space with the df commando: Linux - disk free command (df)
[root@di-obia-01 ~]# df -h /tmp
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
77G 16G 58G 22% /
User Account
On UNIX, create a user account specifically to run the Informatica daemon.
[root@di-obia-01 ~]# /usr/sbin/useradd powercenter
[root@di-obia-01 ~]# id powercenter
uid=502(powercenter) gid=506(powercenter) groups=506(powercenter)
[root@di-obia-01 ~]# passwd powercenter
Changing password for user powercenter.
New UNIX password:
BAD PASSWORD: it is WAY too short
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
Port
Verify that the port numbers are available on the machines where you install Informatica Services.
[root@di-obia-01 ~]# netstat -tulpn|grep 6005
The installer validates the port numbers that you specify to ensure that there will be no port conflicts in the domain.
Environment Variables
Use LANG and LC_ALL to set the UNIX code page for the installer.
File Descriptor
Informatica service processes can use a large number of files. Set the Linux - File Descriptor limit per process to 3000 or higher.
In the file /etc/security/limits.conf, add this line:
# PowerCenter
powercenter hard nofile 3001
powercenter soft nofile 2500
And verify with the ulimit function logged as the powercenter system user account:
[powercenter@di-obia-01 ~]$ ulimit -Hn
3001
The limit is set to 3001 to prevent an error with the value 300 during the prerequisites check
Installation directory and Permission
As root, create the installation base directory:
mkdir -p /powercenter/9.0.1
chown -R powercenter:powercenter /powercenter
chown -R powercenter:powercenter /powercenter/9.0.1
chmod -R 775 /powercenter
chmod -R 775 /powercenter/9.0.1
As the installer (powercenter), copy the file to a tmp directory, unzip and untar it:
[powercenter@di-obia-01 powercenter901]$ unzip V26109-01.zip
Archive: V26109-01.zip
inflating: 901HF2_Server_Installer_linux-x64.tar
[powercenter@di-obia-01 powercenter901]$ tar -xf 901HF2_Server_Installer_linux-x64.tar
Change the permission of the file install.sh to execute
chmod -R 744 /tmp/powercenter901/install.sh
Server
Pre-Installation System Check
To verify whether a machine meets the system requirements for an Informatica installation, run the Pre-Installation System Check Tool (i9Pi) before you start the installation process.
You can find the i9Pi tool in the following directory: <InstallerExtractDirectory>/i9Pi
[powercenter@di-obia-01 i9Pi]$ ./i9Pi.bin
Preparing to install...
Extracting the JRE from the installer archive...
Unpacking the JRE...
Extracting the installation resources from the installer archive...
Configuring the installer for this system's environment...
Launching installer...
Enter the port 6004 to prevent a problem during the ckeck on the port 2010. The tool normally must verify until the port 6009 but check also the port 6010 which is the standard port for X Forwarding
A pdf is available in the tool directory if you want more information.
The report files are stored in the directory where you extract the Pre-Installation System Check tool files:
- HTML format: <i9Pi Directory>/i9Pi/i9Pi_summary.html
- Text format: <i9Pi Directory>/i9Pi_summary.log
i9Pi_summary.log
Output - Informatica9 Installation Location:/
Informatica starting port number:6004
Database Type:ORACLE
Database Hostname:di-rep-db
Database Port number:1521
Database Service name:direp.hotitem.local
Database User ID:POW_DOM
PASSED: OS Version Check: RHL Version Identified is 2.6.18-194.el5
PASSED: Diskspace: Available DiskSpace is 55105 MB
PASSED: Processors: Available Processors is 2
PASSED: Physical Memory: Available RAM Size is 4242 MB
PASSED: Temporary Space: Available temporary diskspace: 55105 MB. Sufficient for installation
PASSED: Socket Port: Socket port Range 6004-6009
PASSED: LANG Environment Variable: LANG Set to en_US.UTF-8 and LC_ALL Set to null
PASSED: JRE_HOME Environment Variable: JRE_HOME is not set
PASSED: File Descriptors : File descriptors limit is 3001
PASSED: Oracle Open Cursors: Open cursors in Oracle database is set to 1000Sufficient for install
PASSED : Resource privilege : The user account has the RESOURCE privilege.
PASSED: Create Table check : Successfully created a database table.
PASSED: Create View : Successfully created a database view.
Initial Server Software Installation
This sequence of installation don't say that you have to hit the next button and does not take care of review and informative windows.
[powercenter@di-obia-01 /]$ unset JRE_HOME
[powercenter@di-obia-01 /]$ /tmp/powercenter901/install.sh
OS detected is Linux
unjar task is in progress.............
You can wait a long time on this step ….
unjar of ESD completed.....
Do you want to continue installation (y/n) ?
y
Starting installation ...
\***************************************************************************
\* Welcome to the Informatica 9.0.1 HotFix 2 Server Installer. *
\***************************************************************************
To verify whether a machine meets the system requirements for an Informatica installation, run the
Pre-Installation System Check Tool (i9Pi) before you start the installation process. You can find the i9Pi
tool in the following directory: <InstallerExtractDirectory>/i9Pi
Before you continue, read the 9.0.1 HotFix 2 Installation Guide and Release Notes.
You can find the 9.0.1 HotFix 2 documentation in the Documentation Center at http://my.informatica.com
Configure the LANG and LC_ALL variables to generate appropriate code pages and
create and connect to repositories and Repository Services.
Do you want to continue? (Y/N)Y
Installer requires operating system Linux version 2.6 and later.
Current operating system Linux version 2.6.
Current operating system meets minimum requirements.
Select a choice :
1. Install Informatica 9.0.1 with Hot Fix 2 or Upgrade from a previous version of Informatica to
Informatica 9.0.1 with Hot Fix 2
2. Apply Informatica 9.0.1 Hot Fix 2 to existing 9.0.1 install.
Enter the choice(1 or 2):1
-----------------------------------------------------------
Checking for existing 9.0.1 HotFix 2 product installation.
Select (G)UI mode (needs X Window support) or (C)onsole mode (G/C):G
Launching installer in GUI mode ...
Preparing to install...
Extracting the JRE from the installer archive...
Unpacking the JRE...
Extracting the installation resources from the installer archive...
Configuring the installer for this system's environment...
Launching installer...
Preparing SILENT Mode Installation...
===============================================================================
Informatica 9.0.1 Services HotFix2 (created with InstallAnywhere)
-------------------------------------------------------------------------------
Informatica 9.0.1 HotFix 2 Steps:
- Installation Type: Install (and not upgrade)
- Pre-requisites: Next
- License and Directory. (Transfer the license file from the client zip file)
Pre-Installation Summary: Install (Required Disk Space 2815 MB)
Domain Creation: Create a domain- Configuration Database
with as JDBC parameters:
MaxPooledStatements=20;CatalogOptions=0;BatchPerformanceWorkaround=true
- Domain Configuration
- Post-Installation Summary
Installation Status:: SUCCESS
The Informatica 9.0.1 HotFix 2 installation is complete.
For more information, see the debug log file:
/powercenter/Informatica/9.0.1/Informatica_9.0.1_Services_HotFix2.log
Informatica Administrator Home Page http://di-obia-01.hotitem.local:6007
Product Name : Informatica 9.0.1 HotFix 2
Installation Type : Fresh Installation
Installation Directory : /powercenter/Informatica/9.0.1
- Login to the Administration console with the Administrator user (Administration/Administrator)
Repository Configuration
- Start Informatica services. Start > All Programs > Informatica PowerCenter 8.6.1 > Services > Start Informatica Services.
- Launch the Administration console. Start > All Programs > Informatica PowerCenter 8.6.1 > Services > PowerCenter Administration Console
- Login with the account given in the configuration (admin/admin for this article).
- Select configuration assistant (if you don't see it, you can also configure a repository with the configuration tool on the left side)
- Welcome > Next
- Enter a name for the repository, click on the configure button and fill in the fields.
You must enter a connect identifier and not a connect string. The connect string for Oracle contains the credentials.
1
If the creation of the repository hang, try to give the DBA privileges to the oracle database account POW_REP
- Integration service: fill a name in : INT_OBIA7961 and click next.
- Character Data for Integration service: (Note: Character Encoding give the choice between ASCII and Unicode)
- Finish !
A global administrator (for the domain and the repository) is automatically created during the installation with the credentials Administrator/Administrator. You may change the password for security purpose
Client
Installation Steps:
- Double click on the file install.bat located in this directory : File1\pc861_client_win32_x86\
- Choose Language. Next
- Choose Install Option. Next
- Prerequisites. Next
- Installation directory For the path, you can leave the default value because it doesn't contain space C:\Informatica\PowerCenter8.6.1
- Pre-installation summary. Next
- Post-installation summary. Next
- Installation Complete. Done
Hot Fix 10 installation:
- file2>pc861_HotFix10_Client\install.bat
- Select Language. Ok
- Welcome. Next. Stop PowerCenter. Ok
- Installation Prerequisites. Next
- Installation Type: Apply. Next
- Installation Directory. Next
- Pre-installation summary. Next
- Post-installation summary. Next
- Installation Complete. Done
It will install :
- PowerCenter - Client
- PowerCenter - Designer
- PowerCenter - Repository Manager
- PowerCenter - Workflow Manager
- PowerCenter - Workflow Monitor
- PowerCenter Mapping Architect for Visio (Data Stencil?)
- Custom Metadata Configurator
The metadata manager console is not installed as in the installation of the version 8.1.1.
Support
The creation of the repository hangs
The creation of the repository can take maximum 2 minutes.
If you don't see the creation of tables in the POW_REP schema:
- close the browser,
- connect again to the administation console and go through the configuration button in the left upper side
If it doesn't work
- give the DBA privileges to the oracle database account POW_REP
- and try to create it again
