Informatica PowerCenter upgrade from
8.6.X to 9.1.0 HF2 on AIX 5.3, 6.1 servers
On this tutorial we will see “ Informatica
PowerCenter upgrade ”
from 8.6.1 to 9.1.0 Hot Fix 2 on AIX 5.3, 6.1 servers.
You should have following information before
going for Informatica PowerCenter upgrade as it can help us in troubleshooting any
issue while upgrading.
Database Information
Database user ID:: DBINFWEB
Database user password:: DBINFWEB
Custom string: jdbc:informatica:oracle://infwebora:1521;ServiceName=infweb
Domain Information
Domain name: Domain_webmanual01
Domain host name: webmanual01
Node name: node01_webmanual01
Domain port no: 6001
Domain user name: Administrator
Domain password:: Administrator
Pre requisite
Task 1: Downloaded Informatica PowerCenter 9.1.0 HF2
package . I have unzip and uploaded PowerCenter 9.1.0 HF2
package(910HF2_Server_Installer_aix-ppc64.tar) and license key to the directory
/admin/software/PC91
webmanual01:/admin/software/PC91>
ls -ltotal 0
-rwxrwxrwx 1 infweb staff 910HF2_Server_Installer_aix-ppc64.tar -rw-r–r– 1 infweb staff Infa91Docs.zip drwxr-xr-x 2 infweb staff Messages drwxr-xr-x 4 infweb staff Server -rw-r–r– 1 infweb staff SilentInput.properties -rw-r–r– 1 infweb staff SilentInput_DT.properties -rw-r–r– 1 infweb staff SilentInput_hotFix.properties -rw-r–r– 1 infweb staff SilentInput_upgrade.properties -rw-r–r– 1 infweb staff SilentInput_upgrade_NewConfig.properties drwxr-xr-x 5 infweb staff i9Pi -rwxr-xr-x 1 infweb staff install.sh drwxr-xr-x 2 infweb staff properties drwxr-xr-x 4 infweb staff sapsolutions drwxr-xr-x 4 infweb staff saptrans -rwxr-xr-x 1 infweb staff silentinstall.sh -rwxr-xr-x 1 infweb staff silentinstallDT.sh -rwxr-xr-x 1 infweb staff silentinstallHotFix.sh drwxr-xr-x 3 infweb staff source -rwxr-xr-x 1 infweb staff unjar_esd.sh drwxr-xr-x 3 infweb staff upgrade_utils |
Task 2: Get the License Key for your organization from
Informatica Support.
Step by Step Procedure
of Actual Informatica PowerCenter upgrade as below
Step 1: Login as infweb or switch user to infweb .
This user we have created while doing Informatica PowerCenter 8.6.0
installation. This user owns all Informatica files and process
Step 2: Create a filesystem for Informatica 9.1.0
installation with name /informatica91 and change the ownership to “infweb”. We
can do upgrade on the existing filesystem / informatica861 , but I preferred to
do in on other filesystem.
crfs -v jfs2 -A yes `mklv -t jfs2
-y informat datavg 2G` -a log=INLINE -m /informatica91mount /informatica911
|
chown –R infweb:system /informatica9
Step 3 : Switch user to infweb and change directory
where Infromactica8.6.1 install able files are exist.
su infweb
|
cd /admin/software/PC91
Step 4: If we have environment variables PM_HOME,
INFA_HOME,INFA_NODE_NAME and INFA_DOMAINS_FILE set then we need to unset them
using unset command
unset PM_HOME
unset INFA_HOME unset INFA_NODE_NAME unset INFA_DOMAINS_FILE |
Step 5: Stop the currently running Informatica
services
cd /informatica861/server/tomcat/bin
./infaservice.sh shutdown
ps -ef |grep -i java
Step 7: Run the installer “./install.sh” and you will be getting welcome notice and it
will prompt on several places before going to “Chose Installation Type” phase
as below. I have Bold Out my response as on below output and I have selected
Console mode for installation
./install.shOS detected is
AIXunjar task is in progress………….
unjar of ESD completed….. Do you want to continue installation (y/n) ?y Starting installation … \*************************************************************************** \* 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 AIX version 5.3 and later. Current operating system AIX version 6.1. 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:/i9Pi2.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 [Press Enter ] ———————————————————–Checking for existing 9.1.0 HotFix 2 product installation. Select (G)UI mode (needs X Window support) or (C)onsole mode (G/C):C 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… |
Step 8: We have selected 2 for upgrade
PowerCenter 9.1.0 as below
=======================================================================
========Informatica 9.1.0 HotFix2 Services (created with InstallAnywhere)——————————————————————————-***************************************************************Installation Type**************************************************************[ Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time. ]Copyright (c) 1998-2011 Informatica Corporation. All rights reserved. This Software is protected by U.S. Patent Numbers 5,794,246; 6,014,670; 6,016,501; 6,029,178; 6,032,158; 6,035,307; 6,044,374; 6,092,086; 6,208,990; 6,339,775; 6,640,226; 6,789,096; 6,820,077; 6,823,373; 6,850,947; 6,895,471; 7,117,215; 7,162,643; 7,254,590; 7,281,001; 7,421,458; 7,496,588; 7,523,121; 7,584,422; 7,720,842; 7,721,270; and 7,774,791, international Patents and other Patents Pending.Select to install or upgrade: * 1->Install Informatica 9.1.0 with HotFix 2. Select this option to perform a full installation of Informatica 9.1.0 HotFix 2.2->Upgrade to Informatica 9.1.0 with HotFix 2. Select this option to upgrade previous versions of Informatica products to Informatica 9.1.0 HotFix 2.:2 [Press Enter ] |
Step 9: It will show Installation Pre-Requisite as
below
***************************************************************Installation
Pre-Requisites**************************************************************[
Type 'back' to go to the previous panel or 'quit' to cancel the installation
at any time. ]Verify the upgrade pre-requisites and complete the pre-upgrade
tasks before you continue.Database: -Requires Oracle, IBM DB2, Microsoft SQL
Server or Sybase ASE.One of the following product versions must be installed
on this machine:-PowerCenter 8.1.x
-PowerCenter 8.5.x -PowerCenter 8.6.x -Informatica 9.0.1Disk Space Requirement: 4 GB Memory Requirement (RAM): 4 GBPre-upgrade tasks: - Back up the domain configuration repository. -For a DB2 database, verify that the tablespace has a page size of 32K. - Verify that the domain is shut down.Press to continue … [Press Enter and Accept Default] |
Step 10: Select the directory for Informatica
PowerCenter 9.1.0 HF2 installation as bold below.
***************************************************************Upgrade
Directory**************************************************************[ Type
'back' to go to the previous panel or 'quit' to cancel the installation at
any time. ]Enter the installation directoryEnter the directory of the
Informatica product to upgrade: (default :- /home/infweb/Informatica/9.0.1) :/informatica861
Enter the directory for Informatica 9.1.0 HotFix 2:
(default :- /home/infweb/Informatica/9.1.0) :/informatica91
Allow changes to the node host name and port numbers.
Select this option to change the node configuration of Informatica 9.1.0 HotFix 2. This option requires additional configuration tasks after the upgrade.
* 1->No
2->Yes
:
Warning !!! Shut down the Informatica domain before you
upgrade.Select a Choice
* 1->OK [Press Enter
and Accept Default]
|
Step 11: Installer will give a Pre-Installation Summary
check and if everything looks good press enter to proceed to actual “Informatica
PowerCenter upgrade”
***************************************************************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 2 ServicesInstallation
Type : UpgradeInstallation Directory : /informatica91Disk Space Requirements
Required Disk Space : 6,473 MB Available Disk Space : 116,131 MBPress to continue … [Press Enter and Accept Default] |
Step 12: Actual Installation
***************************************************************Installing***********
***************************************************[==================|==================|==================|==================][==================|==================|==================|==================] [==================|==================|==================|==================] [==================|==================|==================|==================] |
Step 13: Configure the domain database and use the data
collected on pre-requisite point Task 4 from Database team to setup database
connectivity and accept all other options as default.
Configuring Installation…
—————————[==================|==================|==================|============= =====] [------------------|------------------|------------------|------------------]*************************************************************** Domain Configuration Repository ************************************************************** [ Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time. ]The upgrade wizard will use the following settings for the domain configuration repository upgrade: Database type: Oracle Database user ID: DBINFWEB User password: ******** Database address: infwebora:1521 Database service name: infweb Press to continue …Configure JDBC parameters * 1->Yes 2->No : [Press Enter to accept default]JDBC parameters (default :- MaxPooledStatements=20;CatalogOptions=0;BatchPerformanceWorkaround=true) : [Press Enter to accept default]
***************************************************************
Port Configuration Upgrade ************************************************************** [ Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time. ]Enter the port numbers for the Service Manager and Administrator: Service Manager port: (default :- 8001) : [Press Enter to accept default] Service Manager shutdown port: (default :- 6002) : [Press Enter to accept default] Informatica Administrator port: (default :- 8002) : [Press Enter to accept default] Informatica Administrator shutdown port: (default :- 8003) : [Press Enter to accept default]
Executing Command…
— Upgrade in progress 1% —————— 100% Upgrade in progress 1% – 100% Starting service… – Pinging domain… ———- Pinging domain… — Pinging domain… — Pinging Administrator… — Pinging Administrator… — Pinging Administrator…
<<< THIS WILL GO ON FOR A LONG TIME
>>>
— Pinging Administrator… — Pinging Administrator… — Pinging Administrator…. |
Step 14: After successful installation of Informatica
PowerCenter 9.1.0 HF2, we will get
installation success status and a URL to access the Admin Console
***************************************************************Post-Installation
Summary**************************************************************Installation
Status SUCCESSThe Informatica 9.1.0 HotFix 2 installation is complete.For
more information, see the debug log
file:/informatica91/Informatica_9.1.0_Services_HotFix2_Upgrade.logFor more
information about the upgrade, see the debug log
file:/informatica91/tomcat/logs/upgrade.logInstallation Type :Upgrade
Informatica Administrator Home Page:: http://webmanual01:8002/adminconsole Product Name: Informatica 9.1.0 HotFix 2 Services Press to continue … Installation Complete. |
Step 15 : Make appropriate changes to ./profile and
restart the Informatica services:
cd /informatica91/server/tomcat/bin
$ ./infaservice.sh startup
Starting Informatica services on node 'node01_dwtstinfwhq01'
Using CURRENT_DIR: /informatica91/server/tomcat/bin
Using INFA_HOME: /ainformatica91
Step 16: Now we have administrator console
(http://webmanual01:8002/adminconsole ) which will have all service available
as Infortmatica PowerCenter 9.1.0 HotFix 2
Informatica PowerCenter 8.6
installation on AIX 5.3, 6.1 servers
BY
ABINASH SHARMA
In
this Informatica PowerCenter tutorial series, I will explain first how to
install Informatica 8.6 on AIX , second I will explain how to upgrade
Informatica PowerCenter 8.6 to 8.6.1 and finally we will see
Informatica 9.1 with Hot Fix 2 upgrade from Informatica 8.6.1.
On
this first article ,we will see how to install Informatic PowerCenter 8.6
, but creating repository , workflow , Integration service and
PowerCenter client etc are out of scope of this tutorial.
Pre requisite
1)
Downloaded Informatica PowerCenter 8.6 package . I have unzip and
uploaded PowerCenter 8.6 package(pc86_aix32) and license key
to the directory /admin/software
-rw-r----- 1 infoweb system webmanual_0034567-Development-AIX.key
drwxr-x--- 6 infoweb system pc86_aix32
2)
Get the License Key for your organization from Informatica Support
Example
: Informatica support provided webmanual_0034567-Development-AIX.key license
for our organization
3)
Collect the Database user ID , Database user
password ,Custom string information
from Database team . In this example I have the following information from
Database team
Database user ID:: DBINFWEB
Database user password:: DBINFWEB Custom string: jdbc:informatica:oracle://infwebora:1521;ServiceName=infweb |
Step by Step Procedure
Task 1: Create
a user id to be used for Informatica installation and assign a password .This
user will own all Informatica files and process . I have created one with
user if “infoweb”
mkuser pgrp=system groups= system gecos="Informatica 8.6 User" infweb
passwd infweb
Task 2: Create
a filesystem for Informatica 8.6 installation with name /informatica86 and
change the ownership to “infweb”
crfs -v jfs2 -A yes `mklv -t jfs2 -y informat datavg 2G` -a log=INLINE -m /informatica86
mount /informatica86
chown –R infweb:system /informatica86
Task3 : switch
user to infweb and change directory to /admin/software/pc86_aix32 where
Infromactica8.6 installable files are there .
su infweb
cd /admin/software/pc86_aix32
drwxr-xr-x 3 infweb system 256 Jun 19 2008 Server
drwxr-xr-x 3 infweb system 256 Feb 25 2008 Update
-rwxr-xr-x 1 infweb system 4347 May 13 2008 english.msg
-rwxr-xr-x 1 infweb system 9613 Jun 19 2008 install.sh
-rwxr-xr-x 1 infweb system 4168 May 13 2008 jpeuc.msg
-rwxr-xr-x 1 infweb system 4169 May 13 2008 jpsjis.msg
drwxr-xr-x 4 infweb system 256 May 29 2008 sapsolutions
drwxr-xr-x 4 infweb system 256 May 29 2008 saptrans
Task 3: If we
have environment variables PM_HOME, INFA_HOME,INFA_NODE_NAME and
INFA_DOMAINS_FILE set then we need to unset them using unset command
$ unset PM __HOME
$ unset INFA __HOME
$ unset INFA __NODE __NAME
$ unset INFA __DOMAINS __FILE
Task 4: Run the
installer and you will be getting welcome notice and it will prompt on several
places before going to “Chose Installation Type” phase as below. I
have bold out my response as on below output and I have selected Console mode
for installation
./install.sh\**********************************************************************
*****
\* Welcome to the Informatica PowerCenter 8.6.0 Installer. *
\***************************************************************************
\Before you continue, read the PowerCenter Installation Guide and
Release Notes.
You can find the PowerCenter documentation in the Documentation Center at http://my.informatica.com Do you want to continue? (Y/N)Y
Installer requires operating system AIX version 5.2 and later.
Current operating system AIX version 6.1. Current operating system does not meet minimum requirements.
Do you want to continue? (Y/N)Y
———————————————————–
Checking for existing PowerCenter product installation.
Select (G)UI mode (needs X Window support) or (C)onsole mode (G/C):C
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 CONSOLE Mode Installation…
======================================================================= ======== Choose Locale…
—————-
->1- English
CHOOSE LOCALE BY NUMBER: 1
=======================================================================
========
PowerCenter 8.6.0 (created
with InstallAnywhere by Macrovision)
——————————————————————————-
=======================================================================
========
Welcome
——-
Welcome to Informatica PowerCenter 8.6.0.
Use this wizard to install Informatica PowerCenter 8.6.0. Copyright 1999-2008 Informatica Corporation. All rights reserved. This Software is protected by U.S. Patent Numbers 6,208,990; 6,044,374; 6,014,670; 6,032,158; 5,794,246; 6,339,775; 6,850,947; 6,895,471; 7,254,590 and other U.S. Patents Pending.
PRESS <ENTER> TO CONTINUE: [[[[Press Enter]]]]
=======================================================================
========
Configure Environment Variables
——————————-
Required UNIX Environment Variables
You must set the following environment variables to continue with the
installation on UNIX machines: DISPLAY variable: Configure the DISPLAY variable to run the GUI-based installation program using X Windows on Solaris, AIX, HP-UX, and Linux.
Locale variables: Configure the LANG, LANG_C, LC_TYPE, and LC_ALL
variables to
generate appropriate code pages and create and connect to repositories and Repository Services.
If any of the required variables are not configured, quit the
installation
program, configure the variables, and restart the installation program.
If you are not sure that the environment is correctly configured, quit
the
installation and verify environment settings.
For more information about configuring environment variables and testing
PRESS <ENTER> TO CONTINUE: [[[[Press Enter]]]]
database connections, see the PowerCenter Installation Guide.
IMPORTANT INFORMATION COMPLETE. PRESS <ENTER> TO CONTINUE:
[[[[Press Enter]]]]
|
Task 5: We have
selected Install PowerCenter 8.6.0 by typing 1 as below
Choose Installation Type————————Please choose the Install
Set to be installed by this installer.->1- Install PowerCenter 8.6.0
2- Upgrade to PowerCenter 8.6.0ENTER THE NUMBER FOR THE INSTALL SET, OR PRESS <ENTER> TO ACCEPT THE DEFAULT
: 1
|
Task 6 : Select
license key /admin/software/webmanual_0034567-Development-AIX.key
PowerCenter License Key———————–<Type ‘back’ for the
previous panel or ‘quit’ to exit the installer.>
License key fileSelect the license key file: (DEFAULT: /home/infweb/license.key): /admin/software/ webmanual_0034567-Development-AIX.key=================================================================== ============ |
Task 7:Now it will check for prerequisite once it
complete press enter.
Installation Prerequisites————————–
Verify the installation prerequisites and complete the pre-installation tasks before continuing with the installation.PrerequisitesDomain Configuration Database - Oracle, Microsoft SQL Server, Sybase ASE, or IBM DB2 - At least one database user account is required to complete the installation.Disk Space Requirements - 2 GB Pre-installation TasksCreate a system user account and configure the web browser for the PowerCenter Administration Console, Metadata Manager, and Data Analyzer applications. Determine the port numbers to use for nodes in the domain. Optionally, configure environment variables and set up a keystore file for HTTPS support.
For more information, see the PowerCenter Installation Guide.
PRESS <ENTER> TO CONTINUE: [[[[Press Enter]]]]
|
Task 8: Select
the directory to install the Informatica 8.6 as bold below.
========================================================================
=======Installation Directory———————- <Type ‘back’ for previous screen and ‘quit’ to exit installer>Choose the installation directory:Default Install Folder: /home/infweb/Informatica/PowerCenter8.6.0ENTER AN ABSOLUTE PATH, OR PRESS <ENTER> TO ACCEPT THE DEFAULT
: /informatica86
INSTALL FOLDER IS: /aw/informatica86
IS THIS CORRECT? (Y/N): Y
|
Task 9: Configure
https for Informatica PowerCenter 8.6 Admin console access. Here I have choose
1 (1- Do not enable https) as server is inside the firewall and it is not
internet facing
PowerCenter
HTTPS Configuration——————————-1- Do not enable https
->2- Use a keystore generated by the installer 3- Use existing keystore fileENTER THE NUMBER FOR YOUR CHOICE, OR PRESS <ENTER> TO ACCEPT THE DEFAULT: : 1 |
Task 10: Installer
will give a Pre-Installation Summary check and if everything look good press
enter to proceed to actual installation
========================================================================
======= Pre-Installation Summary———————— Review the following information before continuing. Enter ‘Back’ to go back and change settings. Product Name: PowerCenter 8.6.0Install Folder: /aw/informatica86Disk Space Requirements Required Space : 2,209 MBAvailable Space : 99,756 MBPRESS <ENTER> TO CONTINUE: [[[[Press Enter]]]] |
Task 11: Actual
Installation
===============================================================================
Installing...
-------------
[==================|==================|==================|==================]
[------------------|------------------|------------------|------------------]
Task 12: As we
are installing fresh Informatica 8.6 so we have selected 1 and hit enter as
below
========================================================================
= ======Create or Join Domain ——————— <Type ‘back’ for the previous panel or ‘quit’ to exit the installer.>For more information about creating or joining a domain, see the PowerCenter Installation Guide.Note: PowerCenter is licensed on a CPU basis. Consult your licensing agreement for details about your licensed configuration. ->1- Create New Domain (If you are installing PowerCenter for the first time or you want to create a new domain.) 2- Join Existing Domain (If you are installing PowerCenter on multiple machines and you already created a domain on another machine.)Enter an option:: <Default:1>: [[[[Press Enter]]]] |
Task
13: Configure the domain database and use the data collected on pre-requisite
point 3 from Database team to setup database connectivity and accept all other
options as default. Here I am using Oracle Database so I have selected Oracle
Configure Domain Database
————————-<Type ‘back’ for the previous panel or ‘quit’ to exit the installer.> Enter the account information for the database to store PowerCenter domain configuration metadata. Each PowerCenter domain must store configuration metadata in a separate database account.->1- Oracle 2- DB2 3- SQLServer 4- SybaseDatabase type:: <Default:1>: [[[[Press Enter]]]]->1- Default 2- Custom string
Database URL type:: <Default:1>:
2
Database user ID:: DBINFWEB
Database user password:: DBINFWEB Custom string: (DEFAULT: jdbc:informatica:databasetype://hostname:portno….):jdbc:informatica:oracle://infwebora:1521; ServiceName=infweb
========================================================================
= ====== Configure Domain —————- <Type ‘back’ for the previous panel or ‘quit’ to exit the installer.>
Enter the information for the PowerCenter domain to create.
Domain name: (DEFAULT: Domain_webmanual01): [[[[Press Enter]]]]
Domain host name: (DEFAULT: webmanual01): [[[[Press Enter]]]] Node name: (DEFAULT: node01_webmanual01): [[[[Press Enter]]]] Domain port no: (DEFAULT: 6001): [[[[Press Enter]]]] Domain user name: (DEFAULT: admin): Administrator Domain password:: Administrator Confirm password:: Administrator
Configure minimum and maximum port numbers? (Y/N) (DEFAULT: N)
: = |
Task 14: After
successful installation we will get installation success status and URL to
access the admin console
Post-Installation Summary
————————- Installation Status: SUCCESSThe PowerCenter 8.6.0 installation completed successfully. The information below summarizes the location of the installed products . For more information, see the debug log file at /informatica86/Informatica_Installation_Server_Debug.logProduct Name : ———————— PowerCenter 8.6.0Components : ———————— PowerCenter Services PowerCenter Data Analyzer PowerCenter Metadata ManagerInstallation Directory : ———————— /informatica86PowerCenter Services Configuration PRESS <ENTER> TO CONTINUE: ——————————————– Administration Console URL : http://webmanual01:6001/adminconsoleDomain Name : Domain_webmanual01 Gateway Host Name : webmanual01 Administrator User Name : Administrator Node Name : node01_webmanual01 Node Port Number : 6001
If you purchased PowerCenter Real Time Edition, you must configure the
Informatica Orchestration and Human Workflow server after you install. To
configure the Informatica Orchestration and Human Workflow server, run the
script at /informatica86/OrchestrationServer/extras.
IMPORTANT INFORMATION COMPLETE. PRESS <ENTER> TO CONTINUE:
$ exit
|
Task 15 : Now we
have a Informatica PowerCenter Administrator console URL using which we can to
create Integration Service , Reference Table Manager , Repository service etc.
You can login using the ID and Password provided in Task 12. In our id and
password both are same Administrator.
Informatica PowerCenter upgrade from
8.6.0 to 8.6.1 on AIX 5.3, 6.1 servers
BY
ABINASH SHARMA
On
our last tutorial of Informatica PowerCenter upgrade we have seen “Informatica
PowerCenter 8.6 installation on AIX 5.3, 6.1 servers” . On this tutorial we
will how to upgrade Informatica PowerCenter upgrade from 8.6.0 to 8.6.1 on AIX
5.3, 6.1 servers. It is pretty straight forward. While upgrading Informatica
PowerCenter from 8.6.0 to 8.6.1 upgrade process will import Database and Domain
information from previous installation of Informatica PowerCenter 8.6.0 by
itself
Database
user ID:: DBINFWEB
Database user password:: DBINFWEB
Custom string: jdbc:informatica:oracle://infwebora:1992;ServiceName=infweb
Database user password:: DBINFWEB
Custom string: jdbc:informatica:oracle://infwebora:1992;ServiceName=infweb
Domain
——
Domain name: Domain_webmanual01
Domain host name: webmanual01
Node name: node01_webmanual01
Domain port no: 6001
Domain user name: Administrator
Domain password:: Administrator
Confirm password:: Administrator
——
Domain name: Domain_webmanual01
Domain host name: webmanual01
Node name: node01_webmanual01
Domain port no: 6001
Domain user name: Administrator
Domain password:: Administrator
Confirm password:: Administrator
Pre requisite
Task 1: Downloaded Informatica PowerCenter 8.6.1 package . I have unzip and uploaded PowerCenter 8.6.1 package(pc861_aix64) and license key to the directory /admin/software/ PC861
Task 1: Downloaded Informatica PowerCenter 8.6.1 package . I have unzip and uploaded PowerCenter 8.6.1 package(pc861_aix64) and license key to the directory /admin/software/ PC861
drwxr-xr-x
3 infweb system Server
drwxr-xr-x 3 infweb system Update
-rwxr-xr-x 1 infweb system english.msg
-rwxr-xr-x 1 infweb system infa_install_version.properties
-rwxr-xr-x 1 infweb system install.sh
-rwxr-xr-x 1 infweb system jpeuc.msg
-rwxr-xr-x 1 infweb system jpsjis.msg
-rwxr-xr-x 1 infweb system ko_euckr.msg
-rwxr-xr-x 1 infweb system pc861_aix64.tar
drwxr-xr-x 4 infweb system sapsolutions
drwxr-xr-x 4 infweb system saptrans
-rwxr-xr-x 1 infweb system zh_gbk.msg
drwxr-xr-x 3 infweb system Update
-rwxr-xr-x 1 infweb system english.msg
-rwxr-xr-x 1 infweb system infa_install_version.properties
-rwxr-xr-x 1 infweb system install.sh
-rwxr-xr-x 1 infweb system jpeuc.msg
-rwxr-xr-x 1 infweb system jpsjis.msg
-rwxr-xr-x 1 infweb system ko_euckr.msg
-rwxr-xr-x 1 infweb system pc861_aix64.tar
drwxr-xr-x 4 infweb system sapsolutions
drwxr-xr-x 4 infweb system saptrans
-rwxr-xr-x 1 infweb system zh_gbk.msg
Task
2: Get the License Key for your organization from Informatica Support.
Task
3: Stop the Informatica PowerCenter 8.6.0
$cd /informatica86/server/tomcat/bin
$ ./infaservice.sh shutdown
Stopping Informatica services on node 'node01_webmanual01'
Step by Step Procedure
Task 0 : Login
as infweb or switch user to infweb . This user we have created while doing
Informatica PowerCenter 8.6.0 installation. This user owns all Informatica
files and process
Task 1: Create a filesystem for Informatica 8.6 installation with name /informatica861 and change the ownership to “infweb”. We can do upgrade on the existing filesystem / informatica86 , but I preferred to do in on other filesystem.
Task 1: Create a filesystem for Informatica 8.6 installation with name /informatica861 and change the ownership to “infweb”. We can do upgrade on the existing filesystem / informatica86 , but I preferred to do in on other filesystem.
crfs -v jfs2 -A yes `mklv -t jfs2 -y informat datavg 2G`
-a log=INLINE -m /informatica861
mount /informatica861 chown –R infweb:system /informatica861 |
Task 2 : Switch
user to infweb and change directory where Infromactica8.6.1 installable page is
exist.
su infweb
cd /admin/software/PC861 |
Task 3: If we
have environment variables PM_HOME, INFA_HOME,INFA_NODE_NAME and
INFA_DOMAINS_FILE set then we need to unset them using unset command
$ unset PM __HOME
$ unset INFA __HOME $ unset INFA __NODE __NAME $ unset INFA __DOMAINS __FILE |
Task 4: Run the
installer and you will be getting welcome notice and it will prompt on several
places before going to “Chose Installation Type” phase as below. I have Bolded
Out my response as on below output and I have selected Console mode for
installation
$ ./install.sh
\***************************************************************************
\* Welcome to the Informatica PowerCenter 8.6.1 Installer. * \***************************************************************************
\Before you continue, read the PowerCenter Installation Guide and
Release Notes.
You can find the PowerCenter documentation in the Documentation Center at http://my.informatica.com Do you want to continue? (Y/N)Y Installer requires operating system AIX version 5.2 and later. Current operating system AIX version 6.1. Current operating system meets minimum requirements. ———————————————————– Checking for existing PowerCenter product installation. Select (G)UI mode (needs X Window support) or (C)onsole mode (G/C):C 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 CONSOLE Mode Installation…
========================================================================
= ====== Choose Locale… —————-
->1- English
CHOOSE LOCALE BY NUMBER: 1 [[Press
Enter]]
======================================================================== ======= PowerCenter 8.6.1 (created with InstallAnywhere by Macrovision) ——————————————————————————-
========================================================================
======= Welcome ——-
Welcome to Informatica PowerCenter 8.6.1.
Use this wizard to install Informatica PowerCenter 8.6.1.
Copyright 1998-2008 Informatica Corporation. All rights reserved.
This Software is protected by U.S. Patent Numbers 6,208,990; 6,044,374;
6,014,670; 6,032,158; 5,794,246; 6,339,775; 6,850,947; 6,895,471; 7,254,590 and other U.S. Patents Pending.
PRESS TO CONTINUE: [[Press
Enter]]
========================================================================
======= Configure Environment Variables ——————————-
Required UNIX Environment Variables
You must set the following environment variables to continue with the
installation on UNIX machines:
DISPLAY variable: Configure the DISPLAY variable to run the GUI-based
installation program using X Windows on Solaris, AIX, HP-UX, and Linux.
Locale variables: Configure the LANG, LANG_C, LC_TYPE, and LC_ALL
variables to
generate appropriate code pages and create and connect to repositories and Repository Services.
If any of the required variables are not configured, quit the
installation
program, configure the variables, and restart the installation program.
If you are not sure that the environment is correctly configured, quit
the
installation and verify environment settings.
For more information about configuring environment variables and testing
database connections, see the PowerCenter Installation Guide.
PRESS TO CONTINUE: [[Press
Enter]]
|
Task 5: We have
selected upgrade PowerCenter 8.6.1 by typing 2 as below
========================================================================
= ====== Choose Installation Type ————————
Please choose the Install Set to be installed by this installer.
->1- Install PowerCenter 8.6.1
2- Upgrade to PowerCenter 8.6.1
ENTER THE NUMBER FOR THE INSTALL SET, OR PRESS TO ACCEPT THE DEFAULT
: 2 [[Press Enter]] |
Task 6: It will
ask to stop the running Informatica service for 8.6. I have already stopped it
as you can see it pre requisite
========================================================================
======= Informatica PowerCenter 8.6.1 —————————–
Stop PowerCenter before you install
You must stop PowerCenter before you continue with the installation. The
installation fails if PowerCenter is running on this machine. To stop PowerCenter on Windows, stop the Informatica Services service. To stop PowerCenter on UNIX, stop the Informatica Services daemon.
Type ‘quit’ to exit the installation. Press ‘Enter’ to continue
->1- OK
2- Cancel
ENTER THE NUMBER OF THE DESIRED CHOICE, OR PRESS TO ACCEPT THE
DEFAULT: 1 [[Press Enter]] ======================================================================== ======= Upgrade choice ————–
Select simple upgrade if you want to upgrade to 8.6.1 without mixed
domain support. Select mixed domain supoort if you want to updrade with mixed
domain feature
->1- Select this option to do a simple upgrade
2- Select this option to upgrade with mixed domain support
ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS TO ACCEPT THE DEFAULT:
: 1 [[Press Enter]] |
Task 7: It will
check for prerequisite once it complete press enter.
========================================================================
======= Installation Prerequisites ————————–
Verify the installation prerequisites and complete the pre-installation
tasks
before continuing with the upgrade.
Prerequisites
PowerCenter version 8.1.1, 8.1.1 service pack, 8.5 , 8.5.1 or 8.6.0 is
installed on this machine.
Informatica Services must not be running.
You must use the same user account used to install the previous version
of
PowerCenter.
All processes that access the PowerCenter directory and subdirectories,
including command prompts and command line programs, must be stopped.
Disk Space Requirements
The upgrade installer requires 2GB of available disk space, plus the size of the existing server and java directories.
Pre-installation Tasks
Verify the license key and configure the web browser for the PowerCenter
Administration Console, Metadata Manager & Business Glossary, and Data Analyzer applications.You may also need to create or clear environment variables and create a keystore file for HTTPS. The pre-installation tasks are based on the version you upgrade from. For more information, see the PowerCenter Installation Guide.
PRESS TO CONTINUE: [[Press
Enter]]
|
Task 8: Select
the directory where Informatica PowerCenter 8.6 is installed as bold below.
========================================================================
= ====== Installation Directory ———————- Specify the existing installation directory.
Enter the PowerCenter installation directory: (DEFAULT:
/home/infweb/Informatica/PowerCenter8.6.1): /informatic86
========================================================================
======= Upgrade choice ————–
->1- Upgrade to existing directory
2- Upgrade to different location
ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS TO ACCEPT THE DEFAULT:
: 2 [[Press Enter]] |
Task 9: Select
the directory to install the Informatica PowerCenter 8.6.1 as bold below.
========================================================================
======= Upgrade Location —————- Upgrade to a different location. Enter new directory
Default Install Folder: /home/infweb/Informatica/PowerCenter8.6.1
ENTER AN ABSOLUTE PATH, OR PRESS TO ACCEPT THE DEFAULT
: /informatica861 [[Press Enter]]
INSTALL FOLDER IS: /informatica861
IS THIS CORRECT? (Y/N): Y |
Task 9: Installer
will give a Pre-Installation Summary check and if everything look good press
enter to proceed to actual installation
=======================================================================
= ======= Pre-Installation Summary ———————— Review the following information before continuing. Enter ‘Back’ to go back and change settings.
Product Name:
PowerCenter 8.6.1
Install Folder:
/informatica861
Install Set
Upgrade to PowerCenter 8.6.1
Disk Space Requirements
Required Space :
1,543 MB
Available Space :
199,7 MB
Upgrade Mode
Plain Upgrade
PRESS TO CONTINUE: [[Press
Enter]]
|
Task 10: Actual
Installation
========================================================================
======= Installing… ————-
[==================|==================|==================|=================
=] [------------------|------------------|------------------|------------------] |
Task 11: After
successful installation we will get installation success status and URL to
access the admin console
========================================================================
======= Post-installation Summary ————————- Installation Status : SUCCESS
The PowerCenter 8.6.1 upgrade completed successfully. The information
below
summarizes the location of the installed products.
For more information, see the debug log file at
/informatica861/Informatica_Installation_Server_Debug.log
Product Name :
———————— PowerCenter 8.6.1 Components : ———————— PowerCenter Services PowerCenter Data Analyzer PowerCenter Metadata Manager Business Glossary
Installation Directory :
———————— /informatica861 Configuration Properties PRESS TO CONTINUE: [[Press Enter]] —————————- PowerCenter Services ——————————– Administration Console URL : http://webmanual01:6001/adminconsole
If you purchased PowerCenter Real Time Edition, you must configure the
Informatica Orchestration and Human Workflow server after you install. To configure the Informatica Orchestration and Human Workflow server, run the script at /informatica861/OrchestrationServer/extras.
IMPORTANT INFORMATION COMPLETE. PRESS TO CONTINUE: [[Press Enter]]
|
Task 12: Now we
have administrator console (http://webmanual01:6001/adminconsole ) which will
have all service available as Infortmatica PowerCenter 8.6.0