Its been a while since I have written an article. Well I was a bit busy and felt this task a bit accomplishing and wanted to post this article so that it would be helpful for a few others.
Basically the main goal of this project is to upgrade from Informatica 8.1 to 9.1. Here the 9.1 is installed in a new machine and they wanted the upgraded version of the Informatica in the new machine and retiere the old machine. Down below you will find the steps to do this task starting from installing the Informatica 9.1 in a new machine and steps to upgrade from 8.1 to 9.1. Stay tuned and enjoy.
Installation of Informatica 9.1 on RedHat Linux
privileges to the users informatica and inf_rep for the installation purposes
privileges to a user in the Red Hat Linux box
for installation purposes.
to be provided for installation purposes with the owner as the sudo user.
Provided directory for installation was Informatica
the installation software in a folder where the sudo user is the owner and has
The Informatica software’s are copied over to /Informatica/Software directory
Client has to be installed for the Informatica to talk to the Oracle Database.
Variables for the Client have to set up in the .profile.
Please find below the Environmental Variables
set in the .profile of s-cssprd
export CLASSPATH export PATH
LANG=C; export LANG
Informatica Database schema of 8.1 to be copied to the desired environment
where the up gradation is to take place
Here the Informatica 8.1 schema pcenter81 was copied over from orcl_8.1 to inf_rep with service name orcl_9.1
- Create a directory for the installation of
Informatica 9.1 and provide privileges
Created a directory Informatica_9.1
chmod -777 /Informatica/Informatica_9.1
1. Go to the path where the installation is stored
and run the install.sh script by the following command after entering into the
1downloaded folder path
Please Note: Once this
command is run wait for a few minutes for further instructions
2. The next it will ask for do you want to
3. You will be asked to choose among 3 option shown below
and choose one which is to do installation or upgrade Informatica
4. Then you will be
asked whether you want to install Informatica using the GUI Mode or command
mode. If you have the X windows support then choose the option G else C. The
installation was done in console mode so I chose the option
5. The interface for the installation will come up as shown
in the screenshot below
6. Provide the
license key file provided by Informatica in the first option. In the second
browse to the location where you want the Informatica to be installed.
- Enter the installation path - /Informatica/Informatica_9.1
7 This being a fresh installation then we can create a new
domain. Choose the first option
Database Type: Oracle
Database User ID:
User Password: inform
Database Service Name: orcl_9.1
Configuring the database connection – Choose 1 (JDBC URL)
For JDBC Parameter : Click Enter to choose the default
This is an example of the GUI interface and put in the
values at the appropriate fields
11. Enter the information for the domain creation
Domain Name: Domain_jabraham_Prod
Node host name – Default provided with the server name
Node Name: Default provided with the server name
Domain User name: Administrator
Domain Password: Administrator
12. Click Enter and the domain will be created
13. Your installation summary is provided
14. To validate the installation is complete traverse to the
link provided http://localhost:6008
Possible Errors during installation
1. Proper privileges not set for the installation folders
2. Proper privileges not set for the directory where the installation is desired to be stored
3. Proper database privileges to the user for creation of domain and repository schema.
If the prerequisites are met and permissions are provided appropriately then the installation should go without any issues.