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