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.
