locked
About Oracle RAC publication RRS feed

  • Question

  • Hi All,

    We know that we can make use Oracle as the publisher and SQLServer as the subscriber.
    But how about Oracle RAC?
    Should I create the publication on each node or anyone of the nodes? 

    Thanks in advance.


    it's time to start living the life you are imagined.

    Monday, May 28, 2012 3:32 AM

Answers

  • Hi Molly1023,

    What I know the Oracle RAC is as:
    In an Oracle RAC environment, two or more computers (each with an instance) concurrently access a single database. This allows an application or user to connect to either computer and have access to a single coordinated set of data.

    In this case, it might be reasonable to create the publication on each node.


    Stephanie Lv

    TechNet Community Support

    Tuesday, May 29, 2012 1:51 AM

All replies

  • Hi Molly1023,

    What I know the Oracle RAC is as:
    In an Oracle RAC environment, two or more computers (each with an instance) concurrently access a single database. This allows an application or user to connect to either computer and have access to a single coordinated set of data.

    In this case, it might be reasonable to create the publication on each node.


    Stephanie Lv

    TechNet Community Support

    Tuesday, May 29, 2012 1:51 AM
  • Thanks Stephanie,

    So, I should create the publication on each node?

    Molly


    it's time to start living the life you are imagined.

    Tuesday, May 29, 2012 2:24 AM