[Spacewalk-list] Issues with Oracle database blocking connections

[Michael Mraka]

david.lind at sandvik.com wrote:
% Hello,
% 
% Some days ago a colleague of mine was syncing a channel in our Spacewalk 
% and all of a sudden the syncing just froze and he was unable to cancel it. 
% Since this happened we've had major issues with the Oracle database such 
% as Spacewalk not being able to communicate with it due to blocking. When 
% this happends we are forced to use to following:
% 
% ORACLE> alter database mount;
% ORACLE> recover database until cancel;
% ORACLE> alter database open resetlogs;
% 
% This allows Spacewalk to function normally again, but within a couple of 
% hours we're back at the same issue.
% 
% Checking the httpd error.log reveals this:
% 
% Exception Handler Information
% Traceback (most recent call last):
%   File 
% "/usr/lib/python2.4/site-packages/spacewalk/server/apacheHandler.py", line 
% 80, in headerParserHandler
%     rhnSQL.initDB()
%   File 
% "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/__init__.py", 
% line 124, in initDB
%     __init__DB(backend, host, port, username, password, database)
%   File 
% "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/__init__.py", 
% line 55, in __init__DB
%     __DB.connect()
%   File 
% "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", 
% line 388, in connect
%     self.dbh = self._connect()
%   File 
% "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", 
% line 414, in _connect
%     dbh = cx_Oracle.Connection(self.dsn)
% SQLConnectError: (1033, 'ORA-01033: ORACLE initialization or shutdown in 
% progress\nProcess ID: 0\nSession ID: 0 Serial number: 0\n', 'xe', 
% 'Connection_Connect(): begin session')
% 
% Has anyone encountered a similiar issue?

Check /usr/lib/oracle/xe/app/oracle/admin/XE/bdump/alert_XE.log if there
are any errors.

Regards,

--
Michael Mráka
Satellite Engineering, Red Hat