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 : 26-04-2017

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

  • ora-29389 : too many errors during validation
  • ora-39084 : cannot detach job string for user string
  • ora-19576 : datafile string not defined in control file
  • ora-00334 : archived log: 'string'
  • ora-29536 : badly formed source: string
  • ora-01924 : role 'string' not granted or does not exist
  • ora-12985 : tablespace 'string' is read only, cannot drop column
  • ora-13122 : invalid topo_geometry specified
  • ora-07476 : slsget: cannot get mapped memory statistics.
  • ora-09914 : Unable to open the ORACLE password file.
  • ora-06267 : NETNTT: bad state
  • ora-28035 : Cannot Get Session Key for Authentication
  • ora-13503 : Creating SYSAUX tablespace with invalid attributes
  • ora-23316 : the masterdef is string
  • ora-24000 : invalid value string, string should be of the form [SCHEMA.]NAME
  • ora-14644 : table is not subpartitioned by Hash method
  • ora-09754 : sppst: invalid process number passed to sppst.
  • ora-25331 : cannot downgrade because there are commit-time queue tables
  • ora-08343 : srclose: failed to close a redo server connection
  • ora-19803 : Parameter DB_RECOVERY_FILE_DEST_SIZE is out of range (1 - string)
  • ora-19244 : XQ0024 - invalid attribute node in element constructor
  • ora-16231 : DDL barrier
  • ora-31620 : file or device "string" cannot be specified for string operation
  • ora-24161 : name string does not exist in the name value pair list
  • ora-06434 : ssaio: read error, unable to read requested block from database file.
  • ora-19272 : XQ0052 - invalid atomic value in attribute or element constructor
  • ora-23290 : This operation may not be combined with any other operation
  • ora-06974 : X.25 Driver: SID lookup failure
  • ora-31605 : the following was returned from string in routine string: LPX-number: string
  • ora-23309 : object string.string of type string exists
  • 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.