IO Error: Got minus one from a read call AND ORA-00020: maximum number of processes Error in MetaSolv Server/s (Doc ID 2301356.1)

Last updated on SEPTEMBER 08, 2017

Applies to:

Oracle Communications MetaSolv Solution - Version 6.2.1 and later
Information in this document applies to any platform.

Goal

Customer continuously seeing below errors in app servers and correspondingly in DB we are seeing processes reached to maximum (4000).

DB Errors:

ORA-20 errors will not be written to the alert log for the ORA-20 errors.
ORA-00020: maximum number of processes (4000) exceeded
ORA-20 errors will not be written to the alert log for the ORA-20 errors.
ORA-00020: maximum number of processes (4000) exceeded
ORA-20 errors will not be written to the alert log for the ORA-20 errors.
ORA-00020: maximum number of processes (4000) exceeded
ORA-20 errors will not be written to the alert log for the ORA-20 errors.
ORA-00020: maximum number of processes (4000) exceeded
ORA-20 errors will not be written to the alert log for the ORA-20 errors.
ORA-00020: maximum number of processes (4000) exceeded
ORA-20 errors will not be written to the alert log for the ORA-20 errors.

App server errors :
java.sql.SQLException: Connection has been administratively destroyed. Reconnect.
<JDBC> <BEA-001129> <Received exception while creating connection for pool "mslvProcDataSource": IO Error: Got minus one from a read call>

 

These errors are resultants of DB processes reaching to the limit. Issue can be resolved by increasing the number of processes allowed for DB, but customer has following queries:

  1. Is there a impact if we increases process count ( either to app or to DB) ?
  2. To what maximum setting we can we go?
  3. Why we get this error all the time?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms