RHN Satellite Web UI does not work anymore with ORA-01034 and ORA-27101 errors in logs

Solution Verified - Updated -

Issue

  • The WebUI of the Satellite does not display anymore, with the following errors in logs:

    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    
  • Satellite database backup script fails to start oracle and sends tracebacks with:

    SQLConnectError: (1034, 'ORA-01034: ORACLE not available\nORA-27101: shared memory realm does not exist\nLinux-x86_64 Error: 2: No such file or directory\n', 'rhnsat', 'Connection_Connect(): begin session')
    
  • These errors occur on every access to the database:

    Feb  5 09:06:46 lnx-sat osa-dispatcher: RHN 4046 2010/02/05 09:06:46 +02:00: ('Connection attempt failed', 1034, 'ORA-01034: ORACLE not available\nORA-27101: shared memory realm does not exist\nLinux Error: 2: No such file or directory\n')
    Feb  5 09:06:46 lnx-sat osa-dispatcher: RHN 4046 2010/02/05 09:06:46 +02:00: ('Traceback (most recent call last):\n  File "/usr/share/rhn/osad/jabber_lib.py", line 105, in main\n    self.setup_config(config)\n  File "/usr/share/rhn/osad/osa_dispatcher.py", line 73, in setup_config\n    rhnSQL.initDB()\n  File "/usr/share/rhn/server/rhnSQL/__init__.py", line 58, in initDB\n    __init__DB(db)\n  File "/usr/share/rhn/server/rhnSQL/__init__.py", line 36, in __init__DB\n    __DB.connect()\n  File "/usr/share/rhn/server/rhnSQL/int_oracle.py", line 309, in connect\n    raise apply(sql_base.SQLConnectError, err_args)\nSQLConnectError: (1034, \'ORA-01034: ORACLE not available\\nORA-27101: shared memory realm does not exist\\nLinux Error: 2: No such file or directory\\n\', \'rhnsat\', \'Connection_Connect(): begin session\')\n',)
    
  • osa-dispatcher.log from the satellite-debug, contains more details on the errors:

    2010/02/05 09:06:46 +02:00 4046 0.0.0.0: rhnSQL/int_oracle.connect('Connecting to database', 'rhnsat')
    2010/02/05 09:06:46 +02:00 4046 0.0.0.0: rhnSQL/int_oracle.connect('ERROR', 'Connection attempt failed', 1034, 'ORA-01034: ORACLE not available\nORA-27101: shared memory realm does not exist\nLinux Error: 2: No such file or directory\n')
    2010/02/05 09:06:46 +02:00 4046 0.0.0.0: osad/jabber_lib.main('ERROR', 'Error caught:')
    2010/02/05 09:06:46 +02:00 4046 0.0.0.0: osad/jabber_lib.main('ERROR', 'Traceback (most recent call last):\n  File "/usr/share/rhn/osad/jabber_lib.py", line 105, in main\n    self.setup_config(config)\n  File "/usr/share/rhn/osad/osa_dispatcher.py", line 73, in setup_config\n    rhnSQL.initDB()\n  File "/usr/share/rhn/server/rhnSQL/__init__.py", line 58, in initDB\n    __init__DB(db)\n  File "/usr/share/rhn/server/rhnSQL/__init__.py", line 36, in __init__DB\n    __DB.connect()\n  File "/usr/share/rhn/server/rhnSQL/int_oracle.py", line 309, in connect\n    raise apply(sql_base.SQLConnectError, err_args)\nSQLConnectError: (1034, \'ORA-01034: ORACLE not available\\nORA-27101: shared memory realm does not exist\\nLinux Error: 2: No such file or directory\\n\', \'rhnsat\', \'Connection_Connect(): begin session\')\n')
    2010/02/05 09:06:56 +02:00 4046 0.0.0.0: rhnSQL/int_oracle.check_connection('ERROR', "DATABASE CONNECTION TO 'rhnsat' LOST", "Exception information: 'NoneType' object has no attribute 'cursor'")
    2010/02/05 09:06:56 +02:00 4046 0.0.0.0: rhnSQL/int_oracle.connect('Connecting to database', 'rhnsat')
    

Environment

  • Red Hat Network (RHN) Satellite with embedded 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