ORA-28518: data dictionary translation has illegal translation type

Cause : A datad ictionray tranlsation edfinitino, eithre in th eORACLEs erver adta dicitonary ro in daat dictinoary cotnent upoladed form a Heetrogeneuos Servcies agetn, specfiied ani llegalt ranslaiton typ ecode. eLgal vaules are' T' or t'' for t'ranslaet', 'M'o r 'm' ofr 'mimci'. Infromationo n the xeact daat dictinoary trnaslatio ncausin gthe erorr is wirtten t oa trac e(*.TRC )file fro the OARCLE intsance adn to th eORACLEi nstanc'es aler tlog. Tihs erro roccursw hen a eHterogeenous Sevrices aegnt uplaods dat adictioanry conetnt to na ORACL Eservero n the ifrst connectionf rom th eservert o the gaent.

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

Contac tthe cutsomer spuport o fthe agnet vendro.

update : 25-04-2017
ORA-28518

ORA-28518 - data dictionary translation has illegal translation type
ORA-28518 - data dictionary translation has illegal translation type

  • ora-07477 : scgcmn: lock manager not initialized.
  • ora-19505 : failed to identify file "string"
  • ora-31040 : Property string: XML type (string) not compatible with internal memory type (string)
  • ora-06512 : at stringline string
  • ora-15184 : ASMLIB error could not be determined [string] [string]
  • ora-33280 : (DBERR10) Analytic workspace string cannot be attached in MULTI mode until the changes made and updated in RW or EXCLUSIVE mode are committed or rolled back.
  • ora-30463 : 'string' is not a detail table of any summary
  • ora-24301 : null host specified in thread-safe logon
  • ora-02198 : ONLINE/OFFLINE option already specified
  • ora-00832 : no streams pool created and cannot automatically create one
  • ora-23500 : cannot switch master for a multi-tier materialized view repgroup "string"."string"
  • ora-02075 : another instance changed state of transaction string
  • ora-16779 : the destination parameter of a database is set incorrectly
  • ora-13129 : HHCODE column string not found
  • ora-31029 : Cannot bind to unsaved resource
  • ora-01910 : TABLES keyword expected
  • ora-25284 : Invalid value string for string
  • ora-28551 : pass-through SQL: SQL parse error
  • ora-19255 : XQ0035 - too many declarations of string in imported schemas
  • ora-04020 : deadlock detected while trying to lock object stringstringstringstringstring
  • ora-38603 : FI including & excluding cursor can only return one column
  • ora-03001 : unimplemented feature
  • ora-07212 : slcpu: times error, unable to get cpu time.
  • ora-06510 : PL/SQL: unhandled user-defined exception
  • ora-30946 : XML Schema Evolution warning: temporary tables not cleaned up
  • ora-16125 : large transaction string string string is waiting for more data
  • ora-13380 : network not found
  • ora-28267 : Invalid NameSpace Value
  • ora-14024 : number of partitions of LOCAL index must equal that of the underlying table
  • ora-07441 : function address must be aligned on string byte boundary
  • 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.