ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Shareplex 7 activation failed due to horizontal partioning support limitation

Shareplex 7 activation failed due to horizontal partioning support limitation

原创 Linux操作系统 作者:zzhen163 时间:2011-03-29 11:32:56 0 删除 编辑
Below are the steps to fix the issue:

[oracle@db servers config]$ more /xxxxx/vardir_30001/temp/xxxxx.cfg

432:  TEST.TESTACCOUNT                 TEST.TESTACCOUNT                !TESTaccount_b_scheme
     Error --> Source is defined in line 428 with a horizontal partioning scheme - a table may be defined for horizontal partitioning only once

433:  TEST.TESTACCOUNTUSER             TEST.TESTACCOUNTUSER            !TESTaccountuser_b_scheme
     Error --> Source is defined in line 431 with a horizontal partioning scheme - a table may be defined for horizontal partitioning only once


1.    comment the lines 432 and 433
2.    login to splex30001
3.    col ROUTE for a60
4.    set pages 100 lines 250
5.    SQL> select PARTITION_SCHEME,ROUTE from SHAREPLEX_PARTITION;
6.    you can see 2 lines for TEST.TESTACCOUNT and 2 lines for TEST.TESTACCOUNTUSER       
7.    please update the route in the below format with same partition_schema name     
8.    update shareplex_partition set ROUTE = ‘dbservers-vip:pqagsb_pqaweb1@o.PQAWEB1_SPLEX + dbservers-vip:pqagsb_pqaopdb@o.PQAOPDB_SPLEX' where PARTITION_SCHEME = 'TESTaccount_scheme' ;
9.    update shareplex_partition set ROUTE = ‘dbservers-vip:pqagsb_pqaweb1@o.PQAWEB1_SPLEX + dbservers-vip:pqagsb_pqaopdb@o.PQAOPDB_SPLEX' where PARTITION_SCHEME = 'TESTaccountuser_scheme' ; commit;
10.    This should fix the issue and you will be able to activate the config file.
11.    for the below error  the table in 257th line should be repeating. so please comment the line 257 also.
12.    Error --> Source is defined in line 257 to same target
let me know if you have any questions.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/223555/viewspace-691194/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-09-27

  • 博文量
    35
  • 访问量
    64099