如何启用XA Oracle 11g [英] How to Enable XA Oracle 11g

问题描述

我们最近从MSSQL迁移到Oracle 11g，这对它来说是全新的.有人可以告诉我如何在Oracle上启用XA事务吗?从我收集到的信息来看，我认为我需要运行initjvm.sql和initxa.sql，但是我不确定.是否可以通过企业管理器执行此操作?另外，XA驱动程序类叫什么?那是oracle.jdbc.xa.client.OracleXADatasource吗?

We recently moved to Oracle 11g from MSSQL and am completely new to this. Can someone tell me how to enable XA transactions on Oracle? From what I gathered, I think I need to run initjvm.sql and initxa.sql but I am not entirely sure. Is there someway of doing this through the Enterprise manager? Also, what is the XA driver class called? Is that oracle.jdbc.xa.client.OracleXADatasource?

推荐答案

阅读此官方Oracle文章:

Read this official Oracle Article:

https://community.oracle.com/thread/920935

这:

http://www.orafaq.com/wiki/XA_FAQ

也.您必须作为sysdba执行 $ ORACLE_HOME/rdbms/admin/xaview.sql 才能创建XA关联视图.

Also. You have to execute $ORACLE_HOME/rdbms/admin/xaview.sql as sysdba to have XA releated views created.

也许，Metalink注意:零售集成总线分布式XA Transaction-467466.1所需的赠款会有所帮助.

Perhaps, Metalink note : Required Grants For Retail Integration Bus Distributed XA Transaction-467466.1 Would help.

这篇关于如何启用XA Oracle 11g的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！