Tuesday, July 24, 2018

Informatica 10.1.1 HF2 Upgrade from 9.6.1




[infadev@devnode1 INF10]$ ./install.sh

\***************************************************************************
\* Welcome to the Informatica 10.1.1 Hotfix 2 Server Installer.  *
\***************************************************************************



Before you continue, read the following documents:
* Informatica 10.1.1 Hotfix 2 Installation Guide and Release Notes.
* B2B Data Transformation 10.1.1 Hotfix 2 Installation, Configuration Guide and Release Notes.

You can find the 10.1.1 Hotfix 2 documentation in the Product Documentation section at http://mysupport.informatica.com.

Configure the LANG and LC_ALL variables to generate the appropriate code pages and
create and connect to repositories and Repository Services.
Do you want to continue? (Y/N)Y

Select one of the following options to install or upgrade:

  1. Install Informatica.
   Choose this option if the machine does not have Informatica services installed.


  2. Upgrade Informatica.
   .Choose this option if the following condition is true:
   * You want to upgrade the Informatica services on a machine that has Informatica version 10.1.0 or an earlier version installed.


  3. Install or upgrade Data Transformation Engine Only.
   Choose this option to install or upgrade only Data Transformation Engine.


  4. Apply Hotfix 2 to Informatica 10.1.1 or roll back the hotfix.
   .Choose this option to apply the hotfix to Informatica version 10.1.1 or roll back the hotfix.


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

-----------------------------------------------------------
Checking for an Informatica 10.1.1 Hotfix 2 installation.
Select one of the following options:
1. Run Informatica Upgrade Advisor
2. Run the Informatica services upgrade installation
Select the option to proceed : (Default : 1)2
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...


******************************************************************************************************
Welcome - Step 1 of 8
******************************************************************************************************
[ Type 'back' to go to the previous panel or 'help' to check the help contents for this panel or 'quit' to cancel the installation at any time. ]

I agree to the terms and conditions
    * 1->No
      2->Yes
(Default: 1):2

Version 10.1.1 HotFix 2 does not support big data functionality.
If you install or upgrade to version 10.1.1 HotFix 2, the big data functionality will not be available.
Do you want to continue?
    * 1->No
      2->Yes
(Default: 1):2


******************************************************************************************************
Upgrade Prerequisites - Step 2 of 8
******************************************************************************************************
[ Type 'back' to go to the previous panel or 'help' to check the help contents for this panel or 'quit' to cancel the installation at any time. ]

Verify the upgrade prerequisites and complete the pre-upgrade tasks before you continue.

 Database Requirements: -Requires Oracle, IBM DB2, Microsoft SQL Server or Sybase ASE.

 One of the following product versions must be installed on this machine:
 - Informatica 9.5.1
 - Informatica 9.6.1
 - Informatica 10.0.0
 - Informatica 10.1.0
 - Data Transformation Engine 9.5.1
 - Data Transformation Engine 9.6.1
 - Data Transformation Engine 10.0.0
 - Data Transformation Engine 10.1.0

 Disk Space Requirement: 10 GB
 Memory Requirement (RAM): 6 GB

   Pre-upgrade tasks:
 - Back up the domain configuration repository.
 - For a DB2 database, verify that the tablespace has a page size of 32K.
 - While performing upgrade please verify that the domain is shut down.
 - The Reporting and Dashboards Service and Reporting Service are obsolete.
 If the services are present in the domain, the installer deletes the services during the upgrade process.
 For more information about generating the reports, see the Knowledge Base article: https://kb.informatica.com/howto/6/Pages/18/496097.aspx
Press to continue ...

******************************************************************************************************
Upgrade Directory - Step 3 of 8
******************************************************************************************************
[ Type 'back' to go to the previous panel or 'help' to check the help contents for this 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/infadev/Informatica/10.1.0) :/dev/informatica/9.6.1

Enter the directory for Informatica 10.1.1 Hotfix 2: (default :- /dev/informatica/10.1) :/dev/informatica/10.1.1

Allow changes to the node configuration.

Select this option to change the node host name, port numbers, or domain configuration repository database during the upgrade. This option requires additional configuration tasks after the upgrade.
    * 1->No
      2->Yes
(Default: 1):

Stopping the service...
-
Executing the Command...
-----

******************************************************************************************************
Domain Security - Encryption Key - Step 3C of 8
******************************************************************************************************
[ Type 'back' to go to the previous panel or 'help' to check the help contents for this panel or 'quit' to cancel the installation at any time. ]


Encryption key directory: (default :- /dev/informatica/10.1.1/isp/config/keys) :

Domain user name: :Administrator

Domain password: :


******************************************************************************************************
Pre-Installation Summary - Step 4 of 8
******************************************************************************************************
[ Type 'back' to go to the previous panel or 'help' to check the help contents for this panel or 'quit' to cancel the installation at any time. ]


Product Name     :      Informatica 10.1.1 Hotfix 2 services

Installation Type        :      Upgrade

Installation Directory   :      /dev/informatica/10.1.1

Required Disk Space      :      10,733 MB

Available Disk Space     :      19,014 MB

Press to continue ...

Stopping the service...
-
Warning !!! Ensure the Informatica domain is shutdown before you upgrade.

Select a Choice
    * 1->OK
(Default: 1):


******************************************************************************************************
Upgrading - Step 5 of 8
******************************************************************************************************



Upgrading... 5%

Upgrading... 10%

Upgrading... 15%

Upgrading... 20%

Upgrading... 25%

Upgrading... 30%

Upgrading... 35%

Upgrading... 40%

Upgrading... 45%

Upgrading... 50%

Upgrading... 55%

Upgrading... 60%

Upgrading... 65%

Upgrading... 70%

Upgrading... 75%

Upgrading... 80%

Upgrading... 85%

Upgrading... 90%

Upgrading... 95%

Upgrading... 100%

******************************************************************************************************
Domain Configuration Repository - Step 5B of 8
******************************************************************************************************
[ Type 'back' to go to the previous panel or 'help' to check the help contents for this 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: INF_DOMdev
User password: ******************
Database address: devdb:1521
Database service name: infdev
Press to continue ...

Executing the Command...
--
Executing the Command...
---
Upgrading node...
-
Updating node...
-
Registering the plugins...
-
Starting the service...
-
Pinging the domain...
-
Pinging the domain...
-
Pinging the domain...
-
Pinging the domain...
-
Pinging the domain...
-
Pinging the domain...
-
Pinging the Administrator service...
-
Pinging the Administrator service...
-
Pinging the Administrator service...
-
Pinging the Administrator service...
-
Pinging the Administrator service...
-
Pinging the Administrator service...
-
Removing Reporting Service...
-
Removing Dashboards Service...
-

******************************************************************************************************
Post-Installation Summary - Step 8 of 8
******************************************************************************************************
Upgrade Status SUCCESS

The Informatica 10.1.1 Hotfix 2 installation is complete.

The system services are disabled by default after the installation is complete.
You must configure the services and then enable them in the Informatica Administrator tool.

For more information, see the debug log file:
/dev/informatica/10.1.1/Informatica_10.1.1_HotFix_2_Services_Upgrade_2018_07_12_20_12_34.log

For more information about the upgrade, see the debug log file:
/dev/informatica/10.1.1/logs/upgrade.log

Installation Type :Upgrade


Informatica Administrator Home Page::
http://devnode1.com:6101

Product Name:  Informatica 10.1.1 Hotfix 2 services


Press to continue ...

Pre Requisite’s for Informatica 10.1.1 HF2 Upgrade from 9.6.1



Pre Requisite’s for Informatica 10.1.1 HF2 Upgrade from 9.6.1



Pre Requisite’s                
1.          Operating system patches and libraries compatible with Informatica 10(RHEL 7 compatible to Informatica 10)
2.          Hardware requirement check (use lscpu, uname -a ,uname -p) command to check
3.          Review the environment variables.(Oracle Home path, Installation directory path, Java Home)
4.          Extract the installer files and provide full privilege
5.          Run the pre-installation (i10Pi) system check tool (on all users domain ,repo)
6.          Installation of Java Developer Kit when you upgrade Informatica 10 on zLinux.
7.          Verify that the operating system meets the file descriptor requirement (ulimit -a)
8.          Back up the Power Center repository.
9.          Verify the user account permissions for the database(Domain user account, Repository user)
10.       Back up any reference data directory at a non-default location in the PowerCenter directory structure.
11.       Record the ODBC data source names of the ODBC connections in the domain.
12.       Verify user account requirements for the domain configuration repository database
13.       DB Backups Create Ticket to take backups od domain and repos
14.       Infa Backups – Infa admins to take backups of Domain and Repo using script level
15.       Check-DB Refresh Interval on Domain properties.
16.       Storage Backups – Create ticket to Linux / Storage to take backup of Server
17.       Take the backup of 961 folders in unix on all servers
18.       Shut down the domain. To shut down the domain, stop the Informatica service process on each node in the domain
19.       Node Configuration
20.       Naming standards for Node creation
21.       take the backup of node properties
22.       Verify that the locale setting is compatible with the code page for the repository.(ISO WESTERN EUROPEAN)
23.       Check the port number availability using netstat -na|grep "port Num",netstat -tulpn|grep 6005
24.       Set the OPEN_CURSORS parameter to 4000 or higher
25.       Domain Configuration
26.       Domain name should be set
27.       You must shut down the domain before you back up domain and then upgrade the domain
28.       Before you upgrade the domain, you must back up the configuration metadata for the domain.(nodemeta,domains.infa)


Upgradation                     
1.       Informatica10 Software License check
2.       Unix ID creation and connectivity check
3.       Oracle ID Creation and connectivity check
4.       Reviewing the permissions for the Unix users
5.       Review permissions for the oracle users
6.       Oracle client Installation on Centene Development servers
7.       Adding TNS entries and check the DB access from the server level
8.       Copying Informatica software to all the Centene Development servers
9.       Unzip the software and provide privileges on the folder
10.    testing the Informatica jobs on new Sen
11.    provide permissions for the installation folder
12.    Verify the DB User   having all permissions on the DB level
13.    Check the users connectivity Domain user and Repository User
14.    Cross check the naming convention of Domain, repository, IS ,Web services, Node
15.    Informatica 10.x can be upgrade with our current version 9.6.1 HF4
16.    Review the environment variables
17.    Create a New Informatica 10 Installation directory provide full privileges to the folder
18.    login to the same machine with same  Unix user which we have installed previous 9.6 Informatica version
19.    Stop all process that are running on the server
20.    go to installation file click on ./install.sh
21.    Press 1 to Install or Upgrade Informatica
22.    Press 3 to run Informatica installation services
23.    Press y to continue the installation
24.    Press 2 to upgrade Informatica 10.x
25.    enter 1 to use the same node configuration
26.    Installer displays warning to shut down the previous domain click on enter
27.    enter the directory key for encryption of domain
28.    Review the Information of Informatica 10.x upgrade click on enter
29.    check the Installation log and domain log in case of any errors
30.    Review the maximum heap size setting.

Admin Level Testing                         
1.  Create test wfs (Admin Level)
2.  Create sample connections  (Admin Level)
3.  Execute test wfs  (Admin Level)