Updategatewaynode & Keytool Usage In Informatica Domain

Recently we came across a situation where our domain & repository database server storage was migrated to a new data center. The server name & IP addresses were changed & we needed to update the db new server details in to the Informatica domain. We used the updategatewaynode command to update the details. The command executed successfully & we started the services. All the processes were showing up on the Informatica servers but the Adminconsole URL was not coming up. We found the below errors on the node.log. We generated the keystore file with new password & executed the updategatewaynode command later we were able to login to the Adminconsole successfully.

Error Message :

SEVERE: [Thread-0]: Failed to initialize end point associated with ProtocolHandler ["http-bio-8443"]
java.io.IOException: Keystore was tampered with, or password was incorrect
            at sun.security.provider.JavaKeyStore.engineLoad(JavaKeyStore.java:771)
            at sun.security.provider.JavaKeyStore$JKS.engineLoad(JavaKeyStore.java:38)
            at java.security.KeyStore.load(KeyStore.java:1185)

How to generate a  new key store file ?

Use the below keytool command to generate the new keystore under  $INFA_HOME/tomcat/conf location.

Informa020204:/app/informatica/powercenter9.6.1/tomcat/conf>keytool -genkey -alias tomcat -keyalg RSA -keysize 2048 -validity 1000 -keystore tomcat_keystore
Enter keystore password:
Re-enter new password:
What is your first and last name?
  [Unknown]:  Password
What is the name of your organizational unit?
  [Unknown]:  Password
What is the name of your organization?
  [Unknown]:  Password
What is the name of your City or Locality?
  [Unknown]:  Password
What is the name of your State or Province?
  [Unknown]:  Password
What is the two-letter country code for this unit?
  [Unknown]:  Password
Is CN=Password, OU=Password, O=Password, L=Password, ST=Password, C=Password correct?
  [no]:  yes

Enter key password for <tomcat>
        (RETURN if same as keystore password):
Re-enter new password:
Informa020204:/app/informatica/powercenter9.6.1/tomcat/conf >

Once the key is generated we also need to execute the below self-certificate command

keytool -selfcert -alias tomcat -sigalg "MD5withRSA" -keypass KEY_PASSWORD -validity 2000 -dname "CN=HOST_NAME, OU=KEY_TOOL, O=KEY_TOOL, L=NewYork, ST=NewYork, C=US" -keystore tomcat.keystore01

How to update the new domain database details in Informatica ?

Use the below updategatewaynode command to update the domain database details in the Informatica Domain.

sh $INFA_HOME/server/infasetup.sh updategatewaynode -da database_host:port -du db_user -dp db_password -dt oracle -ds service_name -dn Domain_Name -hs 8443 -kf $INFA_HOME/tomcat/conf/tomcat_keystore -kp password -tls

Popular Posts

Featured Post

Basic unix commands used in Administration

ls –ltr                Shows all the files and sub directories in the  current directory. ls –la                  Shows all the hidden...