[Spacewalk-list] Issue with Spacewalk 0.8 install on CentOS 5 and Oracle 11G

[Michael Mraka]

Hooker, Jonathan wrote:
% Hi,
% 
% I am in the process of trying to get a spacewalk server up on CentOS 5 and Oracle 11g and the database does not fully populate. In the logs we are getting the following error:
% 
% ORA-02291: integrity constraint (SPWK_APPS.RHN_SCHDY_SCHED_SCHEDULE_ID_FK)
% violated - parent key not found
% 
% And when we tried to manually populate the database using the main.sql from /etc/sysconfig/rhn/oracle we get the following error:
% 
% ORA-02303: cannot drop or replace a type with type or table dependents
% 
% In both cases we are able to tell that the database is getting partially populated, the population is just failing partway through.

Probably an error in manuall population. Wipe out the schema and
(re)populate it again from scratch.  I've checked standard Spacewalk 0.8
installation on Oracle 11g and it's finished fine.

% Any help is much appreciated! Thanks a bunch!
% 
% Jonathan Hooker
% Desktop Support - Engineering
% Garmin International
% jonathan.hooker at garmin.com<mailto:jonathan.hooker at garmin.com>

Regards,

--
Michael Mráka
Satellite Engineering, Red Hat