My Oracle Support Banner

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 NOVEMBER 14, 2023

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.