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
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.