Statistics Poller cannot connect to the Oracle Database (Legacy KB ID CNC TS15265 )

Article Id: 52016
Status: Published
Updated On: 14-02-2018 06:58
Legacy Id: TEC514166
Products:
Issue/Introduction:

Assign the permissions:



    • chmod 555 $NH_ORACLE_HOME/bin/oracle  $NH_ORACLE_HOME/bin/oracle0

    • chmod +s  $NH_ORACLE_HOME/bin/oracle  $NH_ORACLE_HOME/bin/oracle0

    The files should be owned by $NH_USER.


    Then stop/restart oracle by running the commands:



      • nhStopDb

      • nhStartDb


      Related Issues/Questions:
      Statistics Poller cannot connect to the Oracle Database
      Error in system.log:  Internal Error nhiPoller[Import] Pgm nhiPoller[Import]: Assertion for 'Bad' failed, exiting (failed to get schema rev in file ../plrConfig.C, line 1183).
      Error: "ORA-27123: unable to attach to shared"
      eHealth command function gives an error message
      Error: "Unable to get a handle for database 'databaseName'"

      Problem Environment:
      eHealth
      Oracle
      Unix

      Causes of this problem:
      These errors can occur when not executing command as the $NH_USER or when there are permissions issues on the Oracle executables


      (Legacy KB ID CNC TS15265 )

      Environment:

      Release: LHBASC99000-6.2-eHealth-Live Health Upgrade Elements
      Component: