The system.log file on an eHealth Solaris or Linux server displays nhiDbServer error similar to the following:
Error nhiDbServer Pgm nhiDbServer: Fork for '/opt/CA/eh63/bin/nhDeleteTempTables' failed (Not enough space).
The process that is listed (in the example above, the process is nhDeleteTempTables) may vary, but they will always be processes that impact the Oracle database.
These errors are a sign that Oracle is trying to use more swap space than is available on the server. Likely the database has grown to a size that needs more swap than the original specifications listed, or the swap space was underallocated to start with.
Follow these steps to add additional swap space to the server.
- Create an empty file large enough to appropriately size the total swap space. For example, to add an additional 6GB of swap space one might create a new file in the /swap directory.
mkfile 6000m /swap/newSwapFile
- Verify the new file was generated
- Add the new file to the existing swap area
/usr/sbin/swap -a /swap/newSwapFile
- Verify that the new swap area has been generated and is active
- Restart eHealth and Oracle
Some servers may require a full reboot for the new swap space to become available; please check with your system administrator.