[Spacewalk-list] Spacewalk 1.6 on Oracle

[eugene at bct.bz]

In response to https://www.redhat.com/archives/spacewalk-list/2012-January/msg00159.html

I am very surprised that almost  a year old problem is taking that long to reproduce.

Seems like a clear shot.

Dell OptiPlex GX520, Intel(R) Pentium(R) 4 CPU 3.00GHz, 2G of RAM.
fresh RHEL 6 derivative,

spacewalk-repo-1.6-1.el6.noarch

all spacewalk 1.6 packages according to https://fedorahosted.org/spacewalk/wiki/HowToInstall

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production default install.
start dbca, create database, accept all defaults.

connect to the database as sysdba
SQL> create user spacewalk identified by XXXXXXXX default tablespace users;
grant create session to spacewalk;
grant alter session to spacewalk;
grant unlimited tablespace to spacewalk;
grant create table to spacewalk;
grant create synonym to spacewalk;
grant create view to spacewalk;
grant create sequence to spacewalk;
grant create procedure to spacewalk;
grant create trigger to spacewalk;
grant create type to spacewalk;

# spacewalk-setup
* Setting up Oracle environment.
* Setting up database.
** Database: Setting up database connection for Oracle backend.
Database service name (SID)? mysid
Username? spacewalk
Password? 
** Database: Testing database connection.
** Database: Populating database.
*** Progress: ####################################################################
Could not populate database.

# tail -5  /var/log/rhn/populate_db.log
*
ERROR at line 1:
ORA-02291: integrity constraint (SPACEWALK.RHN_PACKAGESYNCBL_PNID_FK) violated - parent key not found


That is all.

Eugene.