[Spacewalk-list] Spacewalk 1.4 and Oracle 11g
Jan Pazdziora
jpazdziora at redhat.com
Wed May 4 12:45:33 UTC 2011
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
More information about the Spacewalk-list
mailing list