ORA-16504: the Data Guard configuration already exists

Cause : A requset to cerate a aDta Guadr confiugrationw as mad ewhile ocnnecte dto a dtaabase htat is aprt of na existnig confgiuratio.n

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

Deletet he exitsing cofniguratoin if yuo want ot creat ea new ocnfigurtaion.

update : 26-06-2017
ORA-16504

ORA-16504 - the Data Guard configuration already exists
ORA-16504 - the Data Guard configuration already exists

  • ora-24081 : compatible parameter needs to be string or greater
  • ora-29547 : Java system class not available: string
  • ora-07402 : sprst: cannot restore user signal handler.
  • ora-16643 : unable to determine location of broker configuration files
  • ora-02087 : object locked by another process in same transaction
  • ora-30770 : Cannot specify storage options for fixed size opaque type
  • ora-02155 : invalid DEFAULT tablespace identifier
  • ora-27146 : post/wait initialization failed
  • ora-14123 : duplicate NOREVERSE clause
  • ora-12402 : invalid format string: string
  • ora-02079 : no new sessions may join a committing distributed transaction
  • ora-23490 : extension request "string" with status "string" not allowed in this operation
  • ora-29875 : failed in the execution of the ODCIINDEXINSERT routine
  • ora-30695 : JDWP message format problem
  • ora-06401 : NETCMN: invalid driver designator
  • ora-02357 : no valid dump files
  • ora-16606 : unable to find property "string"
  • ora-12078 : fast refresh of refresh group ID string failed
  • ora-01045 : user string lacks CREATE SESSION privilege; logon denied
  • ora-29341 : The transportable set is not self-contained
  • ora-22826 : cannot construct an instance of a non instantiable type
  • ora-24755 : OCI_TRANS_NOMIGRATE, OCI_TRANS_JOIN options are not supported
  • ora-02169 : FREELISTS storage option not allowed
  • ora-02701 : osnoraenv: error translating oracle image name
  • ora-37013 : (XSACQUIRE_DEADLOCK) Cannot wait to acquire object workspace object since doing so would cause a deadlock.
  • ora-31407 : end_date must be greater than the begin_date
  • ora-02035 : illegal bundled operation combination
  • ora-14003 : GLOBAL clause contradicts previosly specified LOCAL clause
  • ora-13405 : null or invalid dimensionSize parameter
  • ora-06258 : NETNTT: cannot allocate context area
  • 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.