[email protected] 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 [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
