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 : 23-04-2017
ORA-23432

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

  • ora-19683 : real and backup blocksize of file string are unequal
  • ora-13230 : failed to create temporary table [string] during R-tree creation
  • ora-15152 : cluster in rolling upgrade
  • ora-23532 : tables with different synchronization mechanisms are in the same group
  • ora-24337 : statement handle not prepared
  • ora-19726 : cannot plug data [string] at level string into database running at compatibility level string
  • ora-14307 : partition contains too many list values
  • ora-15014 : location 'string' is not in the discovery set
  • ora-00350 : log string of instance string (thread string) needs to be archived
  • ora-09934 : Link of current password file to old failed.
  • ora-06908 : CMX: error during transfer of ORACLE_SID
  • ora-30129 : invalid function argument received
  • ora-16525 : the Data Guard broker is not yet available
  • ora-38903 : DML error logging is not supported for abstract column "string"
  • ora-02145 : missing STORAGE option
  • ora-12066 : invalid CREATE MATERIALIZED VIEW command
  • ora-24047 : invalid agent name string, agent name should be of the form NAME
  • ora-25467 : table alias not specified
  • ora-12536 : TNS:operation would block
  • ora-01354 : Supplemental log data must be added to run this command
  • ora-07716 : sksachk: invalid device specification for ARCHIVE
  • ora-01343 : LogMiner encountered corruption in the logstream
  • ora-13703 : The snapshot pair [string, string] for database_id string and instance_id string are not found in the current repository.
  • ora-32823 : subscriber exists for queue string and destination string
  • ora-34719 : (NLSCHARSET03) Character data loss in NTEXT/TEXT conversion
  • ora-27154 : post/wait create failed
  • ora-38796 : Not enough flashback database log data to undo FLASHBACK.
  • ora-28275 : Multiple mappings for user nickname to LDAP distinguished name exist.
  • ora-01299 : dictionary string corresponds to a different database incarnation
  • ora-19572 : cannot process file string, file is being being resized
  • 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.