Master not a Master?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Master not a Master?

  1. #1
    Join Date
    Mar 2002
    Posts
    29
    Hello all,

    I have a problem with setting Snapshot group. After specifying remote DB TEST, master site "MASTER_GRP1", adding objects from MASTER_GRP1..etc. After all that, i press create, and i get error ORA-23313. Now i have explanation for this error, but its very confusing as my master site is realy a master...i meen it has a master group. Exact error is as folows :

    ORA-23313 : Object group "PULIC"."MASTER_GRP1" is not mastered at TEST.US.ORACLE.COM.

    My eye points to that "TEST.US.ORACLE.COM" as it shouldent be like that, but again i have set GLOBAL_NAMES = false.

    Any help would be apriciated...

    Thanks in advanced !

  2. #2
    Join Date
    May 2001
    Posts
    736
    Since in other post u mentioned that u solved the DB link problem can u able to test the link . Since the link at Snapshot site is not able to identify the Master site u are getting this error.Finally what is your OS.
    regards
    akhadar

    [Edited by akhadar on 04-29-2002 at 06:32 AM]

  3. #3
    Join Date
    Mar 2002
    Posts
    29
    Hello,

    My OS is Win2000 Prof. Problem is that the link is working....i can access Master site without problems now, and i can see object on it.

  4. #4
    Join Date
    May 2001
    Posts
    736
    what type of Oracle version and what type of Snapshot u are trying to create be in detail.Are u using Replication Manager?

  5. #5
    Join Date
    Mar 2002
    Posts
    29
    I am using Oracle EE 8.1.7, dooing rep with DBA Manager, since there is no Rep Manager in this version. I am trying to do Snapshot replication...master to snap..and viceversa.

    Another problem i have is what ever i enter in snapshot table gets overwrited with date from master site. I want two-way replication, but cant find option for that...

    Thanks

    [Edited by Helix on 04-29-2002 at 10:55 AM]

  6. #6
    Join Date
    May 2001
    Posts
    736
    Means your transactions at Snapshot are rollbacked due to contention. check for any errors at Master site mostly which tables are effected by contention. What about Snapshot logs did u created at Master site? .If u are creating Updateable snapshots with Fast refresh it is always advisable to create Snapshot logs at Master site. Try these options.
    regards
    akhadar



  7. #7
    Join Date
    Mar 2002
    Posts
    29
    Ok, as i understand in DBA Studio, Snapshot group is used to create updateable snapshots, and Shapshots is used to create read-only snapshots right? i am confused about this.

    Problem is i cant create Snapshot group, becuase i get error i explained in my first post in this thread.

  8. #8
    Join Date
    May 2001
    Posts
    736
    U are confusing between updateable snapshots and read only,since in updateable snapshots u can do update,delete,insert which are replicated to Master. In the same way u can create Read only snapshots which are used only to query depending on the business needs and are updatad by Master on time bound basis.
    Since iam using Oracle 8.1.6 in which i used Replication Manager to create all the replication activities by simply following the wizard.
    yes indeed u can find the Replicaton manager by installing the Oracle Enterprise Manager release 2.2 which comes along with 8.1.7 where in the DBA studio u will find the this tool. Try to use this tool.
    all the best
    akhadar


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