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 : 27-04-2017
ORA-28520

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

  • ora-38413 : elementary attribute name may not be longer than 32 characters
  • ora-01266 : Unable to create unique file name
  • ora-03238 : unable to extend LOB segment string.string subpartition string by string in tablespace string
  • ora-25288 : AQ HTTP propagation encountered error, status-code number, string
  • ora-36404 : (XSSPROP04) Property string cannot be applied to an undimensioned (scalar) TEMPORARY variable.
  • ora-25013 : OLD and PARENT values cannot be identical
  • ora-01877 : string is too long for internal buffer
  • ora-30433 : 'string.string' is not a summary
  • ora-30369 : maximum number of columns is 32
  • ora-01974 : Illegal archive option
  • ora-12469 : no user levels found for user string and policy string
  • ora-19626 : backup set type is string - can not be processed by this conversation
  • ora-14504 : syntax not supported for analyze
  • ora-36393 : (XSMXCLEA03) When using the AGGREGATES, CHANGES or CACHE options, you must specify the ALL keyword.
  • ora-39088 : file name cannot contain a path specification
  • ora-02875 : smpini: Unable to get shared memory for PGA
  • ora-30079 : cannot alter database timezone when database has TIMESTAMP WITH LOCAL TIME ZONE columns
  • ora-37133 : (XSCCOMP08) You cannot write into an aggregated VARIABLE dimensioned by a COMPRESSED COMPOSITE. Use the CLEAR AGGREGATES command to reenable write access.
  • ora-38857 : cannot mark redo thread string as enabled
  • ora-15073 : diskgroup string is mounted by another ASM instance
  • ora-01632 : max # extents (string) reached in index string.string
  • ora-19500 : device block size string is invalid
  • ora-02733 : osnsnf: database string too long
  • ora-07759 : slemtr: invalid destination
  • ora-19044 : character length specified for XMLSerialize is too small.
  • ora-28357 : password required to open the wallet
  • ora-06030 : NETDNT: connect failed, unrecognized node name
  • ora-28500 : connection from ORACLE to a non-Oracle system returned this message:
  • ora-01145 : offline immediate disallowed unless media recovery enabled
  • ora-27201 : skgfpcm: sbtpccommit returned error
  • 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.