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 : 29-05-2017
ORA-28518

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

  • ora-30201 : Unable to load NLS data object
  • ora-16012 : Archive log standby database identifier mismatch
  • ora-16826 : apply service state is inconsistent with the DelayMins property
  • ora-02459 : Hashkey value must be a positive integer
  • ora-29832 : cannot drop or replace an indextype with dependent indexes
  • ora-21703 : cannot flush an object that is not modified
  • ora-32139 : Cannot write to the stream
  • ora-23327 : imported deferred rpc data does not match string of importing db
  • ora-16711 : the resource guard index is out of bounds
  • ora-32341 : The EXPLAIN_MVIEW facility failed to explain the materialized view "string"."string"
  • ora-27022 : skgfqsbi: could not allocate memory for media manager
  • ora-04089 : cannot create triggers on objects owned by SYS
  • ora-01424 : missing or illegal character following the escape character
  • ora-38856 : cannot mark instance string (redo thread string) as enabled
  • ora-38762 : thread string redo log with scn string could not be found
  • ora-40214 : duplicate setting: string
  • ora-22290 : operation would exceed the maximum number of opened files or LOBs
  • ora-38709 : Recovery Area is not enabled.
  • ora-19287 : XP0017 - invalid number of arguments to function - string:string
  • ora-36768 : (XSAGGCNTMOVE06) An aggregation variable and its AGGCOUNT must have the same base dimensions.
  • ora-14123 : duplicate NOREVERSE clause
  • ora-00981 : cannot mix table and system auditing options
  • ora-39077 : unable to subscribe agent string to queue "string"
  • ora-16561 : cannot remove an active instance
  • ora-09851 : soacon: Archmon unable to lock named pipe.
  • ora-15113 : alias name 'string' refers to a directory
  • ora-26082 : load of overlapping segments on table string.string is not allowed
  • ora-12991 : column is referenced in a multi-column constraint
  • ora-12715 : invalid character set specified
  • ora-25177 : UNRECOVERABLE option not permitted
  • 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.