Ehealth DB not getting started as Oracle is already running

[Legacy User]

HI All

 

I tried restarting ehealth services for ehealth 5.6.5 .

nhServer stop
nhStopDb immediate

 

Now , I am trying to start the services back but I am getting below errors.

 

 $ nhStartDb
Starting Database "EHEALTH" ...
  ORA-01081: cannot start already-running ORACLE - shut it down first
nhStartDb: 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 !!!

[Catalin Farcasanu]

The message is self explanatory. What does the oracle alert log say? 

[Pankaj Udhas Katigar]

Hi ,

 

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,

Pankaj Udhas.

CA Support

[yasal01]

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.