[Spacewalk-list] Spacewalk + Oracle XE =>ORA-12952: The request exceeds the maximum allowed database size of 4 GB

[David Nutter]

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?
> 
> root at 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