在Oracle Streams中配置Capture时,出现ORA-00439错误,提示未启用功能:Streams Capture
根据oracle文档中的要求,已经配置好各种先决条件,仍然出现该错误,请问各位应该如何处理?
Oracle版本为10g R2,运行在归档模式下。
创建Capture的代码如下:BEGIN
DBMS_STREAMS_ADM.ADD_TABLE_RULES(
table_name => 'scott.address',
streams_type => 'capture',
streams_name => 'stream1_capture2',
queue_name => 'streamsadmin.streams_queue_3',
include_dml => true,
include_ddl => true ,
include_tagged_lcr => false,
source_database => NULL,
inclusion_rule => true
);
END;
根据oracle文档中的要求,已经配置好各种先决条件,仍然出现该错误,请问各位应该如何处理?
Oracle版本为10g R2,运行在归档模式下。
创建Capture的代码如下:BEGIN
DBMS_STREAMS_ADM.ADD_TABLE_RULES(
table_name => 'scott.address',
streams_type => 'capture',
streams_name => 'stream1_capture2',
queue_name => 'streamsadmin.streams_queue_3',
include_dml => true,
include_ddl => true ,
include_tagged_lcr => false,
source_database => NULL,
inclusion_rule => true
);
END;
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
Streams Capture
FLASE或有办法将参数Streams Capture的值改为TRUE吗?
SQL> select * from v$option where parameter =’Advanced Replication‘; PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
Advanced Replication
FLASE
1. 不支持Streams,又少了一个高可用性的可行性方案
2. 不支持Advanced Replication的multimaster方式,再少一个高可用性方案,当然实体化视图的复制方案仍然是支持的解决需:1.安装企业版 2.安装Advanced Replication 组件 3.执行CATREP.SQL 。
fact: Advanced Replication Option
fact: Replication Manager
fact: Oracle Server - Standard Edition
symptom: Creating master group
symptom: ORA-00439: feature not enabled: %s
symptom: Advanced Replication Option not found in v$option
cause: Advanced Replication Option is not part of Standard Editionfix:
1. Install Enterprise Edition (see Note 117048.1)
2. Install Advanced Replication Option using installer
3. Run CATREP.SQL script
UNIX: $ORACLE_HOME/rdbms/admin/catrep.sql
NT: ORACLE_HOME\rdbms\admin\catrep.sql