[Spacewalk-list] Oracle bites again (ORA-02291)

[Eugene]

Michael,

When I ran my tests in March I downloaded Oracle 11.2.0.3 from their web site and installed on RHEL 6 x86_64 derivative with all default options. Same with 11.2.0.2. Only 11.2.0.1 passed fresh spacewall 1.7 install. I suppose that 11.2.0.3 EE in RedHat office differs from a basic default install. There is no other explanation. I haven't tried any more install tests since March - my project was put on hold - don't know if the same error is stil reproducible with latest spacewalk.

Regarding fixing Oracle code. It is not even near the point of my email.

Having reproduced spacewalk 1.7 + oracle 11.2.0.2+ sql error every single time (I even saved full SQL script and ran it on several databases with the same results) I am very surprised with inability to reproduce it by spacewalk developers. Granted, RedHat DB admin may have used some clever options which prevented the error in first place.

Eugene.

03.08.2012, 08:01, "Michael Mraka" <michael.mraka at redhat.com>:
> Eugene wrote:
> % In the message
> % https://www.redhat.com/archives/spacewalk-list/2012-March/msg00014.html
> % I clearly said that 11.2.0.2 and newer are not working. Downgrade to
> % 11.2.0.1 and you won't see any errors.
>
> That's not correct. I run number of test spacewalk installation with
> Oracle 11.2.0.3 EE without any problems.
>
> The issue is not reproducible on Oracle 11.2.0.3 EE we use. So your
> database most likely uses some advanced options we don't (e.g some of
> RAC, Partitioning, Data Mining, Warehouse, Compression,... whatever) and
> they make the difference.
>
> % Jan keeps saying that "We were never able to reproduce those
> % internally" for several months. I have an impression that all attempts
> % to reproduce were done on 11.2.0.1. It took me no time to reproduce on
> % anything newer then 11.2.0.1. Fresh install failed every single time
> % on several different systems. Please see archives mentioned.
>
> Jan keeps saying: if you pay money to Oracle for their database and it
> doesn't work, ask their support.
> Or ask them to open their sources so people from community can help. :)
>
> % Eugene.
>
> Regards,
>
> --
> Michael Mráka
> Satellite Engineering, Red Hat
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list