ORA-23432: master site string already exists

Cause : An attempt was made to instantiate a replicated object group at a master site that was already a part of the object group.

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

If you were trying to add this site, do nothing because it already exists; otherwise, pick the name of another site, and re-run the routine.

update : 21-08-2017
ORA-23432

ORA-23432 - master site string already exists
ORA-23432 - master site string already exists

  • ora-30467 : internal data for filter number string is inconsistent
  • ora-28221 : REPLACE not specified
  • ora-39146 : schema "string" does not exist
  • ora-06974 : X.25 Driver: SID lookup failure
  • ora-08414 : error encountered in string
  • ora-09929 : GLB of two labels is invalid
  • ora-38787 : Creating the first guaranteed restore point requires mount mode when flashback database is off.
  • ora-12202 : TNS:internal navigation error
  • ora-29542 : class string already defined by source string
  • ora-40202 : column string does not exist in the input table string
  • ora-06044 : NETDNT: connect failed, byte count quota exceeded
  • ora-12985 : tablespace 'string' is read only, cannot drop column
  • ora-06808 : TLI Driver: could not link IPX and ethernet streams
  • ora-14025 : PARTITION may not be specified for a materialized view or a materialized view log
  • ora-02380 : profile string does not exist
  • ora-06790 : TLI Driver: poll failed
  • ora-02154 : a tablespace with the name 'string' is found
  • ora-16022 : LOG_ARCHIVE_DEST cannot be NULL because LOG_ARCHIVE_DUPLEX_DEST is non-NULL
  • ora-06131 : NETTCP: user access denied
  • ora-19693 : backup piece string already included
  • ora-00081 : address range [string, string) is not readable
  • ora-12826 : hung parallel query server was killed
  • ora-38746 : error occurred while restoring data block (file# string, block# string)
  • ora-15010 : name is already used by an existing ASM disk
  • ora-35018 : (QFCHECK01) The analytic workspace and EIF file definitions of workspace object have a mismatched data type.
  • ora-35952 : (XSSPFC01) The string dimension workspace object and the string dimension workspace object must have the same number of values in status for SPFCEXEC method number.
  • ora-01484 : arrays can only be bound to PL/SQL statements
  • ora-22620 : buffer size too small to hold the value
  • ora-27121 : unable to determine size of shared memory segment
  • ora-00068 : invalid value string for parameter string, must be between string and string
  • 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.