Starting Oracle DB instance failed with error "logger: Error: Oracle DB instance rhnsat NOT started" on Red Hat Network Satellite.

Issue

• Starting Oracle DB instance failed with error logger: Error: Oracle DB instance rhnsat NOT started on Red Hat Network Satellite.

• The following error messages are produced when rhn-satellite restart command is issued.

Starting Oracle DB instance "rhnsat" ...                   [FAILED]
logger: Error: Oracle DB instance rhnsat NOT started.
Starting tomcat5:                                          [  OK  ]
Starting httpd: httpd: Could not reliably determine the server's fully qualified domain name, using satellite.example. for ServerName
                                                           [  OK  ]
Starting osa-dispatcher: RHN 12684 2012/07/05 18:51:20 +01:00: ('Connection attempt failed', 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')
RHN 12684 2012/07/05 18:51:20 +01:00: ('Error caught:',)
RHN 12684 2012/07/05 18:51:20 +01:00: ('Traceback (most recent call last):\n  File "/usr/share/rhn/osad/jabber_lib.py", line 119, in main\n    self.setup_config(config)\n  File "/usr/share/rhn/osad/osa_dispatcher.py", line 81, in setup_config\n    rhnSQL.initDB()\n  File "/usr/share/rhn/server/rhnSQL/__init__.py", line 121, in initDB\n    __init__DB(backend, host, port, username, password, database)\n  File "/usr/share/rhn/server/rhnSQL/__init__.py", line 52, in __init__DB\n    __DB.connect()\n  File "/usr/share/rhn/server/rhnSQL/driver_cx_Oracle.py", line 385, 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-x86_64 Error: 2: No such file or directory\\n\', \'rhnsat\', \'Connection_Connect(): begin session\')\n',)
                                                           [  OK  ]