ORA-23532: tables with different synchronization mechanisms are in the same group

Cause : Tables belonging to the same replication group were specified to be cached with different synchronization mechanisms.

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

Do not specify different synchronization mechanisms while caching tables belonging to the same replication group.

update : 28-06-2017
ORA-23532

ORA-23532 - tables with different synchronization mechanisms are in the same group
ORA-23532 - tables with different synchronization mechanisms are in the same group

  • ora-24190 : length of payload exceeds string
  • ora-13037 : SRIDs do not match for the two geometries
  • ora-19769 : missing FILE keyword
  • ora-00079 : variable string not found
  • ora-27509 : IPC error receiving a message
  • ora-02147 : conflicting SHARED/EXCLUSIVE options
  • ora-01034 : ORACLE not available
  • ora-24366 : migratable user handle is set in service handle
  • ora-16760 : resource guard could not start SQL Apply
  • ora-04006 : START WITH cannot be less than MINVALUE
  • ora-22297 : warning: Open LOBs exist at transaction commit time
  • ora-16780 : a database has exhausted its archived redo log storage quota
  • ora-30565 : Only one INVALIDATE or UPDATE GLOBAL INDEXES clause may be specified
  • ora-12416 : policy string not found
  • ora-36691 : (NTEXTCNV02) Invalid escape sequence in argument to UNISTR function: string.
  • ora-30433 : 'string.string' is not a summary
  • ora-28166 : duplicate rolename in list
  • ora-24275 : function 'string' parameter 'string' missing or invalid
  • ora-12950 : SYSTEM tablespace specified as default permanent tablespace
  • ora-15039 : diskgroup not dropped
  • ora-29286 : internal error
  • ora-03298 : cannot shrink datafile - file string is under hot backup
  • ora-02244 : invalid ALTER ROLLBACK SEGMENT option
  • ora-30647 : error retrieving access parameters for external table string.string
  • ora-07849 : sllfsk: $GET failure
  • ora-12087 : online redefinition not allowed on tables owned by "string"
  • ora-26048 : Scoped REF column has wrong table name.
  • ora-22903 : MULTISET expression not allowed
  • ora-22991 : insufficient space allocated for argument string
  • ora-33100 : (APABBR02) Value 'number' is not valid for the workspace object option.
  • 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.