How can I increase the number of processes in my busy Red Hat Network Satellite (version 5 or above) when it is showing "ORA-00020: maximum number of processes exceeded"?

Solution Verified - Updated -

Issue

  • Getting exceptions from Red Hat Network (RHN) Satellite server.
SQLConnectError:(20, 'ORA-00020: maximum number of processes (%s) exceeded\n',rhnsat', 'Connection_Connect(): begin session') </code>
  • RHN is flooding us with traceback messages as multiple clients attempt to check in.
  • The messages seemingly contain the same error message (DatabaseError: ORA-00018: maximum number of sessions exceeded).
  • Complete Traceback is as below :
Traceback (most recent call last): 
  File "/usr/share/rhn/server/apacheHandler.py", line 65, in headerParserHandler 
    rhnSQL.initDB() 
  File "/usr/share/rhn/server/rhnSQL/__init__.py", line 58, in initDB 
    __init__DB(db) 
  File "/usr/share/rhn/server/rhnSQL/__init__.py", line 41, in __init__DB 
    __DB.check_connection() 
  File "/usr/share/rhn/server/rhnSQL/int_oracle.py", line 377, in check_connection 
    self.connect() # only allow one try 
  File "/usr/share/rhn/server/rhnSQL/int_oracle.py", line 282, in connect 
    raise apply(sql_base.SQLConnectError, err_args) 
SQLConnectError:
(20, 'ORA-00020: maximum number of processes (%s) exceeded\n','rhnsat', 'Connection_Connect(): begin session') </code>
  • getting DatabaseError
    DatabaseError: ORA-00018: maximum number of sessions exceeded

Environment

  • Red Hat Network (RHN) Satellite

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content