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:
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'"
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 )