[Spacewalk-list] Issues with Oracle database blocking connections

[david.lind at 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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20120320/c1288101/attachment.htm>