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, 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