oracle分布式事务开启配置
由于要将超级用户下的表授权给普通用户使用,用户很谨慎的考虑到可能会对同一个数据库的其他用户和业务产生影响
grant select on sys.dba_pending_transactions to mtsbwtst;
grant select on sys.pending_trans$ to mtsbwtst;
grant select on sys.dba_2pc_pending to mtsbwtst;
grant execute on sys.dbms_system to mtsbwtst;
grant select on sys.dba_pending_transactions to mtsbw;
grant select on sys.pending_trans$ to mtsbw;
grant select on sys.dba_2pc_pending to mtsbw;
grant execute on sys.dbms_system to mtsbw;
需要执行以下四个脚本:
$ORACLE_HOME/rdbms/admin/initxa.sql
$ORACLE_HOME/rdbms/admin/xaview.sql
$ORACLE_HOME/javavm/install/initjvm.sql
$ORACLE_HOME/javavm/install/initxa.sql
以SYSDBA登录SQL Plus
执行如下代码
Sql代码
Java代码
grant select on sys.dba_pending_transactions to username;
grant select on sys.pending_trans$ to username;
grant select on sys.dba_2pc_pending to username;
grant execute on sys.dbms_system to username;
grant select on sys.dba_pending_transactions to username;
grant select on sys.pending_trans$ to username;
grant select on sys.dba_2pc_pending to username;
grant select on sys.dba_pending_transactions to username;
grant select on sys.pending_trans$ to username;
grant select on sys.dba_2pc_pending to username;
grant execute on sys.dbms_system to username;
grant select on sys.dba_pending_transactions to username;
grant select on sys.pending_trans$ to username;
grant select on sys.dba_2pc_pending to username;
grant execute on sys.dbms_system to username;
username ==> 获取oracle XA数据库连接的用户
参考:http://364434006.iteye.com/blog/981819
分享到:
相关推荐
纠结了半天的 java.lang.IllegalStateException: getOutputStream() has already。这个问题困扰了半天,在网上查阅了大量资料 出这个错误一般就是下面2个.....
NULL 博文链接:https://hw1287789687.iteye.com/blog/1925191
异常:Caused by: java.lang.IllegalStateException: Method has too many Body parameters Caused by: java.lang.IllegalStateException: Method has too many Body parameters: public abstract ...
1. java.lang.IllegalStateException: No wrapped connection. 2.java.lang.IllegalStateException: Adapter is detached. 原因: 1.单线程一次执行一个请求可以正常执行,如果使用多线程,同时执行多个请求时就会...
NULL 博文链接:https://anminer.iteye.com/blog/845067
java.lang.IllegalStateException: The content of the adapter has changed but ListView did not receive a notification. Make sure the content of your adapter is not modified from a background thread, but...
解决java.lang.IllegalStateException: unread block data的架包
Type 异常报告 消息 Failed to convert ... nested exception is java.lang.IllegalStateException: Cannot convert value of type 'java.lang.String' to required type 'java.util.Date': no matching editors or co
spring 总的概述。。。入门好教程~~~~~~~~~~~~~
weblogic12c部署webservice错误问题WSSERVLET11: 无法解析运行时描述符: java.lang.IllegalStateException: MASM0001:
docker上naocs访问不到本地mysql数据库报no dataSources set
SteganoImage 1.0 绿色版
各种数据库在JDBC中的连接方法.及在struts与hibernate中的配置..
因工作的缘故,有机会接触了Java本地方法调用(JNI)。本文中记下了初试JNI的过程和一点点体会。 使用Java的JNI调用C/C++的动态联结库有个固定的步骤,下面将以一个最简单的HelloWorld例子程序来说明调用过程。这个...
Jnative1.4_java调用动态库所需jar,里面包含了一个可以测试的动态库,可以自己拿下来玩玩。
2013-08-12 14:33:37.672:... Add CGLIB to your classpath.:java.lang.IncompatibleClassChangeError: class net.sf.cglib.core.DebuggingClassWriter has interface org.objectweb.asm.ClassVisitor as super class
今天公司springboot项目准备部署到...java.lang.IllegalStateException: 启动子级时出错 at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:720) at org.apache.catalina.core.Con
主要介绍了java 实现websocket的两种方式实例详解,一种使用tomcat的websocket实现,一种使用spring的websocket,本文通过代码给大家介绍的非常详细,需要的朋友可以参考下
这个存储库提供了一种在处理片段传输和后台任务时避免“java.lang.IllegalStateException:Can not perform this action after onSaveInstanceState”的方法。 您可以在的非常权威的阅读有关该问题和可能的解决方案...