比ORA-24777: 不允许使用不可移植的数据库链路更让人郁闷的事情
来源:互联网 发布:淘宝几毛钱的东西 编辑:程序博客网 时间:2024/06/04 17:49
ALTER SYSTEM SET DISPATCHERS="(PROTOCOL=TCP)" scope=both;
ALTER SYSTEM SET SHARED_SERVERS = 10 scope=both;
Using Database Links in Oracle XA Applications
Oracle XA applications can access other Oracle Database instances through database links with these restrictions:
They must use the shared server configuration.
The transaction processing monitors (TPMs) use shared servers to open the connection to an Oracle Database A. Then the operating system network connection required for the database link is opened by the dispatcher instead of a dedicated server process. This allows different services or threads to operate on the transaction.
If this restriction is not satisfied, then when you use database links within an XA transaction, it creates an operating system network connection between the dedicated server process and the other Oracle Database B. Because this network connection cannot be moved from one dedicated server process to another, you cannot detach from this dedicated server process of database A. Then when you access the database B through a database link, you receive an ORA-24777 error.
The other database being accessed must be another Oracle Database.
If these restrictions are satisfied, Oracle Database allows such links and propagates the transaction protocol (prepare, rollback, and commit) to the other Oracle Database instances.
If using the shared server configuration is not possible, then access the remote database through the Pro*C/C++ application by using EXEC
SQL
AT
syntax.
The init.ora
parameter OPEN_LINKS_PER_INSTANCE
specifies the number of open database link connections that can be migrated. Thesedblink
connections are used by XA transactions so that the connections are cached after a transaction is committed. Another transaction can use the database link connection if the user who created the connection also created the transaction. This parameter is different from the init
.ora
parameter OPEN_LINKS
, which specifies the maximum number of concurrent open connections (including database links) to remote databases in one session. The OPEN_LINKS
parameter does not apply to XA applications.
- 比ORA-24777: 不允许使用不可移植的数据库链路更让人郁闷的事情
- ORA-24777: 不允许使用不可移植的数据库链路
- 极其郁闷的一件事情 不允许使用PL/SQL Developer于此数据库
- 很郁闷的事情
- 郁闷的事情郁闷的解决方法郁闷的结果
- 让我郁闷的一件事情~
- 程序员在工作中遇到最郁闷的事情
- 不可错过的三件事情
- 郁闷的丹比月饼,还是我被丹比郁闷?
- 今天有2件比较郁闷的事情
- 在新浪开博客最郁闷的两件事情
- 最郁闷的事情?SSH2内容管理系统源码
- 近期关于eclipse和tomcat郁闷的事情
- 郁闷的访问mysql数据库
- IT人士比不可缺少的食物
- 郁闷的一比,又一次的被flash耍了
- 固有的不可移植的特征
- 固有的不可移植的特性
- 优秀的程序员和一般的程序员差别在哪?
- 我们常用的测试管理工具—JIRA篇
- Android DiskLruCache完全解析,硬盘缓存的最佳方案
- 一个简单打开D盘所有文件夹和文件的例子以及动态创建双击事件
- SendMessage(),PostMessage(),PostThreadMessage ()使用
- 比ORA-24777: 不允许使用不可移植的数据库链路更让人郁闷的事情
- DRUID连接池的使用
- 大数据处理之二
- switch语句中得case
- android helloworld级别学习
- iOS生成随机数
- 由底层和逻辑深入剖析c++系列
- 获取iphone的设备信息
- 关于FVID2_Frame结构体的一点疑惑