[Spacewalk-list] Spacewalk 1.6 on Oracle

[BUPE(Peter Burgstaller)]

I have the same issue and use the following patch to work around the problem:

-----
# pwd
/etc/sysconfig/rhn/oracle
# diff -u main.sql-20110504 main.sql
--- main.sql-20110504	2011-04-08 21:40:53.000000000 +0200
+++ main.sql	2011-05-04 14:20:24.000000000 +0200
@@ -38940,6 +38940,12 @@


-- Source: data/common/rhnPackageSyncBlacklist.sql
+
+select lookup_package_name('gpg-pubkey') from dual;
+
+select lookup_package_name('rhns-ca-cert') from dual;
+
+select lookup_package_name('rhn-org-trusted-ssl-cert') from dual;

insert into rhnPackageSyncBlacklist (package_name_id)
	values (lookup_package_name('gpg-pubkey'));
-----

- Cheers, Peter

On Jan 19, 2012, at 14:03, Jan Pazdziora wrote:

> On Thu, Jan 19, 2012 at 01:49:19PM +0100, Jan Šoc wrote:
>> 
>> My oracle server is
>> SQL> select * from V$VERSION;
>> 
>> BANNER
>> --------------------------------------------------------------------------------
>> Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
>> PL/SQL Release 11.2.0.2.0 - Production
>> CORE    11.2.0.2.0      Production
>> TNS for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production
>> NLSRTL Version 11.2.0.2.0 - Production
>> 
>> 
>> and with install procedure i have:
>> 
>> [root at elektra]# spacewalk-setup --disconnected
>> * Setting up Oracle environment.
>> * Setting up database.
>> ** Database: Setting up database connection for Oracle backend.
>> Database service name (SID)? XXXXXX
>> Database hostname [localhost]? oracle.acme.com
>> Username? space_walk
>> Password?
>> ** Database: Testing database connection.
>> ** Database: Populating database.
>> *** Progress: ####################################################################
>> Could not populate database.
>> 
>> AND:
>> 
>> cat /var/log/rhn/populate_db.log|grep ORA
>> ORA-02291: integrity constraint (SPACE_WALK.RHN_PACKAGESYNCBL_PNID_FK) violated - parent key not found
>> 
>> could anyone help me? ;-)
> 
> You are hitting
> 
> 	https://www.redhat.com/archives/spacewalk-list/2011-May/msg00019.html
> 
> I suggest you escalate the issue to your Oracle support.
> 
> -- 
> Jan Pazdziora
> Principal Software Engineer, Satellite Engineering, Red Hat
> 
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list

--
DI Peter Burgstaller
-----------------------------------
Head of Hosted Services

SKIDATA AG
Untersbergstraße 40
A-5083 Grödig, Salzburg
[p] +43 (0) 6246 888-4155
[f] +43 (0) 6246 888-7
[e] peter.burgstaller at skidata.com
[w] http://www.skidata.com