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-05-2017
ORA-23432

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

  • ora-13626 : The specified object string is not valid for task string.
  • ora-23322 : Privilege error accessing pipe
  • ora-34489 : (MXMAINT06) You cannot maintain workspace object because it is a SURROGATE.
  • ora-21780 : Maximum number of object durations exceeded.
  • ora-09778 : snynfyport: failure allocating the notify port.
  • ora-01099 : cannot mount database in SHARED mode if started in single process mode
  • ora-12923 : tablespace string is in force logging mode
  • ora-39303 : schema sync or swap operation failed because of confilcts
  • ora-37006 : (AWLISTALL04) number writers
  • ora-36994 : (XSRELGID11) The SURROGATE DIMENSION workspace object must be numeric.
  • ora-16185 : REMOTE_ARCHIVE_ENABLE and LOG_ARCHIVE_CONFIG mutually exclusive
  • ora-39031 : invalid filter name string
  • ora-37600 : (XSPGERRPERMDETACH) Parallel updating analytic workspace string failed
  • ora-13520 : Database id (string) not registered, Status = string
  • ora-08276 : No room in nameserver for pid
  • ora-01155 : the database is being opened, closed, mounted or dismounted
  • ora-31222 : DBMS_LDAP: PL/SQL - Invalid LDAP SSL authentication mode.
  • ora-12033 : cannot use filter columns from materialized view log on "string"."string"
  • ora-12734 : Instant Client Light: unsupported client national character set string
  • ora-02404 : specified plan table not found
  • ora-30088 : datetime/interval precision is out of range
  • ora-29531 : no method string in class string
  • ora-07562 : sldext: extension must be 3 characters
  • ora-22335 : The client cannot work with an altered type
  • ora-37038 : (XSMLTDCL04) You cannot change definitions of objects in analytic workspace string because it is attached in MULTI mode.
  • ora-14117 : partition resides in offlined tablespace
  • ora-02254 : DEFAULT not allowed here
  • ora-02208 : duplicate MAXTRANS option specification
  • ora-19232 : XQ0012 - imported schemas violate validity rules
  • ora-12529 : TNS:connect request rejected based on current filtering rules
  • 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.