Pre -Requisites
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/11.2.0.3;
export ORACLE_HOME
INFA_HOME=/Informatica/Informatica_9.1;
export INFA_HOME
export
ODBCHOME=$INFA_HOME/ODBC6.1
export
ODBCINI=$ODBCHOME/odbc.ini
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
export
TNS_ADMIN=
LANG=C;
export LANG
export
LC_ALL=C
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
update
opb_reposit
set
reposit_name='hostname'
where
recid=2 and dataversion=6005;
commit;
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
Upgrade Issues and Fixes.
Please click the link below.
Upgrade Issues and Fixes