Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Moving PowerCenter repository to another box....

Moving PowerCenter repository to another box....

Moving PowerCenter repository to another box....


I had installed Informatica and Oracle database on a PC1 but due to lack of physical memory my PC1 has been swapping in/out causing huge surge in CPU, I have another PC2 where I created another database and copied the repository user from PC1 to PC2, I changed the connect string in the admin console-> repository -> ....
but If I shutdown the Oracle database on PC1 I am unable to connec to admin console etc ...it some how seems to be still connecting to PC1 database and not to PC2 database, though the connect string in admin console is pointing to PC2.

Any ideas on how to solve this problem ?


RE: Moving PowerCenter repository to another box....

The server is hard-coded in the repository. You'll need to find the tables that have that and change them. I don't remember off-hand which one's they are - i think they have 'data' in the names.

"I think we're all Bozos on this bus!" - Firesign Theatre jester

RE: Moving PowerCenter repository to another box....

Not sure what platform you're on, but I'm assuming they offer the same type of commands. You can move the object repository database and easily point it to other places, but if you're making changes to the domain repository, you'll need to stop all informatica processes make changes to the configuration and bring it back up.

This is basically the command we use to make the changes on our domain (AIX). On a PC, it will be a infasetup.bat file.

./infasetup.sh UpdateGatewayNode -da [new database host]:[new database port] -du [new database user] -dp [new database password -dt [database type i.e. db2] -ds [new database name]

RE: Moving PowerCenter repository to another box....

Forgot to add that I'm not sure what version of PowerCenter you're on so you mileage may vary.

We're currently using 8.6.1 (our first implementation) and the usage can be found in the electronic documentation in the PowerCenter Command Reference manual.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close