ORA-00018: maximum number of sessions exceeded

Products

• CA eHealth

Issue/Introduction

Problem:

 

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)

 

 

Environment:

 

 

eHealth setup is configured for Disaster Recovery and all versions from 6.2 onward.

Problem is seen on all supported Operating systems.

 

 

 

Cause:

 

The Oracle maximum session limit has been reached or exceeded, because of Oracle / eHealth / web running on both eHealth systems in a DR setup.

 

 

Resolution:

In eHealth DR environment, eHealth and Oracle should be running only on Active system and all related services should be stopped. To resolve the problem, check if Oracle or EH services are running on standby system. If so, shut it down and disable them or set them to start manually on it. Once done, check task manager for any running process starting with nh* nhi* ora* and kill them if found.

 

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

nhServer stop
nhStopDb
nhStartDb
nhServer start

Environment

Release: LHDEVC99000-6.3-eHealth-Live Health Upgrade Elements
Component: