How to add NH_RESET_ORACLE variable to make nhReset stop and restart oracle (Legacy KB ID CNC TS16700)

Document ID : KB000052287
Last Modified Date : 14/02/2018
Show Technical Document Details
Please follow the instruction to setup the variable:



1. Edit the $NH_HOME/nethealthrc.sh.usr file and add the following:



        export NH_RESET_ORACLE; NH_RESET_ORACLE="y"



2. Add the following to the $NH_HOME/nethealthrc.csh.usr



        setenv NH_RESET_ORACLE y



3. Source nethealthrc.csh



The next time the maintenance job runs, it will stop and restart the Oracle database



Related Issues/Questions:
How to add NH_RESET_ORACLE  variable to make nhReset stop and restart oracle
How to get the Maintenance job to cycle the Oracle Database

Problem Environment:
eHealth 5.6.5 and later
Oracle


(Legacy KB ID CNC TS16700 )