VERIFIED SOLUTION i

'Unable to connect to database on host' message with Oracle in EngageOne Server

Issue

When validating the bundles in EngageOne Server, the following error is encountered:

[ERROR] [db.host = <hotname>, eo.db.name = <dbname>, eo.db.username = <user>] Unable to connect to <dbname> database on host <hostnmae> as user <user> using password provided in 'eo.db.password' property.

Cause

This may be caused due to either of the following are incorrect in deploy.properties file:
  • Oracle SID being used for the field 'eo.db.name' or 'activiti.db.name'.
  • 'db.host'

Resolution

UPDATED: December 7, 2018
Ensure to use:
  • Correct Oracle SID as 'eo.db.name' or 'activiti.db.name'.
  • Correct 'db.host' - IP or Hostname of the machine where Oracle Server is hosted.