There are mainly 2 steps
1. Set the Environmental Variables
The Environmental Variables have to be set in the .profile mentioned below
# Oracle and Informatica Settings
ORACLE_SID=orcl_9.1; export ORACLE_SID
ORACLE_BASE=/oracle; export ORACLE_BASE
ORACLE_HOME=/oracle/18.104.22.168; export ORACLE_HOME
INFA_HOME=/Informatica/Informatica_9.1; export INFA_HOME
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/rdbms/jlib; export CLASSPATH export PATH
LANG=C; export LANG
PATH=$PATH:/Informatica/Informatica_9.1/server/bin; export PATH
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/Informatica/Informatica_9.1/server/bin:$ODBCHOME/lib; export LD_LIBRARY_PATH
2. Change the Host Name in the opb_reposit schema in inf_rep
The 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 scripts
where recid=2 and dataversion=6005;
1. Login to the Admin Console and click on Create a Repository Services
2. Enter the Repository Name and choose the node and the license.
Note : The Repository Name should be the same as that of the Production Name
3. 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’
4. Once you click on finish you will be directed to the screen with the message mentioned below
5. 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
6. Enter the Admin console username and password to start the upgrade process
7. The upgrade process has started
8. After the upgrade you will be directed to another message to upgrade the users and group as shown below.
9. 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 ‘Public groups’
10. For Resolution choose the option merge with current user option
11. After clicking on the option Upgrade the users and groups have been upgraded successfully
12. 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.
13. 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
14. Provide the Integration Services name (It would be good to keep the name as that of the Production version)
15. Provide the Repository Content Information and Admin Console information.
16. Once you click finish make sure you set the Code Page correctly.
17. Once this process is completed, enable the Integration Services.
18. The configuration is complete and install the Informatica 9.1 Client to view the workflows and mappings