[Spacewalk-list] Issues with Oracle database blocking connections

[david...@sandvik.com]

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?

All the best,

David Lind

This e-mail is confidential and it is intended only for the addressees. Any review, dissemination, distribution, or copying of this message by persons or entities other than the intended recipient is prohibited. If you have received this e-mail in error, kindly notify us immediately by telephone or e-mail and delete the message from your system. The sender does not accept liability for any errors or omissions in the contents of this message which may arise as a result of the e-mail transmission.

[Michael Mraka]

david...@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

_______________________________________________
Spacewalk-list mailing list
Spacewa...@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list