[Spacewalk-list] Spacewalk 1.4 and Oracle 11g

Mario Mikocevic mario.mikocevic at t-com.hr
Tue May 31 14:12:01 UTC 2011


Allrighty !

On 05/24/2011 01:29:13 PM, Jan Pazdziora wrote:
> On Tue, May 24, 2011 at 12:10:41PM +0200, Mario Mikocevic wrote:
> > On 05/24/2011 12:03:36 PM, Jan Pazdziora wrote:
> > > On Tue, May 24, 2011 at 11:02:27AM +0200, Mario Mikocevic wrote:
> > > > 
> > > > Any progress on fixing Spacewalk 1.4 and Oracle 11.2.0.2.0 ?

[some lossy compression]

> Try to reproduce the problem with that SQL on that Oracle node
> directly -- thus, 64bit to 64bit and with (say) ORACLE_SID, thus no
> tnsname or similar stuff.

Finally got some success story -
after bugging my coleague DBA enough, he provided me with enough clues to
produce following patch

# diff -u main.sql.orig main.sql
--- main.sql.orig	2011-04-08 21:40:53.000000000 +0200
+++ main.sql	2011-05-31 09:47:44.000000000 +0200
@@ -12171,9 +12171,29 @@
 end;
 /
 
+-- HERE FIX
+
+insert into rhnChecksum select * from rhnChecksum where 0 = 1;
+insert into rhnClientCapabilityName select * from rhnClientCapabilityName where 0 = 1;
+insert into rhnConfigFileName select * from rhnConfigFileName where 0 = 1;
+insert into rhnConfigInfo select * from rhnConfigInfo where 0 = 1;
+insert into rhnCve select * from rhnCve where 0 = 1;
+insert into rhnPackageEvr select * from rhnPackageEvr where 0 = 1;
+insert into rhnPackageCapability select * from rhnPackageCapability where 0 = 1;
+insert into rhnPackageDelta select * from rhnPackageDelta where 0 = 1;
+insert into rhnPackageName select * from rhnPackageName where 0 = 1;
+insert into rhnPackageNEVRA select * from rhnPackageNEVRA where 0 = 1;
+insert into rhnSourceRPM select * from rhnSourceRPM where 0 = 1;
+insert into rhnTag select * from rhnTag where 0 = 1;
+insert into rhnTagName select * from rhnTagName where 0 = 1;
+insert into rhnTransactionPackage select * from rhnTransactionPackage where 0 = 1;
+
+commit;
+
 
 -- Source: data/common/rhnArchType.sql
-    insert into rhnArchType (id, label, name) values
+
+insert into rhnArchType (id, label, name) values
 	(sequence_nextval('rhn_archtype_id_seq'), 'rpm', 'RPM');
 insert into rhnArchType (id, label, name) values
 	(sequence_nextval('rhn_archtype_id_seq'), 'deb', 'DEB');


so far so good, channels work, registering works, scheduling packet update works ..


-- 
T-Com
Odjel za upravljanje mrežom i uslužnim platformama /
/ Network and Service Platform Operations Department.
Radna jedinica za servisne mreže - T5.1.7
Mario Mikočević
Draškovićeva 26, Zagreb, 10000
+385  1 4913 800
+385  1 4913 860 (fax)
+385 98  470 801 (GSM)
mario dot mikocevic at t-com dot hr
http://www.t-com.hr 





More information about the Spacewalk-list mailing list