[Spacewalk-list] Oracle XE reached 4GB Limit

[Sabuj Pattanayek]

Hi,

SQL> select sum(bytes)/1024/1024 from dba_data_files;

SUM(BYTES)/1024/1024
--------------------
                5530

SQL> select sum(bytes)/1024/1024 from v$log;

SUM(BYTES)/1024/1024
--------------------
                 100

For me it's showing that I broke the 4GB limit a long time ago. Also :

# du -sh oradata/
5.6G    oradata/


I don't seem to be having problems kickstarting new machines, updating
machines, or sync'ing new packages into the repo. Or am I determining
the size of the XE db incorrectly?


On Wed, Oct 13, 2010 at 8:07 AM, Sabuj Pattanayek <sabujp at gmail.com> wrote:
> How did you know you hit the 4gb limit?
>
> On Wed, Oct 13, 2010 at 7:56 AM, Rampersad, Shaun
> <Shaun.Rampersad at rmb.co.za> wrote:
>>
>> Rampersad, Shaun wrote:
>>>> Hi all
>>>>
>>>>
>>>>
>>>> I've been using spacewalk to manage my centos servers. I have a mix of
>>>> Centos 4 and 5, both 32 and 64 bit. I have created channels for each one
>>>> of them and have over 100 servers registered.
>>>>
>>>>
>>>>
>>>> The problem is that the Oracle XE DB has reached its 4GB limit. How can
>>>> I get around this? Do I need to delete all "old" packages from the
>>>> repository and then delete the channel and upload?
>>>
>>>I do not have any solutions to offer other than trying to trim/purge old
>>>system profiles and packages.
>>
>> I have deleted the Centos4 i386 channels since I only had 6 servers registered on this. I have also deleted about 3000 orphaned packages on spacewalk under "Manage Software Packages" but I still cannot load newer packages on Centos 5 channel. Its as if the delete did not free up the DB space and it is still on 4GB
>>
>> Anything else I can try? I wanted to delete the Centos4 x86_64 bit channel as well but if it has no effect then its pointless.
>>
>> Thanks
>> Shaun
>>
>>>
>>>
>>>> Are there any alternatives to Oracle XE? Has there been any progress on
>>>> Postgres? I see that this is scheduled for release on spacewalk 2.0.
>>>
>>>Postgres is progressing, slowly, but we have achieved a point where it
>>>can install and some very basic functionality seems to work, but it is
>>>not even in an alpha state. More information:
>>>
>>>https://www.redhat.com/archives/spacewalk-devel/2010-October/msg00017.html
>>>
>>>Spacewalk nightly can be installed without Oracle bits (developers only)
>>>
>>>NOTE: developers only...
>>>
>>>Cliff
>>
>> This e-mail is subject to a disclaimer, available at http://www.rmb.co.za/web/elements.nsf/online/disclaimer-communications.html
>>
>> _______________________________________________
>> Spacewalk-list mailing list
>> Spacewalk-list at redhat.com
>> https://www.redhat.com/mailman/listinfo/spacewalk-list
>>
>