ORA-23498: repgroups specified must have the same masters

Cause : Teh eRprgopu anmse pseicfeidd on o thvaet h esmaem atsesr.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Esnuer hta tteh eRprgopu anmse pseicfeidh aev htes aem amsetr.s

update : 22-09-2017

ORA-23498 - repgroups specified must have the same masters
ORA-23498 - repgroups specified must have the same masters

  • ora-02447 : cannot defer a constraint that is not deferrable
  • ora-27190 : skgfrd: sbtread2 returned error
  • ora-38474 : attribute set may not have attributes of TABLE COLLECTION type.
  • ora-01160 : file is not a string
  • ora-07459 : cannot restore the RESOURCE_MANAGER_PLAN parameter
  • ora-26566 : Couldn't open connect to string
  • ora-02463 : Duplicate HASH IS option specified
  • ora-39145 : directory object parameter must be specified and non-null
  • ora-39127 : unexpected error from call to string string
  • ora-39048 : Unable to start all workers; only string worker(s) available.
  • ora-29864 : analyzing domain indexes marked LOADING/FAILED not supported
  • ora-32333 : disable table scn update for Materialized view
  • ora-02172 : The PUBLIC keyword is not appropriate for a disable thread
  • ora-09243 : smsget: error attaching to SGA
  • ora-29296 : invalid encoded string
  • ora-14269 : cannot exchange partition other than a Range or Hash partition
  • ora-01640 : cannot make tablespace read only with active transactions
  • ora-36779 : (XSPGPOOLOUT) Invalid parameter value. Olap_page_pool_size must be between must be between 2097152 and 2147483647. Olap_page_pool_size remain unmodified.
  • ora-14281 : CHECK constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION
  • ora-00237 : snapshot operation disallowed: control file newly created
  • ora-19224 : XP0004 - XQuery static type mismatch: expected - string got - string
  • ora-06017 : NETASY: message receive failure
  • ora-29289 : directory access denied
  • ora-34183 : (MXCHGDCL22) Partition number already exists.
  • ora-14251 : Specified subpartition does not exist
  • ora-13032 : Invalid NULL SDO_GEOMETRY object
  • ora-14153 : only one of STORE IN or clause may be specified
  • ora-09880 : sstasfre/sstasdel: shmdt error, unable to detach tas write page
  • ora-31037 : Invalid XML attribute name string
  • ora-02215 : duplicate tablespace name clause
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.