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

[Eric]

Jonathon,

I had the exact same issue just a while back.

https://www.redhat.com/archives/spacewalk-list/2010-February/msg00191.html

We are running the script on Oracle RAC 11gR2.

Our DBA ran the main.sql script using sqlplus client. 


-Eric




________________________________
From: "Hooker, Jonathan" <Jonathan.Hooker at garmin.com>
To: "spacewalk-list at redhat.com" <spacewalk-list at redhat.com>
Sent: Wed, March 10, 2010 10:13:20 AM
Subject: [Spacewalk-list] Issue with Spacewalk 0.8 install on CentOS 5 and Oracle 11G

  
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.
 
Any help is much appreciated! Thanks a bunch!
 
Jonathan
Hooker 
Desktop Support - Engineering 
Garmin International 
jonathan.hooker at garmin.com
 
--------------------------------------------------------------------------------
This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies.
 
Thank you for your cooperation. 


      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20100311/95884d62/attachment.htm>