There are mainly 2
the Environmental Variables
Environmental Variables have to be set in the .profile mentioned below
Oracle and Informatica Settings
export CLASSPATH export PATH
the Host Name in the opb_reposit schema in inf_rep
host name mentioned in the opb_reposit would be of the production hostname. The
hostname has to be changed to the current box gaxpoa152vu. Run the following
recid=2 and dataversion=6005;
the Admin Console and click on Create a Repository Services
Enter the Repository Name and choose the node
and the license.
: The Repository Name should be the same as that of the Production Name
Enter the Schema information of the new
environment where the 8.1 tables have been copied over. Choose the option
‘Content exists in specified connection string. Do not create a new content’
Once you click on finish you will be
directed to the screen with the message mentioned below
Once you see the message it means that the
Informatica 9.1 has recognized the tables and is ready for the upgrade process.
For the upgrade process to be initiated go to the right corned
Actions -->Repository Content-->Upgrade
Enter the Admin console username and
password to start the upgrade process
The upgrade process has started
After the upgrade you will be directed to
another message to upgrade the users and group as shown below.
Go to Actions --> Repository Content --> Upgrade Users and
Groups. Then apply the Admin console user credentials. Make sure you untick the option Use existing ‘Administrator’ and
For Resolution choose the option merge with
current user option
After clicking on the option Upgrade the users
and groups have been upgraded successfully
After this process we have to create the
Integration services. For this we have to make sure the Repository Properties
Operation Mode is changed from Exclusive to Normal.
Once the Operation mode is changed disable
and enable the service once again. Then in Domain choose the option to create a
New Integration Services
Provide the Integration Services name (It
would be good to keep the name as that of the Production version)
Provide the Repository Content Information
and Admin Console information.
Once you click finish make sure you set the
Code Page correctly.
Once this process is completed, enable the
The configuration is complete and install
the Informatica 9.1 Client to view the workflows and mappings
Upgrade Issues and Fixes.
Please click the link below.
Upgrade Issues and Fixes