Re: is the java option required to enable xa transactions?

  • From: "Roman Podshivalov" <roman.podshivalov@xxxxxxxxx>
  • To: Freek.DHooge@xxxxxxxxx
  • Date: Fri, 8 Feb 2008 09:22:05 -0500

Hi,

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.

HTH
--romas


On 2/8/08, D'Hooge Freek <Freek.DHooge@xxxxxxxxx> wrote:
>
> Hi,
>
> 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).
>
>
> Regards,
>
> Freek D'Hooge
> Uptime
> Oracle Database Administrator
> email: freek.dhooge@xxxxxxxxx
> tel +32(0)3 451 23 82
> http://www.uptime.be
> disclaimer
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>

Other related posts: