[Spacewalk-list] ORA-12952 during 0.7 to 0.8 upgrade

[Brian Kosick]

I'm forgetting the exact details, but I've run into this before, the it's hitting the flash size limit.   You can follow (google for it) howto's to increase the flash size limit, but that only puts off the error.   The thing that I've found works best are the following steps...

su - oracle


-bash-3.2$ rman nocatalog target /


RMAN> crosscheck archivelog all;
<output>

RMAN> delete expired archivelog all;
<output>

RMAN> quit;

Answer yes at the prompt or use "noprompt": delete noprompt expired archivelog all;
restart spacewalk: /usr/sbin/rhn-satellite restart


Everything should be back up and running.

this marks expired logs to be marked, then deleted.   Freeing up the flash space.

I put it in a script and cron'd it.


On Wed, 2010-02-24 at 09:02 +0800, Colin Coe wrote:


Hi all

While running 'spacewalk-schema-upgrade' to upgrade from 0.7 to 0.8 it
got errors stating 'ORA-12952: The request exceeds the maximum allowed
database size of 4 GB'

In the Oracle Web UI, Home>Administration>Storage shows:
---
Space Allocated:         5,110 MB
Available:      10 MB
Physical Limit:         5,120 MB
Percent Used:   100%
---

I only have a handful of nodes registered and the only software
channels are RHEL 5 and RHEL 4 ES plus EPEL for both.

In the Oracle Web UI, I tried compacting storage
(Home>Administration>Storage>Compact Storage) but no additional space
becomes available.

Any ideas on how to resolve this?

Thanks

CC

--
RHCE#805007969328369

_______________________________________________
Spacewalk-list mailing list
Spacewalk-list at redhat.com<mailto:Spacewalk-list at redhat.com>
https://www.redhat.com/mailman/listinfo/spacewalk-list


-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 4657 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20100223/a753c1ba/attachment.bin>