After updating Red Hat Satellite to version 5.6 can see lots of oracle related messages in "/var/log/rhn/rhn_web_api.log".

Issue

• Can see following error messages on recently upgraded Red Hat Satellite-5.6 under /var/log/rhn/rhn_web_api.log:

[Tue Oct 21 05:15:30 2014] [error] Exception Handler Information
[Tue Oct 21 05:15:30 2014] [error] Traceback (most recent call last):
[Tue Oct 21 05:15:30 2014] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/apacheHandler.py", line 80, in headerParserHandler
[Tue Oct 21 05:15:30 2014] [error]     rhnSQL.initDB()
[Tue Oct 21 05:15:30 2014] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/__init__.py", line 124, in initDB
[Tue Oct 21 05:15:30 2014] [error]     __init__DB(backend, host, port, username, password, database)
[Tue Oct 21 05:15:30 2014] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/__init__.py", line 62, in __init__DB
[Tue Oct 21 05:15:30 2014] [error]     __DB.check_connection()
[Tue Oct 21 05:15:30 2014] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 517, in check_connection
[Tue Oct 21 05:15:30 2014] [error]     self.connect() # only allow one try
[Tue Oct 21 05:15:30 2014] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 388, in connect
[Tue Oct 21 05:15:30 2014] [error]     self.dbh = self._connect()
[Tue Oct 21 05:15:30 2014] [error]   File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 414, in _connect
[Tue Oct 21 05:15:30 2014] [error]     dbh = cx_Oracle.Connection(self.dsn)
[Tue Oct 21 05:15:30 2014] [error] SQLConnectError: (12541, 'ORA-12541: TNS:no listener\\n', '//localhost:1521/rhnsat.world', 'Connection_Connect(): server attach')
[Tue Oct 21 05:15:30 2014] [error]
[Tue Oct 21 05:15:30 2014] [error] RHN 19866 2014/10/21 05:15:30 +01:00: ("DATABASE CONNECTION TO '//localhost:1521/rhnsat.world' LOST", "Exception information: 'NoneType' object has no attribute 'cursor'")
[Tue Oct 21 05:15:30 2014] [error] RHN 19866 2014/10/21 05:15:30 +01:00: ('Connection attempt failed', 12541, 'ORA-12541: TNS:no listener\\n')