Registration of systems to Red Hat Network Satellite fails with Internal Server Error and generates traceback email

Issue

• When running rhnreg_ks to register a client to the satellite server, getting an Internal Server Error

• Error in /var/log/up2date on the client, e.g.,

  [Fri Feb  5 15:26:00 2010] up2date Error communicating with server. The message was:
  Internal Server Error
  [Fri Feb  5 15:26:00 2010] up2date
  Traceback (most recent call last):
    File "/usr/sbin/rhnreg_ks", line 216, in ?
      cli.run()
    File "/usr/share/rhn/up2date_client/rhncli.py", line 65, in run
      sys.exit(self.main() or 0)
    File "/usr/sbin/rhnreg_ks", line 90, in main
      rhnreg.getCaps()
    File "/usr/share/rhn/up2date_client/rhnreg.py", line 306, in getCaps
      s.capabilities.validate()
    File "/usr/share/rhn/up2date_client/rhnserver.py", line 156, in __get_capabilities
      self.registration.welcome_message()
    File "/usr/share/rhn/up2date_client/rhnserver.py", line 50, in __call__
      return rpcServer.doCall(method, *args, **kwargs)
    File "/usr/share/rhn/up2date_client/rpcServer.py", line 272, in doCall
      raise up2dateErrors.CommunicationError(e.errmsg)
  up2date_client.up2dateErrors.CommunicationError: Error communicating with server. The message was:
  Internal Server Error
  

• Apache error in /var/log/httpd/ssl_error_log on the Red Hat Network Satellite server shows errors connecting to Oracle database:

  Exception Handler Information
  Traceback (most recent call last):
    File "/usr/share/rhn/server/apacheHandler.py", line 72, in headerParserHandler
      rhnSQL.initDB()
    File "/usr/share/rhn/server/rhnSQL/__init__.py", line 98, 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 445, in check_connection
      self.connect() # only allow one try
    File "/usr/share/rhn/server/rhnSQL/driver_cx_Oracle.py", line 336, 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 3093 2010/02/08 16:45:56 -07:00: ("DATABASE CONNECTION TO 'rhnsat' LOST", "Exception information:
   'NoneType' object has no attribute 'cursor'")
  RHN 3093 2010/02/08 16:45:56 -07:00: ('Connection attempt failed', 12154, 'ORA-12154: TNS:could not resolve the connect identifier specified\n')