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, tools, and much more.