RHN Satellite Web UI does not work anymore with ORA-01034 and ORA-27101 errors in logs
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.