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"?
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 of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
