During iXp startup, the database connection times out while there is no problem to access the database with sqlplus

Document ID : KB000018180
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

During its startup, the database connection times out while there is no issue to access it with sqlplus

Solution:

Before attempting any connection to the database, iXp pings the Autosys server and if there is any firewall restriction, the database connection will not be done

On the iXp server update the JAVA_OPTS env var with -Dixp.server.db.test.host.reachable=false
For example:
JAVA_OPTS=-Dixp.home=/opt/pgti/ixphome -Xms1500M -Xmx1500M -Dixp.server.db.test.host.reachable=false