On Mon, Nov 23, 2009 at 11:01:44AM +0100, Santi Saez wrote: > > Hi! > > We're getting continuously this error via mail: > > SQL Error generated: (12952, 'ORA-12952: The request exceeds the maximum > allowed database size of 4 GB\nORA-06512: at "SPACEWALK.RHN_SERVER", > line 231\nORA-06512: at line 1\n') > > What can I do to solve this? Any tips to purge/compact XE database? > > r...@spacewalk:~ > # du -sh /usr/lib/oracle/xe/oradata/XE/* > 3,7M /usr/lib/oracle/xe/oradata/XE/control.dbf > 571M /usr/lib/oracle/xe/oradata/XE/sysaux.dbf > 361M /usr/lib/oracle/xe/oradata/XE/system.dbf > 149M /usr/lib/oracle/xe/oradata/XE/temp.dbf > 501M /usr/lib/oracle/xe/oradata/XE/undo.dbf > 4,1G /usr/lib/oracle/xe/oradata/XE/users.dbf > > I can't register new clients.. thanks!!
If you are using monitoring it's a good idea to periodically clear out the monitoring data tables. There's a script kicking around somewhere that does this, probably it'll be included in Spacewalk 0.7. Also, if you have loads of old packages in your channels, clear them out and delete them from the server and trash any old errata. This helps a bit, but you'll probably have to bite the bullet and buy an oracle licence eventually. Regards, -- David Nutter Tel: +44 (0)131 650 4888 BioSS, JCMB, King's Buildings, Mayfield Rd, EH9 3JZ. Scotland, UK Biomathematics and Statistics Scotland (BioSS) is formally part of The Scottish Crop Research Institute (SCRI), a registered Scottish charity No. SC006662 _______________________________________________ Spacewalk-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-list
