Satellite is unable to connect to external Oracle database (ORA-02391).

Solution Unverified - Updated -

Issue

  • Satellite is unable to connect to external oracle database.
  • Following error can be found in /var/log/httpd/error_log:
Exception Handler Information
Traceback (most recent call last):
  File "/usr/share/rhn/server/apacheHandler.py", line 84, in headerParserHandler
    rhnSQL.initDB()
  File "/usr/share/rhn/server/rhnSQL/__init__.py", line 121, in initDB
    __init__DB(backend, host, port, username, password, database)
  File "/usr/share/rhn/server/rhnSQL/__init__.py", line 59, in __init__DB
    __DB.check_connection()
  File "/usr/share/rhn/server/rhnSQL/driver_cx_Oracle.py", line 489, in check_connection
    self.connect() # only allow one try
  File "/usr/share/rhn/server/rhnSQL/driver_cx_Oracle.py", line 385, in connect
    raise apply(sql_base.SQLConnectError, err_args)
SQLConnectError: (2391, 'ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit\n', 'rhnsat', 'Connection_Connect(): begin session')

Environment

  • Red Hat Network Satellite version 5.x.
  • External Oracle database.

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In