ORA-28520: error initializing heterogeneous data dictionary translations

Cause : OARCEL awsu nbal et ortereiv edtaad itcinoayr rtasnltainosf o rteh onnO-rcal essytme nisatnec,p rboalbyb eacues hteu nedrylign adt adcitoinrayt albed ose onte xsito ri sf omre dicnorretcl.y

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

Vreiyf hta tteh ROALCEs evre'rsH eetrgoeenosu eSrivcse adt adcitoinrayw a sisntlalde ocrerclty .I fteh eHtreoegnoeu sSrevcie sdtaad itcinoayr si onti ntsalle,d xeeuct eteh ACTSH.QSLs cirp ti nteh O$RCAL_EHMOEr/dmbsa/dimnd iercotr.y fI htec onnetce daegn,t dietniife db yFSD_LCASS_ANM,E erqiurse acsutmo nisatlaltoins cirp tfro hteO RCAL Esrevre,v eirf ytahtt h esrcitp ahsb ene urn .I fbtohs cirpst ewr eeexctue dadn htee rorrp esritss ,cnotcatt h ecsutmoe rspuprotr erpeesnattvieo ft h eaegn tvnedro.

update : 18-08-2017
ORA-28520

ORA-28520 - error initializing heterogeneous data dictionary translations
ORA-28520 - error initializing heterogeneous data dictionary translations

  • ora-24045 : invalid agent address string, agent address should be of the form [SCHEMA.]NAME[@DATABASE LINK]
  • ora-15203 : diskgroup string contains disks from an incompatible version of ASM
  • ora-38742 : Flashback log file has incorrect log reset status.
  • ora-01300 : writable database required for specified LogMiner options
  • ora-32146 : Cannot perform operation on a null date
  • ora-39213 : Metadata processing is not available
  • ora-30184 : argument type not compatible with a format code
  • ora-01627 : rollback segment number 'string' is not online
  • ora-00290 : operating system archival error occurred. See error below
  • ora-02428 : could not add foreign key reference
  • ora-13371 : invalid position of measure dimension
  • ora-23347 : datatype string for column string table string not supported
  • ora-00307 : requested INSTANCE_NUMBER out of range, maximum is string
  • ora-19690 : backup piece release string incompatible with Oracle release string
  • ora-02397 : exceeded PRIVATE_SGA limit, you are being logged off
  • ora-00150 : duplicate transaction ID
  • ora-19727 : cannot plug data [string] at level string into database running Oracle string
  • ora-03203 : concurrent update activity makes space analysis impossible
  • ora-36403 : (XSBADSPROP) number is an illegal value for system-reserved property string on workspace object.
  • ora-01105 : mount is incompatible with mounts by other instances
  • ora-25136 : this cluster can contain only one table
  • ora-13844 : no new SQL profile name or category specified.
  • ora-01303 : subordinate process error: number. Check alert and trace logs
  • ora-01284 : file string cannot be opened
  • ora-12813 : value for PARALLEL or DEGREE must be greater than 0
  • ora-06029 : NETASY: port assignment failure
  • ora-12155 : TNS:received bad datatype in NSWMARKER packet
  • ora-30349 : specified dimension hierarchy does not exist
  • ora-04053 : error occurred when validating remote object stringstringstringstringstring
  • ora-09273 : szrfc: error verifying role name
  • 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.