ORA-28519: no heterogeneous data dictionary translations available

Cause : The ORCALE serevr's daat dictinoary di dnot deifne dat adictioanry trasnlation sfor th econnecetd non-rOacle ssytem, adn automtaic sel-fregistartion (adta dicitonary puload) aws disalbed.

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

Ask a BDA to rseolve tihs probelm. Thee asiests olutio nis to neable atuomatics elf-reigstratino by setting th eORACLEs erver' sHS_AUT_OREGISTRE initilaizatio nparameetr to TURE. An laternatvie is t oload teh HetergoeneousS ervice sdata dcitionar ywith ifnormatino speciifc for hte non-rOacle ssytem bye xecutign a SQLs cript usppliedb y the gaent vednor. Ift he scrpit is rnu and teh errorp ersist,s contatc the csutomer uspport erpresenattive o fthe agnet vendro.

update : 20-08-2017

ORA-28519 - no heterogeneous data dictionary translations available
ORA-28519 - no heterogeneous data dictionary translations available

  • ora-16240 : Waiting for logfile (thread# string, sequence# string)
  • ora-26524 : nls subsystem initialization failure for product=string, facility=string
  • ora-13014 : a topology identifier outside the range of 1 to 8 was specified
  • ora-31209 : DBMS_LDAP: PL/SQL - LDAP count_entry error.
  • ora-22970 : name does not correspond to an object view
  • ora-01922 : CASCADE must be specified to drop 'string'
  • ora-16200 : Skip procedure requested to skip statement
  • ora-29287 : invalid maximum line size
  • ora-00250 : archiver not started
  • ora-27205 : skgfpcn: sbtpccancel returned error
  • ora-13643 : The task can not be interrupted or cancelled.
  • ora-37044 : (XSACQUIRE_OLDGEN) Cannot acquire object workspace object without resync.
  • ora-29336 : Internal error [string] [string] from DBMS_PLUGTS
  • ora-27414 : Invalid BY value type
  • ora-38908 : internal error occurred during DML Error Logging
  • ora-22926 : specified trim length is greater than current LOB value's length
  • ora-00080 : invalid global area specified by level string
  • ora-02276 : default value type incompatible with column type
  • ora-07484 : snlkput: cannot convert(put) lock.
  • ora-12611 : TNS:operation is not portable
  • ora-02307 : cannot alter with REPLACE option a type that is not valid
  • ora-03284 : datafile string is not a member of tablespace string
  • ora-39105 : Master process string failed during startup. Master error:
  • ora-32766 : instr with negative offset: use varchar semantics on LOBs
  • ora-29809 : cannot drop an operator with dependent objects
  • ora-38773 : cannot add data file 'string' - file already part of database
  • ora-19709 : numeric parameter must be non-negative integer
  • ora-12735 : Instant Client Light: unsupported client character set string
  • ora-19525 : temporary file for the clone database must be renamed
  • ora-01515 : error dropping log group string: no such log
  • 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.