Oracle Bi Solutions

  • Subscribe to our RSS feed.
  • Twitter
  • StumbleUpon
  • Reddit
  • Facebook
  • Digg

Saturday, 16 February 2013

Informatica PC Upgrade from 861 to 91 Installation Steps

Posted on 21:13 by Unknown

TABLE OF CONTENTS

1 OVERVIEW
2 DOWNLOAD 9.1 SOFTWARE
3 BACKUP DOMAIN
4 BACKUP OF REPOSITORIES’
5 SHUT DOWN THE DOMAIN
6 VALIDATE ENVIRONMENT VARIABLES BEFORE UPGRADE TO 9.1
7 BACKUP NODEMETA.XML
8 BACKUP DOMAINS.INFA
9 START INSTALLATION / UP GRADATION
10 ENVIRONMENT VARIABLES SETUP
11 POST INSTALLATION STEPS

1 Overview

This document is for informatica administration team, providing the detailed upgradation
steps from 8.6.1 to 9.1 on Linux & Oracle Environment.

2 Download 9.1 Software

Download Software from informatica Corporation and make sure to get proper keys based
on environment (Dev/ Prod).

3 Backup Domain

Before Startup of up gradation, please take backup of 8.6.1 domain

4 Backup of Repositories’

Take backup of all repositories in 8.6.1 server

5 Shut Down the Domain


Shutdown services from tom bin folder
./infaservice shutdown

6 Validate Environment variables before upgrade to 9.1

-bash-3.2$ $ echo $IATEMPDIR
/infa/informatica/pc91/temp
-bash-3.2$ $ echo $PATH
/usr/local/bin:/bin:/usr/bin:/home/infa91/bin:/infa/oracle/java/jdk1.5.0_22/bin:
-bash-3.2$ $ echo $JRE_HOME

-bash-3.2$ $ echo $INFA_HOME

-bash-3.2$ $ echo $INFA_DOMAINS_FILE

7 Backup nodemeta.xml

-rwxrwxr-x 1 infa91 infadmin 1626 Jun 1 13:23 nodemeta.xml
-bash-3.2$ $ pwd
/infa/informatica/pc86/server/config

-bash-3.2$ $ cp nodemeta.xml nodemeta.xml.20120608

8 Backup domains.infa

/infa/informatica/pc86
-bash-3.2$ $ ls -ltr domains.infa
-rwxrwxr-x 1 infa91 infadmin 1059 Jun 1 13:23 domains.infa
-bash-3.2$ $ cp domains.infa domains.infa.20120608
-bash-3.2$ $ ls -ltr domains.infa*
-rwxrwxr-x 1 infa91 infadmin 1059 Jun 1 13:23 domains.infa
-rwxr-xr-x 1 infa91 infadmin 1059 Jun 8 19:45 domains.infa.20120608

9 Start Installation / Up gradation

-bash-3.2$ $ pwd
/infa/informatica/pc91
-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

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.
: 2

***************************************************************
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.1

Disk Space Requirement: 4 GB
Memory Requirement (RAM): 4 GB

Pre-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 <Enter> to continue ...

***************************************************************
Upgrade Directory
**************************************************************
[ Type 'back' to go to the previous panel or 'quit' to cancel the installation at any time. ]


Enter the installation directory

Enter the directory of the Informatica product to upgrade: (default :-
/home/infa91/Informatica/9.0.1) :/infa/informatica/pc86/

Enter the directory for Informatica 9.1.0 HotFix 3: (default :- /infa/informatica/pc91/) :
/infa/informatica/pc91/

Allow changes to the node host name and port numbers.

Select this option to change the node configuration of Informatica 9.1.0 HotFix 3.
This option requires additional configuration tasks after the upgrade.
* 1->No
2->Yes
:1

Warning !!! Shut down the Informatica domain before you upgrade.

Select a Choice
* 1->OK
:1

***************************************************************************
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 : Upgrade
Installation Directory : /infa/informatica/pc91/
Disk Space Requirements
Required Disk Space : 5,185 MB
Available Disk Space : 58,154 MB
Press <Enter> to continue ...
===============================================================================
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: infa_dom
User password: *********
Custom String jdbc:informatica:Oracle://11.22.333.111:1521;SID=PCdb
Press <Enter> to continue ...
Configure JDBC parameters
* 1->Yes
2->No
:2
*****************************************************************************
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) :
Service Manager shutdown port: (default :- 6002) :
Informatica Administrator port: (default :- 8002) :
Informatica Administrator shutdown port: (default :- 8003) :
Restart the domain configuration upgrade
The domain upgrade wizard has detected a previous failed attempt to upgrade the domain.
The failed attempt may have resulted in an inconsistent domain configuration.
If you select to restart the domain configuration upgrade,
the domain upgrade wizard will restart the domain upgrade process and override all previous upgrades to
the domain. It will also override any upgrade contention.Use the following guidelines when you restart the
domain configuration upgrade:

-The problem indicated in the upgrade logs as the cause of the previous upgrade failure must be resolved.
-Other administrators must not be upgrading any other node in the domain at this time.
-If errors persist when you restart the domain configuration upgrade, the domain configuration database
must be restored from backup.
* 1->No
2->Yes
:2

Executing Command...
--
Upgrade in progress
1%
------------
99%
100%

Upgrade in progress
1%

99%--
100%

Starting service...
--
Pinging domain...
------
Pinging domain...
--
Pinging domain...
--
Pinging domain...
--
Pinging Administrator...
--
Pinging Administrator...
--
Pinging Administrator...
--
Pinging Administrator...
--

********************************************************************************
Post-Installation Summary
********************************************************************************
Installation Status SUCCESS


The Informatica 9.1.0 HotFix 3 installation is complete.

For more information, see the debug log file:
/infa/informatica/pc91//Informatica_9.1.0_Services_HotFix3_Upgrade.log

For more information about the upgrade, see the debug log file:
/infa/informatica/pc91//tomcat/logs/upgrade.log

Installation Type :Upgrade

Informatica Administrator Home Page::
http://ServerName:8002

Product Name: Informatica 9.1.0 HotFix 3 Services

Press <Enter> to continue ...
Installation Complete.

10 Environment Variables Setup

Update Environment Variables to 9.1 server paths

-bash-3.2$ $ echo $INFA_DOMAINS_FILE

-bash-3.2$ $ INFA_DOMAINS_FILE=/infa/informatica/pc91/
-bash-3.2$ $ echo $INFA_DOMAINS_FILE
/infa/informatica/pc91/
-bash-3.2$ $ echo $INFA_HOME

-bash-3.2$ $ INFA_HOME=/infa/informatica/pc91/
-bash-3.2$ $ export INFA_HOME
-bash-3.2$ $ echo $INFA_HOME
/infa/informatica/pc91/

11 Post Installation Steps

After up gradation all integration services will be down and repository services will give below message.

The repository version(179) is incompatible with version (181) of the product.
The repository version is 88 but the product uses version 90.
An upgrade may be required.


Select Repository – Go to Actions on top left – Select Repository Contents – Select Upgrade
It will ask for Admin Credentials – Give Administrator Credentials
Change Repository to Normal Mode and recycle button
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Posted in Informatica | No comments
Newer Post Older Post Home

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts

  • OBIEE 11g Hide/Show Sections based on Dashboard Prompt
    allow a user’s interaction to hide/show certain sections of a dashboard. In this particular case the user wanted to choose either ‘Quarterly...
  • [OBIEE11g] - OBIEE Dashboard for Informatica Metadata Reporting
    The metadata that Informatica Power Center 8 retains in its repository can be exposed via OBIEE reports and dashboards. This metadata includ...
  • OBIEE 11g not showing new dashboard in the drop down menu
    When creating New dashboard in  OBIEE 11g, I have faced with issue that dashboard name did not show up in drop down dashboard menu. 1. When ...
  • [ODI] - Frequently Asked Questions (FAQ)
    Here is a list of FAQs about Oracle Data Integrator 1) What is Oracle Data Integrator (ODI)? 2) What is E-LT? 3) What components make up Ora...
  • Upper Function
    In Oracle/PLSQL, the  upper function  converts all letters in the specified string to uppercase. If there are characters in the string that ...
  • Data Modeling: Schema Generation Issue with ERwin Data Modeler 7.3
    We are using Computer Associate’s ERwin Data Modeler 7.3 for data modeling. In one of our engagements, we are pushing data model changes to ...
  • [OBIEE11g] - Creating Dashboard Traversing Through Graph
    The general requirement asked for by customers is that they want to Click on the Main Dashboard Page’s Graph and be transferred to the other...
  • [OBIEE11g] - Dashboard Prompt - "Prompt User"
    Oracle BI 11g which we hadn't seen before, the " Prompt User " operator on a dashboard prompt. I'm not sure exactly when t...
  • [OBIEE11g] - How to rename My Dashboard
    To rename the My Dashboard follow the below steps: 1.Navigate to E:\OBIEE 11G\Oracle_BI1\bifoundation\web\msgdb\l_en\messages. 2.Locate “uim...
  • OBIEE 11g - State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 46118] Out of disk space. (HY000)
    Error Details Error Codes: AAD5E5X3:OPR4ONWY:U9IM8TAC Odbc driver returned an error (SQLFetchScroll). State: HY000. Code: 10058. [NQODBC] [S...

Categories

  • BI Publisher
  • DAC
  • DataWarehouse
  • Hyperion
  • Informatica
  • OBIEE
  • ODI
  • Oracle Applications EBS 12.1.3
  • Oracle Database
  • PL/SQL
  • SQL
  • Unix/Linux

Blog Archive

  • ▼  2013 (500)
    • ►  November (8)
    • ►  October (1)
    • ►  July (4)
    • ►  June (9)
    • ►  May (15)
    • ►  April (24)
    • ►  March (43)
    • ▼  February (73)
      • Remember Username and Password in Obiee11g
      • Change Locale in OBIEE 11g
      • Change Password in BI Publisher 111.1.6.0
      • OBIEE 11g - Change the Date Format/ Evaluate Function
      • OBIEE 11g - Enabling Sorting order for more than 1...
      • OBIEE 11g - Changing the NodeManager and weblogic ...
      • OBIEE 11g - Description ID column
      • Fact and Dimension from single source Table
      • OBIEE 11g - Denormalizing physical tables in BMM l...
      • OBIEE 11g - ADF Integration
      • BUG:12930924 SAG: CANNOT DISPLAY MORE THAN 300 OBJ...
      • OBIEE 11g - Hide Apply and Reset button
      • OBIEE 11g Security - Creating Application Policies
      • OBIEE11g startup error - An instance of the interf...
      • OBIEE 11g - Partial Update using Condition in Answers
      • OBIEE 11g - custom Date format in Answers
      • The boot identity may have been changed since the ...
      • OBIEE 11g - weblogic admin account creation
      • Informatica PC Upgrade from 861 to 91 Installation...
      • Installation Informatica Powercenter 9.1 on Oracle...
      • How to Start oracel Database 11gR 2 manually on Linux
      • OBIEE 11g - Installation on OEL 5.8
      • OBIEE 11.1.1.6.5 and J Developer Integration on Li...
      • Oracle SQL Developer :Enter full path for java.exe
      • OBIEE 11g - Unable to get file lock , will retry i...
      • OBIEE 11g - Changing Presentation Services Port Nu...
      • OBIEE 11g - Changing the background color on hover...
      • OBIEE 11g - Date Format change based on Locale Set...
      • OBIEE 11g - Javascript and CSS locations
      • OBIEE 11g - Removing the Gray Header from Reports
      • OBIEE 11g - Refreshing a report Everytime
      • OBIEE 11g - Adding Bookmark Link in Dashboard
      • OBIEE 11g - Searching a Text in Page
      • OBIEE 11g - Remember Username and Password
      • OBIEE 11g - Removing/ Deleting Report Links in a Page
      • OBIEE11g - Export to Excel issue
      • OBIEE 11g - Right-click interactions in Dashboard ...
      • OBIEE11g - Right Function
      • OBIEE 11g - Set Default currency in Dashboard
      • OBIEE 11g - Hide BI Portal Name
      • OBIEE 11g - Export or Print Dashboard Page
      • OBIEE 11g - Ldap authentication is failing when us...
      • OBIEE 11g - Warning: "Upgrade is recommended to th...
      • OBIEE 11g - [OracleBIServerComponent] [ERROR:1] [...
      • OBIEE 11g - State: HY000. Code: 10058. [NQODBC] [S...
      • OBIEE 11g - List of System/Predefined Session Vari...
      • OBIEE 11g - Writeback Steps
      • [OBIPS] [ERROR:1] [] [saw.security.odbcuserpopulat...
      • [ERROR:1] [] [] [ecid: 18c5ef9f7c3aec02:-1a7b1b1:1...
      • OBIEE 11g - Important Path Directories
      • OBIEE 11g - OBI Server and Presentation Cache Mana...
      • How to login to OBIEE 11g - With User and Password...
      • OBIEE 11g - Direct Query from Database, bypassed C...
      • OBIEE 11g - Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
      • OBIEE 11g - Deploying RPD without BI Presentation ...
      • OBIEE 11g - Dashboard Selective View from Report L...
      • OBIEE11g - RPD Deployment Considerations
      • OBIEE 11g - Starting / Stopping Domain Services in...
      • OBIEE 11g - SQL Conditional COUNT & SUM
      • OBIEE11g - Security Migration
      • OBIEE 11g - Performance Tuning
      • OBIEE 11g - User Guide for BI Mobile
      • OBIEE 11g - Active Directory Authenication
      • OBIEE 11g - Security Troubleshooting
      • DAC - Error "main" java.lang.NoClassDefFoundError...
      • DAC11g Starting issue (-server)
      • OBIEE 11.1.1.6.7 Opatch Apply from 11.1.1.6.0 to 1...
      • OBIEE 11.1.1.6.8 - bugs fixed
      • Informatica Powercenter Workflow Manager Repositor...
      • DAC - Restrict the number of years using Mcal Peri...
      • DAC - Global Currency Code Issue in dac
      • Hyperion Installation 11.1.2.1.0 on Linux 32 Bit
      • OBIEE 11g - Deploying RPD on Linux to Access the L...
    • ►  January (323)
Powered by Blogger.

About Me

Unknown
View my complete profile