TECH TIP: ORA-00018: maximum number of sessions exceeded

Document created by Darshan_Desai Employee on Aug 11, 2014Last modified by SamCreek on Dec 17, 2016
Version 2Show Document
  • View in full screen mode

Problem summary:


eHealth and Database is down with following error seen in eHealth system.log

Internal Error nhiDbServer Pgm nhiDbServer: Database error:  (ORA-00018: maximum number of sessions exceeded). (cdb/cdbJobAddRunRow)

 

Solution:

 

The Oracle maximum session limit has been reached or exceeded. In eHealth DR environment, check if Oracle or EH services are running on secondary server. If so, shut it down on secondary server and disable them or set them to start manually on it. Once done, check task manager for any running process and kill them.

 

On primary server, shutdown and restart the eHealth and Oracle server processes to clear the connections:

nhServer stop
nhStopDb
nhStartDb
nhServer start

Attachments

    Outcomes