ORA-25315 传播进程错误
ORA-25315: unsupported configuration for propagation of buffered messages
将propagation的queuetoqueue改为true即可
于是改为true
1、 怎么改为true 哪里改
2、 网上没有答案
SQL> select PROPAGATION_NAME,status,error_message,error_date,RULE_SET_NAME from dba_propagation;
PROPAGATIO STATUS ERROR_MESSAGE ERROR_DATE RULE_SET_N
---------- ---------- ------------------------- ------------------- ----------
QBJMES_TO_ ENABLED ORA-25315: unsupported co 2013-09-05 07:07:54 RULESET$_4
MES nfiguration for propagati 8
on of buffered messages 每天都在发帖，每天都在成长，就是没有人回复，我知道很难，这个知识也很偏，MAA的知识都不容易。 stream这个东西真心没搞过。但是我帮你查了一下，希望能帮到你。
官网上是这么说的：
If you have queue-to-dblink propagations created in a prior release of Oracle Database, you can re-create these propagation during a maintenance window to use queue-to-queue propagation. To re-create a propagation, complete the following steps:
1、Stop the propagation.
2、Make sure the source queue is empty.
3、Make sure that the destination queue is empty and has no unapplied, spilled messages before you drop the propagation.
4、Re-create the propagation with the queue_to_queue parameter set to TRUE in the creation procedure.
------------------------------------------------------------------------------------------------
Begin
Dbms_Streams_Adm.Add_Schema_Propagation_Rules
(Schema_Name => 'scott',
Streams_Name => 'TEST_to_STANDBY',
Source_Queue_Name => 'strmadmin.streams_queue',
Destination_Queue_Name => 'strmadmin.streams_queue@STANDBY.com',
Include_Dml => True,
Include_Ddl => True,
Source_Database => 'hxl.com',
Inclusion_Rule => True,
Queue_To_Queue => True
);
End;
官档地址：
http://docs.oracle.com/cd/B19306_01/server.102/b14228/best_prop.htm 谢谢 真心谢谢
郭哥 很敬业
要不得哈 这个是RAC环境 不是单机 单实例 你的发的那个我试过不行
不过谢谢 我还是自己看文档算了 求人不如求自己
很多人都么有弄过
当 有服务的时候都加存储 或者用OGG 谁用这个破玩意
只有我们公司搞 还是我自己搞
页:
[1]