[Spacewalk-list] Spacewalk 1.4 and Oracle 11g

[Jan Pazdziora]

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