[Spacewalk-list] FW: Issue with Spacewalk 0.8 install on CentOS 5 and Oracle 11G
Hooker, Jonathan
Jonathan.Hooker at garmin.com
Fri Mar 26 14:43:52 UTC 2010
Guys,
Any idea on the below email?
Jonathan Hooker
Desktop Support - Engineering
Garmin International
Office: 913-440-2767
Helpdesk: 913-440-2000 or x2000
jonathan.hooker at garmin.com<mailto:jonathan.hooker at garmin.com>
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
Jonathan,
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.
Can you ask in the mailing list following question?
What kinds of user privileges are required to run Main.sql? I have given the sysdba privileges and still give me below error.
SQL> CREATE TABLE web_customer
2 (
3 id NUMBER NOT NULL
4 CONSTRAINT web_customer_id_pk PRIMARY KEY
5 USING INDEX TABLESPACE [[web_index_tablespace_2]],
6 name VARCHAR2(128) NOT NULL,
7 oracle_customer_id NUMBER
8 CONSTRAINT web_customer_ocid_unq UNIQUE
9 USING INDEX TABLESPACE [[web_index_tablespace_2]],
10 oracle_customer_number NUMBER
11 CONSTRAINT web_customer_ocn_unq UNIQUE
12 USING INDEX TABLESPACE [[web_index_tablespace_2]],
13 customer_type CHAR(1)
14 DEFAULT ('P') NOT NULL
15 CONSTRAINT web_customer_type_list
16 CHECK (customer_type in ( 'B' , 'P' )),
17 credit_application_completed VARCHAR2(1),
18 created DATE
19 DEFAULT (sysdate) NOT NULL,
20 modified DATE
21 DEFAULT (sysdate) NOT NULL
22 )
23 TABLESPACE [[web_tablespace_2]]
24 ENABLE ROW MOVEMENT
25 ;
USING INDEX TABLESPACE [[web_index_tablespace_2]],
*
ERROR at line 5:
ORA-02216: tablespace name expected
________________________________
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
Rinky,
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!
Jonathan Hooker
Desktop Support - Engineering
Garmin International
jonathan.hooker at garmin.com<mailto:jonathan.hooker at garmin.com>
From: spacewalk-list-bounces at redhat.com [mailto:spacewalk-list-bounces at redhat.com] On Behalf Of Eric
Sent: Thursday, March 11, 2010 7:49 AM
To: spacewalk-list at redhat.com
Subject: Re: [Spacewalk-list] Issue with Spacewalk 0.8 install on CentOS 5 and Oracle 11G
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<mailto: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/20100326/b25600fd/attachment.htm>
More information about the Spacewalk-list
mailing list