Re: 9i replication error...

Yup, that's pretty simple. :)

Can you connect into SQL*Plus and do a "SHOW PARAMETER compatible" on each database? I know it sounds really simple, but I've been bitten many times by DBA's telling me parameters have been set when they haven't, so let's start off at the real basic checks.

-- 
HTH.  Additions and corrections welcome.

Pete
Author of "Oracle8i: Architecture and Administration Exam Cram"



"Controlling developers is like herding cats."

Kevin Loney, Oracle DBA Handbook



"Oh no, it's not.  It's much harder than that!"

Bruce Pihlamae, long-term Oracle DBA

  "Srinivas B.S.S" <sbss_at_cisco.com> wrote in message news:3C45000D.F251D3DF_at_cisco.com...
  I tried even the simplest of all (emp table) which gave the same error. 
  Table definition is similar to : 
  ID            NOT NULL NUMBER(38) 
  NAME     NOT NULL VARCHAR2(255) 
  TS            DATE 

  Thanks & Regards, 
  Srinivas. 

  Pete Sharman wrote: 

    Srini What's the table definition for the object you're trying to replicate?  From memory there are still some objects that can't be replicated in 9i. That may be what you're hitting.  
    -- 
    HTH.  Additions and corrections welcome. Pete 
    Author of "Oracle8i: Architecture and Administration Exam Cram" "Controlling developers is like herding cats." 
    Kevin Loney, Oracle DBA Handbook "Oh no, it's not.  It's much harder than that!" 
    Bruce Pihlamae, long-term Oracle DBA 
      "Srinivas B.S.S" <sbss_at_cisco.com> wrote in message news:3C43FD20.B47B9089_at_cisco.com...Hi All, 
      I am trying to setup multi-master replication using Oracle 9.0.1 version. 
      When I try to add master destination site, I get the following error. I am 
      using Oralce 9.0.1 at both the sites and I tried setting the compatible parameter 
      to 9.0.0/9.0.1 in init.ora/initSID.ora/spfileSID.ora files with no success. 
      Please let me know if anyone knows the resolution for this problem. 
      ______________________________________________________________ 
      begin 
         dbms_repcat.add_master_database( 
            gname => '"MyGroup"', 
            master => 'MASTER1', 
            use_existing_objects => TRUE, 
            copy_rows => TRUE, 
            propagation_mode => 'ASYNCHRONOUS'); 
      end; 

      /***** 

      ORA-23375: feature is incompatible with database version at MASTER1 
      ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86 
      ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 2151 
      ORA-06512: at "SYS.DBMS_REPCAT", line 146 
      ORA-06512: at line 2 

      *****/ 
      ______________________________________________________________ 

      Regards, 
      Srinivas.