Informatica Power Center Migration to a Different server (#InformaticaMigration, #PowerCenter)

Scope of this blog post:

Informatica Power Center Domain and Repository service which is setup on a server (single node) needs to be migrated to a new/different server. This information is analogous to do a DR (Disaster Recovery) for Power Center.

High level Steps:

  1. Backup the Domain and Repository contents from command line
  2. Migrate (copy or scp) the Backups (Domain and Repository) to the new/different server
  3. Copy the complete install directory from old server to new server
  4. Restore the Domain using
  5. Update Gateway node using
  6. Start the services

Detailed Steps:

  1. For Backing up the Domain and Repository content, follow the instructions as mentioned in below blog post,
  2. Create the Domain and Repository users in Database (Oracle in this case),

create user Informatica_domain identified by <pwd> default tablespace users;

create user informatica_repo identified by <pwd> default tablespace users;

grant connect,resource,sse_role to informatica_domain;

grant connect,resource,sse_role to informatica_repo;

3. Restore the domain using below command,

cd $INFA_HOME/server

sh RestoreDomain -da <DB_HOST>:<DB_PORT> -du Informatica_domain -dp <pwd> -dt oracle -ds <DB_NAME> -bf  infa_domain.mrep

4. Update Gateway node using

cd $INFA_HOME/server

sh UpdateGatewayNode -da <DB_HOST>:<DB_PORT> -du Informatica_Domain -dp <pwd>-dt oracle -ds <DB_NAME> -dn <Domain_hostname> -nn <node01_hostname> -na <NewInformaticaServer>:6005 –rst

5. Start Informatica Services,

cd $INFA_HOME/tomcat/bin

./ startup

6. Once the services are started, restore the Informatica Repository from Admin Console or follow the below steps to perform the same from command line.

pmrep connect -r REP_NAME -d DOMAIN_NAME -n Administrator -x PASSWORD

pmrep restore -i REP_NAME.rep -u Admin_User -p Admin_Password

This entry was posted in Informatica. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s