Invalid User error when accessing Web UI. When accessing OneClick, get Database error: error while trying to retrieve text for error ORA-12154 [KSQL:OpenConnection:OCILogon]

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

PROBLEM:

Invalid User error when accessing Web UI.

When accessing OneClick, get the following error:

Database error: error while trying to retrieve text for error ORA-12154 [KSQL:OpenConnection:OCILogon]

SOLUTION: 

Please check the path for ORACLE_HOME under /etc/init.d/httpd

ORACLE_HOME="/ehealth/oracle/ora11"; export ORACLE_HOME

Compare the path in httpd with the path in nethealthrc.sh, edit /etc/init.d/httpd to match the latter, and the restart the web service.

In Solaris or Linux: nhHttpd stop/start

In Windows: stop and start the service eHealth httpd63