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 : 27-06-2017
ORA-23432

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

  • ora-32739 : Hang analysis aborted due to failed heap re-grow
  • ora-15097 : cannot SHUTDOWN ASM instance with connected RDBMS instance
  • ora-22608 : cannot add an attribute to the already generated image handle
  • ora-34059 : (MSEXECUT12) You cannot delete non session-only dimension values from unique concat dimension workspace object.
  • ora-16103 : Logical Standby apply must be stopped to allow this operation
  • ora-31406 : change source string is referenced by a change set
  • ora-37035 : (XSMLTDCL01) You can only DEFINE SESSION objects in analytic workspace string because it is attached in MULTI mode.
  • ora-06952 : Remote end of the communication issued a forward-reset packet.
  • ora-36950 : (XSFCAST22) The list of string values cannot have more than number members. You supplied number.
  • ora-16413 : Unsupported database type for ONDEMAND archivelog destinations
  • ora-02209 : invalid MAXTRANS option value
  • ora-01920 : user name 'string' conflicts with another user or role name
  • ora-30069 : Auto Undo-Management Error simulation - test site = string
  • ora-33000 : (AGOPEN00) AGGMAP workspace object cannot be accessed because it was compiled by a more recent version of string.
  • ora-09839 : removeCallback: callback port is not in the callback set.
  • ora-27123 : unable to attach to shared memory segment
  • ora-00234 : error in identifying or opening snapshot or copy control file
  • ora-09716 : kslcll: Unable to fix in-flux lamport latch.
  • ora-38445 : TOP clause not allowed with no statistics
  • ora-27469 : %s is not a valid string attribute
  • ora-08206 : ora_addr: cannot translate address file name
  • ora-34019 : (MSCGADD03) workspace object is not a LIST PARTITION TEMPLATE.
  • ora-00486 : ASMB process terminated with error
  • ora-14329 : domain index [sub]partitions cannot be renamed in this clause
  • ora-01198 : must specify size for log file if RESETLOGS
  • ora-09987 : unable to attach to SGA in READ-ONLY mode
  • ora-30089 : missing or invalid
  • ora-31090 : invalid database schema name "string"
  • ora-31182 : Too many PL/SQL DOM handles specified
  • ora-39145 : directory object parameter must be specified and non-null
  • 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.