[Spacewalk-list] Fw: Database Error: Oracle 11g
Eric
linux_4_u at yahoo.com
Thu Feb 25 16:00:31 UTC 2010
Hit the wrong button.
----- Original Message ----
From: Michael Mraka <michael.mraka at redhat.com>
To: Eric <linux_4_u at yahoo.com>; spacewalk-list at redhat.com
Sent: Tue, February 23, 2010 4:53:06 AM
Subject: Re: [Spacewalk-list] Database Error: Oracle 11g
Eric wrote:
% Bump.
%
% Nobody has any idea how to resolve this issue? Or what I should be looking for?
% I read that some people have 11gR2 working with Spacewalk.
% What am I missing?
IMHO it's a human error during manual db setup and has nothing in common
with 11g.
ORA-02291: integrity constraint
(RHNSAT.RHN_SCHDY_SCHED_SCHEDULE_ID_FK) violated - parent key not found
- probably forgotten data import to rhn_schedule_days table
Finally managed to get main.sql run for Oracle 11gR2.
FYI: For some reason the sequence value inserted into the table, rhn_schedules, for RECID was 2. Once it was changed to 1 the rest of the script finished as expected. Not sure what the problem was exactly.
I am about to do a clean install of Spacewalk 0.8 on a RHEL5 (i386) via yum using Oracle 11g on a external server.
I have installed
oracle-instantclient11.2-sqlplus-11.2.0.1.0-1.i386
oracle-instantclient11.2-basic-11.2.0.1.0-1.i386
I now have the schema created and the database pre-populated. However, when I try to install the rpm oracle-lib-compat.i386 I receive the error:
Error: Missing Dependency: oracle-instantclient-basic = 10.2.0.4 is needed by package oracle-lib-compat-10.2-21.el5.i386 (spacewalk).
Does this imply I cannot use the 11.2 Oracle instant clients?
Are there instructions on the Spacewalk wiki for installing Spacewalk using an external Oracle Database?
Thanks in advance,
-Eric
% ----- Original Message ----
% From: Eric <linux_4_u at yahoo.com>
% To: spacewalk-list <spacewalk-list at redhat.com>
% Sent: Fri, February 19, 2010 12:45:05 PM
% Subject: [Spacewalk-list] Database Error: Oracle 11g
%
% A colleague of mine is trying to setup the database manually (don't ask why) using rhn/oracle/main.sql from spacewalk-schema-0.8.12-1.el5.noarch.rpm.
...
% SQL> INSERT INTO rhn_schedule_days
% 2 (recid, schedule_id, ord, start_1, end_1, start_2, end_2, start_3, end_3, start_4, end_4, last_update_user, last_update_date)
% 3 VALUES
% 4 (rhn_schedule_days_recid_seq.nextval, 1, 0, to_date('08-SEP-2000 12:00:02 AM', 'DD-MON-YYYY HH:MI:SS AM'), to_date('09-SEP-2000 12:00:00 AM', 'DD-MON-YYYY HH:MI:SS AM'), null, null, null, null, null, null, 'system', null);
% INSERT INTO rhn_schedule_days
% *
% ERROR at line 1:
% ORA-02291: integrity constraint (RHNSAT.RHN_SCHDY_SCHED_SCHEDULE_ID_FK) violated - parent key not found
Regards,
--
Michael Mráka
Satellite Engineering, Red Hat
More information about the Spacewalk-list
mailing list