Error: "nhiCheckOracle.sh requires ORACLE to be running and accessible, but it doesn't seem to be. Please start ORACLE and try again" (Legacy KB ID CNC TS25053 )

Products

• CA eHealth

Issue/Introduction

Make sure to modify the following after changing the hostname of a system:

1.  $ORACLE_HOME\network\admin\tnsnames.ora
2.  $ORACLE_HOME\network\admin\listener.ora
3. Name of the host in the NH_MACHINE table
4. The value of the NH_DB_CONNECT_STRING variable to be "<HOSTNAME>_<ORACLE_SID>".

Related Issues/Questions:
Error: "nhiCheckOracle.sh requires ORACLE to be running and accessible, but it doesn't seem to be. Please start ORACLE and try again"
eHealth server fails to start after changing hostname
What is NH_DB_CONNECT_STRING environment variable

Problem Environment:
Oracle
eHealth 6.0 and later

Causes of this problem:
eHealth 6.0 introduced the NH_DB_CONNECT_STRING variable. The variable controls access to the database and is matched to Connect String in the $ORACLE_HOME\network\admin\tnsnames.ora


(Legacy KB ID CNC TS25053 )

Environment

Release:
Component: EHCON