PGA-20961: synclevel 1 conversations not allowed when PGA_CAPABILITY=2_PHASE

PGA-20961: synclevel 1 conversations not allowed when PGA_CAPABILITY=2_PHASE
Cause: A conversation was requested at synclevel 1. The gateway init file specified PGA_CAPABILITY=2_PHASE. When 2-phase commit is enabled, synclevel 1 conversations are not supported, since they are not protected by 2-phase processing.
Action: Either use synclevel 2 for the conversation (if the remote transaction program supports it) or use a different gateway SID for this conversation.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:50

PGA-20961：当PGA_CAPABILITY = 2_PHASE时，不允许进行1级会话,
.原因：在synclevel 1中请求了一个会话。网关init文件指定了PGA_CAPABILITY = 2_PHASE。启用2阶段提交时，不支持同步级1对话，因为它们不受2阶段处理的保护。,
.操作：使用synclevel 2进行会话（如果远程事务程序支持它）或使用不同的网关SID进行此对话。,
.

aiaiDBA

13718043309

010-86462881

PGA-20961: synclevel 1 conversations not allowed when PGA_CAPABILITY=2_PHASE

1 个回答

相似问题