[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