DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Errors In Replication-ORA-00439: feature not enabled: Advanced replication

  1. #1
    Join Date
    Nov 2002
    Location
    hydreabad
    Posts
    34

    Errors In Replication-ORA-00439: feature not enabled: Advanced replication

    hi,
    I am doing the multi master replication. i git erreos executing the below staemet
    BEGIN
    DBMS_REPCAT.ADD_MASTER_DATABASE(
    gname => '"G10"',
    master => 'ORCL.US.ORACLE.COM',
    use_existing_objects => TRUE,
    copy_rows => TRUE,
    propagation_mode => 'SYNCHRONOUS');
    END;
    /

    Error:

    BEGIN
    *
    ERROR at line 1:
    ORA-00439: feature not enabled: Advanced replication
    ORA-06512: at "SYS.DBMS_SNAP_INTERNAL", line 302
    ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 2115
    ORA-06512: at "SYS.DBMS_REPCAT", line 146
    ORA-06512: at line 2
    Can any body help in this??/
    Venkata vara Prasad Kosaraju

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: Errors In Replication-ORA-00439: feature not enabled: Advanced replication

    It is because you need Oracle Enterprise Edition for AR.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  3. #3
    Join Date
    Nov 2001
    Location
    Planet Earth
    Posts
    116
    Did you install Advance Replication during oracle installation?

    to check
    SQL>select * from v$option where parameter = 'Advanced replication';

    PARAMETER VALUE
    ------------------------------ ------------------------------
    Advanced replication TRUE



    _________________________________
    Why on earth OCP is to be proud

  4. #4
    Join Date
    Nov 2002
    Location
    hydreabad
    Posts
    34
    It is showing
    SQL>select * from v$option where parameter = 'Advanced replication';

    PARAMETER VALUE
    ------------------------------ ------------------------------
    Advanced replication FALSE

    What are pre reqistts fro Replication
    Venkata vara Prasad Kosaraju

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by prasadkvv
    It is showing
    SQL>select * from v$option where parameter = 'Advanced replication';

    PARAMETER VALUE
    ------------------------------ ------------------------------
    Advanced replication FALSE

    What are pre reqistts fro Replication
    EE
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width