Tuesday, July 12, 2011

HOW TO: Change the domain database password


HOW TO: Change the domain database password

Solution
To change the domain database password, do the following:
1. Back up nodemeta.xml:
    cd <informatica--installation-folder>/server/config/
    cp nodemeta.xml nodemeta_backup.xml

2. Run the command infasetup UpdateGatewayNode to change the password. Run this command on each gateway node.

Example:
cd <informatica--installation-folder>/server
infasetup.sh updateGatewayNode -DatabaseAddress in <DB IP>:<DB PORT> -DatabaseUserName <DBUid> -DatabasePassword newpassword -DatabaseType oracle -DatabaseServiceName orcl -DomainName <Domain Name> -NodeName <node Name> -NodeAddress in<Node Ip>:<Infa Port> -LogServiceDirectory C:\Informatica\PowerCenter8.1.1\server\tomcat\logs

3. Start the Informatica services.

Note:
Set the parameters enclosed within angular brackets <> according to you environment.

No comments:

Post a Comment