DX Application Performance Management

Expand all | Collapse all

Ehealth DB not getting started as Oracle is already running

Jump to Best Answer
  • 1.  Ehealth DB not getting started as Oracle is already running

    Posted 06-12-2018 05:59 AM

    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 !!!



  • 2.  Re: Ehealth DB not getting started as Oracle is already running

    Posted 06-12-2018 06:37 AM

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



  • 3.  Re: Ehealth DB not getting started as Oracle is already running
    Best Answer

    Posted 06-12-2018 06:53 AM

    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



  • 4.  Re: Ehealth DB not getting started as Oracle is already running

    Posted 06-13-2018 08:33 AM

    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.