On Red Hat Network Satellite, error logs show 'ORA-12154: TNS:could not resolve the connect identifier specified'

Issue

• After running yum update, Red Hat Network Satellite web UI doesn't start and in the logs it shows:

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 118, in initDB
    __init__DB(backend, host, port, username, password, database)
  File "/usr/share/rhn/server/rhnSQL/__init__.py", line 52, in __init__DB
    __DB.connect()
  File "/usr/share/rhn/server/rhnSQL/driver_cx_Oracle.py", line 385, in connect
    raise apply(sql_base.SQLConnectError, err_args)
SQLConnectError: (12154, 'ORA-12154: TNS:could not resolve the connect identifier specified\n', 'rhnsat', 'Connection_Connect(): server attach')

RHN 5443 2011/01/22 10:37:24 -07:00: ("DATABASE CONNECTION TO 'rhnsat' LOST", "Exception information: 'NoneType' object has no attribute 'cursor'"

• Clicking on 'Admin' -> 'Task Engine Status' causes Satellite to become unavailable.