[Spacewalk-list] Spacewalk 1.4 and Oracle 11g

[BUPE(Peter Burgstaller)]

Dear all,

I have the exact same issue with a vanilla RAC 11g V 11.2.0.2.0 installation.
The fix lets the database population finish.

- Cheers, Peter

On May 4, 2011, at 14:45, Jan Pazdziora wrote:

> On Wed, May 04, 2011 at 02:31:37PM +0200, Mario Mikocevic wrote:
>> 
>> following patch fixed it and it works now with external Oracle11g ->
>> 
>> # 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'));
> 
> Mario,
> 
> the problem is that we use the same construct
> 
> 	insert into table
> 	values (lookup_function_which_inserts_in_autonomous_transaction())
> 	
> all over the place. So fixing this one instance might help for this
> particular case but you will likely hit problems soon when actually
> running Spacewalk.
> 
> Could you please investigate some more why this doesn't work for you?
> 
> We've just tried on
> 
> 	Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
> 
> and the insert behaved as expected there. Do you have older version
> without patches, or newer version? Some strange settings which affects
> the transactional behaviour?
> 
> -- 
> Jan Pazdziora
> Principal Software Engineer, Satellite Engineering, Red Hat
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> 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] peter.burgstaller at skidata.com
[w] http://www.skidata.com