<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40"> <head> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"> <meta name=Generator content="Microsoft Word 12 (filtered medium)">  <style>  </style>  </head> <body lang=EN-US link=blue vlink=purple> <div class=Section1> I have attached more information on the issues we are having importing deploy.sql into our oracle 11g database. Does anyone have any ideas as to why we are seeing these errors?<o:p></o:p> <o:p> </o:p> <div> Jonathan Hooker Desktop Support - Engineering Garmin International <a href="mailto:jonathan.hooker@garmin.com">jonathan.hooker@garmin.com</a><o:p></o:p> </div> <o:p> </o:p> <div> <div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'> From: Agrawal, Rinky Sent: Wednesday, April 07, 2010 11:16 AM To: Hooker, Jonathan Subject: RE: [Spacewalk-list] Issue with Spacewalk 0.8 install on CentOS 5 and Oracle 11G<o:p></o:p> </div> </div> <o:p> </o:p> Jonathan,<o:p></o:p> <o:p> </o:p> <![if !supportLists]>1) <![endif]>I re-ran deploy.sql and received the same error<o:p></o:p> <![if !supportLists]>2) <![endif]>Also, changed the recid to 1 in the INSERT statements as suggested in the thread but still the same error.<o:p></o:p> <o:p> </o:p> Thanks<o:p></o:p> Rinky<o:p></o:p> <o:p> </o:p> <div> <div class=MsoNormal align=center style='text-align:center'> <hr size=2 width="100%" align=center> </div> From: Hooker, Jonathan Sent: Tuesday, April 06, 2010 5:46 PM To: Agrawal, Rinky Subject: RE: [Spacewalk-list] Issue with Spacewalk 0.8 install on CentOS 5 and Oracle 11G<o:p></o:p> </div> <o:p> </o:p> Did you try the deploy.sql not the main.sql? The deploy.sql is the one we want to import not the main.sql.<o:p></o:p> <o:p> </o:p> <div> Jonathan Hooker Desktop Support - Engineering Garmin International <a href="mailto:jonathan.hooker@garmin.com">jonathan.hooker@garmin.com</a><o:p></o:p> </div> <o:p> </o:p> <div> <div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'> From: Agrawal, Rinky Sent: Tuesday, April 06, 2010 11:39 AM To: Hooker, Jonathan Subject: RE: [Spacewalk-list] Issue with Spacewalk 0.8 install on CentOS 5 and Oracle 11G<o:p></o:p> </div> </div> <o:p> </o:p> Jonathan,<o:p></o:p> <o:p> </o:p> Can you ask the same person who replied below?<o:p></o:p> <o:p> </o:p> Ask him that we are able to run the main.sql from SYSTEM user fine but not from the SPWK_APPS user and getting the below error. We have assigned all the SYSTEM privileges to SPWK_APPS user (see attached list of privilieges).<o:p></o:p> <o:p> </o:p> SQL> --------------------------------------------------------------------------------<o:p></o:p> SQL> -- Source: data/common/rhn_schedule_days.sql<o:p></o:p> SQL> --------------------------------------------------------------------------------<o:p></o:p> SQL><o:p></o:p> SQL><o:p></o:p> SQL><o:p></o:p> SQL> INSERT INTO rhn_schedule_days<o:p></o:p> 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)<o:p></o:p> 3 VALUES<o:p></o:p> 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);<o:p></o:p> INSERT INTO rhn_schedule_days<o:p></o:p> *<o:p></o:p> ERROR at line 1:<o:p></o:p> ORA-02291: integrity constraint (SPWK_APPS.RHN_SCHDY_SCHED_SCHEDULE_ID_FK)<o:p></o:p> violated - parent key not found<o:p></o:p> <o:p> </o:p> <o:p> </o:p> Thanks. Let me know if you’ve any questions.<o:p></o:p> Rinky<o:p></o:p> <o:p> </o:p> <div> <div class=MsoNormal align=center style='text-align:center'> <hr size=2 width="100%" align=center> </div> From: Agrawal, Rinky Sent: Thursday, March 25, 2010 4:32 PM To: Hooker, Jonathan Subject: RE: [Spacewalk-list] Issue with Spacewalk 0.8 install on CentOS 5 and Oracle 11G<o:p></o:p> </div> <o:p> </o:p> Jonathan,<o:p></o:p> <o:p> </o:p> I was getting some errors while I was running main.sql. As you said, we have to clean everything in the schema. But there were existing connection to the spwk_apps user, so I could not drop it. I created another new schema SPWK_ADMIN and still give me some errors.<o:p></o:p> <o:p> </o:p> Can you ask in the mailing list following question?<o:p></o:p> <o:p> </o:p> What kinds of user privileges are required to run Main.sql? I have given the sysdba privileges and still give me below error.<o:p></o:p> <o:p> </o:p> <o:p> </o:p> SQL> CREATE TABLE web_customer<o:p></o:p> 2 (<o:p></o:p> 3 id NUMBER NOT NULL<o:p></o:p> 4 CONSTRAINT web_customer_id_pk PRIMARY KEY<o:p></o:p> 5 USING INDEX TABLESPACE [[web_index_tablespace_2]],<o:p></o:p> 6 name VARCHAR2(128) NOT NULL,<o:p></o:p> 7 oracle_customer_id NUMBER<o:p></o:p> 8 CONSTRAINT web_customer_ocid_unq UNIQUE<o:p></o:p> 9 USING INDEX TABLESPACE [[web_index_tablespace_2]],<o:p></o:p> 10 oracle_customer_number NUMBER<o:p></o:p> 11 CONSTRAINT web_customer_ocn_unq UNIQUE<o:p></o:p> 12 USING INDEX TABLESPACE [[web_index_tablespace_2]],<o:p></o:p> 13 customer_type CHAR(1)<o:p></o:p> 14 DEFAULT ('P') NOT NULL<o:p></o:p> 15 CONSTRAINT web_customer_type_list<o:p></o:p> 16 CHECK (customer_type in ( 'B' , 'P' )),<o:p></o:p> 17 credit_application_completed VARCHAR2(1),<o:p></o:p> 18 created DATE<o:p></o:p> 19 DEFAULT (sysdate) NOT NULL,<o:p></o:p> 20 modified DATE<o:p></o:p> 21 DEFAULT (sysdate) NOT NULL<o:p></o:p> 22 )<o:p></o:p> 23 TABLESPACE [[web_tablespace_2]]<o:p></o:p> 24 ENABLE ROW MOVEMENT<o:p></o:p> 25 ;<o:p></o:p> USING INDEX TABLESPACE [[web_index_tablespace_2]],<o:p></o:p> *<o:p></o:p> ERROR at line 5:<o:p></o:p> ORA-02216: tablespace name expected<o:p></o:p> <o:p> </o:p> <o:p> </o:p> <div> <div class=MsoNormal align=center style='text-align:center'> <hr size=2 width="100%" align=center> </div> From: Hooker, Jonathan Sent: Monday, March 22, 2010 5:52 PM To: Agrawal, Rinky Subject: FW: [Spacewalk-list] Issue with Spacewalk 0.8 install on CentOS 5 and Oracle 11G<o:p></o:p> </div> <o:p> </o:p> Rinky,<o:p></o:p> <o:p> </o:p> Here is the email thread as well as the .sql file that needs to run… I am also forwarding one other email that pertains to this. Please let me know if you have any questions! Thanks for your help!<o:p></o:p> <o:p> </o:p> <div> Jonathan Hooker Desktop Support - Engineering Garmin International <a href="mailto:jonathan.hooker@garmin.com">jonathan.hooker@garmin.com</a><o:p></o:p> </div> <o:p> </o:p> <div> <div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'> From: spacewalk-list-bounces@redhat.com [mailto:spacewalk-list-bounces@redhat.com] On Behalf Of Eric Sent: Thursday, March 11, 2010 7:49 AM To: spacewalk-list@redhat.com Subject: Re: [Spacewalk-list] Issue with Spacewalk 0.8 install on CentOS 5 and Oracle 11G<o:p></o:p> </div> </div> <o:p> </o:p> <div> Jonathon, I had the exact same issue just a while back. <a href="https://www.redhat.com/archives/spacewalk-list/2010-February/msg00191.html" target="_blank">https://www.redhat.com/archives/spacewalk-list/2010-February/msg00191.html</a> We are running the script on Oracle RAC 11gR2. Our DBA ran the main.sql script using sqlplus client. <o:p></o:p> <div> -Eric<o:p></o:p> </div> <div> <o:p> </o:p> <div> <div class=MsoNormal align=center style='text-align:center'> <hr size=1 width="100%" align=center> </div> From: "Hooker, Jonathan" <Jonathan.Hooker@garmin.com> To: "spacewalk-list@redhat.com" <spacewalk-list@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<o:p></o:p> <div> Hi,<o:p></o:p> <o:p></o:p> 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:<o:p></o:p> <o:p></o:p> ORA-02291: integrity constraint (SPWK_APPS.RHN_SCHDY_SCHED_SCHEDULE_ID_FK)<o:p></o:p> violated - parent key not found<o:p></o:p> <o:p></o:p> And when we tried to manually populate the database using the main.sql from /etc/sysconfig/rhn/oracle we get the following error:<o:p></o:p> <o:p></o:p> ORA-02303: cannot drop or replace a type with type or table dependents<o:p></o:p> <o:p></o:p> In both cases we are able to tell that the database is getting partially populated, the population is just failing partway through.<o:p></o:p> <o:p></o:p> Any help is much appreciated! Thanks a bunch!<o:p></o:p> <o:p></o:p> Jonathan Hooker Desktop Support - Engineering Garmin International <a href="mailto:jonathan.hooker@garmin.com" target="_blank">jonathan.hooker@garmin.com</a><o:p></o:p> <o:p></o:p> </div> --------------------------------------------------------------------------------<o:p></o:p> 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.<o:p></o:p> <o:p></o:p> Thank you for your cooperation.<o:p></o:p> </div> </div> </div> <o:p> </o:p> </div> </body> </html>