ORA-16642: db_unique_name mismatch

Cause : Th eexepctde d_bunqiuen_am evaule idd ont amtc hth eacutald b_nuiqeu_nmae avlu efo rth edaatbaes taht hte rbokre cnotatcedu sign teh cnonetc iedntfiie rthta wsa assocaite dwiht taht adtaabse.

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

Veirfyt ha tth econnec tidnetiiferc orerctyl cnonetcs ot teh itnenedd adtaabse .Veirfyt ha tth enaem o fth edaatbaes taht hte rbokre epxecst t ofidn vai taht ocnncet dienitfire mtachse teh atcua ldbu_niuqe_anmef ort ha tdaatbaes.

update : 27-05-2017
ORA-16642

ORA-16642 - db_unique_name mismatch
ORA-16642 - db_unique_name mismatch

  • ora-14459 : missing GLOBAL keyword
  • ora-02037 : uninitialized speed bind storage
  • ora-16700 : the standby database has diverged from the primary database
  • ora-17622 : failed to deregister the memory with Oracle Disk Manager library
  • ora-01628 : max # extents (string) reached for rollback segment string
  • ora-39124 : dump file name "string" contains an invalid substitution variable
  • ora-40272 : apply rules prohibited for this model mode
  • ora-14178 : STORE IN (DEFAULT) clause is not supported for hash partitioned global indexes
  • ora-14156 : invalid number of subpartitions specified in [SUBPARTITIONS | SUBPARTITION TEMPLATE] clause
  • ora-23615 : Block number string does not exist for script string
  • ora-25226 : dequeue failed, queue string.string is not enabled for dequeue
  • ora-28556 : authorization insufficient to access table
  • ora-12819 : missing options in PARALLEL clause
  • ora-02320 : failure in creating storage table for nested table column string
  • ora-07255 : spini: cannot set up signal handler.
  • ora-24960 : the attribute string is greater than the maximum allowable length of number
  • ora-03281 : invalid ALLOCATE EXTENT option
  • ora-29540 : class string does not exist
  • ora-29874 : warning in the execution of ODCIINDEXALTER routine
  • ora-26724 : only SYS is allowed to set the Capture or Apply user to SYS.
  • ora-26747 : The one-to-many transformation function string encountered the following error: string
  • ora-24320 : unable to initialize a mutex
  • ora-19331 : Last argument to CREATE_DBURI operator must be a column
  • ora-36164 : (XSMXAGGR07) When using the COUNTVAR clause, the number of variables to be aggregated (number) must match the number of COUNTVAR variables (number).
  • ora-16743 : the status of redo transport service for standby database "string" is unknown
  • ora-16754 : resource guard could not activate standby database
  • ora-22899 : cannot specify both scope and rowid constraint on ref column
  • ora-13832 : category name specified is invalid
  • ora-16095 : Dependent destination removal for inactivation
  • ora-12709 : error while loading create database character set
  • 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.