Skip to Content

cluster table replication not working in SRS

As per documentation, SRS supports replication for Oracle cluster/pool table but I am not able to setup that. Even there is no mention as how to access a cluster table via Rep Agent for Oracle etc.

Is there any more documentation or anything you want to share

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 10, 2017 at 06:51 PM

    NOTE: While I work with SRS I do not have experience working with Oracle cluster/pool tables, so fwiw ...

    What documentation are you referring to?

    Have you looked through the SRS Heterogenous Replication Guide manual? [HINT: Search for 'cluster table' and 'pool table'.] According to this manual, pool table replication is not supported but cluster table replication is supported.

    The Heterogenous Replication Guide also has an example scenario for setting up Oracle cluster table replication into HANA. [While this may not be exactly like your scenario, perhaps there's enough into in the scenario to assist with your setup?]

    Are you trying to configure cluster table replication as part of a SAP application replication/DR setup? If so, have you tried searching SAP notes for details on what you're trying to do? Have you requested assistance from tech support? [It's my understanding that SAP routinely provides detailed notes for various DR setups/configurations.]

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 10, 2017 at 08:02 PM

    Thanks for your response, yes I referred to heterogeneous guide only.

    I followed the steps as mentioned and finished all of them.

    Now when I go to Rep Agent isql prompt and try to setup the cluster table ((e.g., BSEG); it says table not found.

    I checked with Basis team and as per them table doesn't exist in Oracle Database but in ERP application layer; hence am not able to access.

    Have you seen this scenarios or how do we actually setup table sitting ERP application layer.

    I have had a case opened with tech support for a long time but no concreate information.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 12, 2017 at 08:05 PM

    What was the actual command you issued, and the resulting error?

    Add comment
    10|10000 characters needed characters exceeded