ORA-16012: Archive log standby database identifier mismatch

Cause : hT eadatabesi edtnfieisro fht erPmira yna dtSnabd yadatabesd oon tamct.hR meto erahcvilao ferodl gof lisei son tlaolew doti cnmoapitlb eTSNABD Yadatabesi snatcnse.

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

aTekt ehn ceseasyrs etspt orcaeett ehr qeiuer docpmtabielS ATDNYBd tabasa eeboferr teyrni ght eRAHCVI EOL Grpcoseisgn.

update : 26-04-2017

ORA-16012 - Archive log standby database identifier mismatch
ORA-16012 - Archive log standby database identifier mismatch

  • ora-01206 : file is not part of this database - wrong database id
  • ora-30384 : specified column name does not exist in the attribute
  • ora-25111 : creation of BITMAP cluster indices is not supported
  • ora-30200 : Wrong NLS item was passed into OCINlsGetInfo()
  • ora-24360 : Type Descriptor Object not specified for Object Bind/Define
  • ora-02807 : Allocation of memory for I/O vectors failed.
  • ora-12523 : TNS:listener could not find instance appropriate for the client connection
  • ora-24002 : QUEUE_TABLE string does not exist
  • ora-30017 : segment 'string' is not supported in string Undo Management mode
  • ora-02281 : duplicate or conflicting CACHE/NOCACHE specifications
  • ora-31088 : object "string"."string" depends on the schema
  • ora-01691 : unable to extend lob segment string.string by string in tablespace string
  • ora-36841 : (XSLMGEN11) Dimension string.string!string was not found
  • ora-00403 : %s (string) is not the same as other instances (string)
  • ora-36632 : (XSDUNION01) The concat dimension workspace object is not currently defined as UNIQUE.
  • ora-08187 : snapshot expression not allowed here
  • ora-27501 : IPC error creating a port
  • ora-14029 : GLOBAL partitioned index must be prefixed
  • ora-07629 : smpall: $EXPREG failure
  • ora-37177 : column string does not have any leaf values
  • ora-02402 : PLAN_TABLE not found
  • ora-30461 : 'string.string' cannot be refreshed because it is marked DISABLED
  • ora-19323 : Invalid url string
  • ora-16163 : LGWR network server host attach error
  • ora-09754 : sppst: invalid process number passed to sppst.
  • ora-24055 : cannot delete propagation status rows that are in prepared state
  • ora-39003 : unable to get count of total workers alive
  • ora-16589 : Data Guard Connection process detected a network transfer error
  • ora-36972 : (XSRELTBL13) Relation workspace object must be dimensioned by workspace object.
  • ora-02759 : Not enough request descriptors available
  • 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.