Hi,
it is working!
it is realy something! ;-)

Thanks a lot,
Jan Šoc

Dne 19.1.2012 14:15, BUPE(Peter Burgstaller) napsal(a):
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@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
[email protected]
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] [email protected]
[w] http://www.skidata.com


_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list



_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list

Reply via email to