Informatica 8.1 Domain and repository migration

there was a need to migrate our application server and DB to new location which necessitated Informatica Domain and repository migration: The steps as follows:

1. Take back of informatica repository

2. Copy the existing Informatica schema with tables to new DB

3. Update the TNS entry for new Repository DB, Domain in tnsnames.ora

4. Login to admin console.

Select the integration service -> go to properties tab -> EDIT database properties and enter the DB connection details.

Eg: enter connection string as

User id as

Password as ____

5. Stop the informatica services.

6. Update nodemeta.xml with new DB details. this contains Domain information.

Cd \PowerCenter8.1.1\server

infasetup.bat updateGatewayNode -da xx.nam.nsroot.net:1522 -du infarep -dp xxxx -ds bisd -dn Domain_XXX -nn node01_XXX

Recycle informatica services.

RESTORE the informatica repository from back up

Cheers