I would like to check if XA transactions are enabled by default on installation of Oracle10gR2 Enterprise, and 11g? I believe it is, however I wanted to know what controls this during the install.
I would also like to know how to verify if this is installed by interrogating the database with some query?
I've seen a similar post with no replies:
4261430
I also see many references from IBM's WebSphere documentation stating a need to initialise the JServer and XA transactions using initjvm.sql and initxa.sql. However I've also read resources that suggest the XA transaction support is installed by default:
'The initXA.sql script needs to be run before XA transactions will work. These are usually installed by default in 10gR2.'
http://download.oracle.com/docs/cd/E12461_01/130/installation_guide/Chapter%203%20-%20Database%20Installation%20Tasks.htm
Thanks,
Louis Burton