Re: is the java option required to enable xa transactions?
Date: Fri, 8 Feb 2008 09:22:05 -0500
The answer would be - it depends. If you want to utilize Oracle internal XA Transaction Manager (TM) - yes you need to install Jserver and run initxa.sql as a part of the installation. If Oracle participates in XA transaction just as a resource you should be fine without any additional configuration, but you have to use external TM (BEA, etc). It's rather confusing subject and this summer we spent a week trying to find all configuration details when we run into an issue with duplicated XA transactions.
On 2/8/08, D'Hooge Freek <Freek.DHooge_at_uptime.be> wrote:
> Do I need to install the java option in the db to enable XA transactions
> on the database?
> My database version is 10.2.0.3 (rac) and I have enabled DTP on the
> services by using dbms_monitor.modify_service and the services have been
> configured in a preferred / available setting (no server load balancing).
> Freek D'Hooge
> Oracle Database Administrator
> email: freek.dhooge_at_uptime.be
> tel +32(0)3 451 23 82