I tried restarting ehealth services for ehealth 5.6.5 .
nhServer stopnhStopDb immediate
Now , I am trying to start the services back but I am getting below errors.
$ nhStartDbStarting Database "EHEALTH" ... ORA-01081: cannot start already-running ORACLE - shut it down firstnhStartDb: failed (first attempt) to start database "EHEALTH".nhStartDb: attempting 'shutdown abort' + 'startup' ... Database "EHEALTH" already shut down. Starting Database "EHEALTH" ... ORA-01081: cannot start already-running ORACLE - shut it down first
nhStartDb: FAILED (multiple attempts) to start database "EHEALTH".Please examine Oracle alert log or contact Concord Technical Support.
It says Oracle is already running and needs to be shut down before Starting DB.
I could see below process related to Oracle running .
$ ps -ef | grep -i ora neth 28041 23671 0 07:20:47 pts/2 0:00 grep -i ora neth 24455 1 0 07:00:16 ? 0:00 ora_lgwr_EHEALTH neth 24457 1 0 07:00:16 ? 0:00 ora_ckpt_EHEALTH neth 24453 1 0 07:00:16 ? 0:00 ora_dbw0_EHEALTH neth 24459 1 0 07:00:16 ? 0:00 ora_smon_EHEALTH neth 24461 1 0 07:00:16 ? 0:00 ora_reco_EHEALTH
So , I tried killing them and again re-running the nhStartDB , but got the same error again.
How could I stop the Oracle service manually. Need urgent help !!!
The message is self explanatory. What does the oracle alert log say?
Here the issue is 'when you ran the command (nhStopDb immediate), this command was not executed successfully.
So, please try to kill all the running eHealth & Oracle related services via command line using:
'kill -9 PID'
Once done, please start the Oracle(nhStartDb) & eHealth service(nhServer start).
Thanks & Regards,
The problem causing the error "ORA-01081: cannot start already-running ORACLE - shut it down first", is that while the Oracle processes appear to be stopped, there is a half-running zombie process still in memory that is not releasing the process semaphore (flag), so nhStartDb fails when trying to get the this semaphore to start Oracle. Best way to fix this is to clear the memory by rebooting the physical server.